AnsweredAssumed Answered

Related Entity Search Filter

Question asked by Muthu Kumar on Mar 3, 2019

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": {
        "$contains": "test@sugar.com"
      }
    }
  ]
}
The above API and filter is used to search the accounts using filter
POST 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.

Outcomes