How to search the related fields like Opportunities and Cases using the Account email without using the record ID in the API?
For Example:
POST https://{domain_url}/rest/v10/Accounts/filter
{ "filter": [ { "email_addresses.email_address": { } } ]}The above API and filter is used to search the accounts using filterPOST https://{domain_url}/rest/v10/Opportunities/filter{ "filter": [ { "accounts.phone_office": { "$contains": "419%615%5671" } } ]}The Above API to filter Opportunities based upon accounts phone number.And to make a mention, I have tried the filter using "accounts.email_addresses.email_address" [array of array object].Please help me if know how to solve this problem.