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 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.