Where clause in API GET Example

[eduardofendrich]

Anyone has an example that shows how I filter an entity by one specific team?

$where = [
[
'type' => 'equals',
'attribute' => 'teams.name',
'value' => 'The A Team',
],
];

$response = $client->request('GET', 'Users', ['where' => $where]);

I got "SelectManager::checkWhere: Complex expressions are forbidden" error message.

I found some "where" examples, but only with entity fields, nothing about relationships.



Thanks

[eduardofendrich]

Solved. Use "linkedWith" option.

https://github.com/espocrm/documentation/blob/master/docs/development/api-search-params.md