Notifications
Announcements
No record found.
Hi Experts,
Our requirement is to search a Search call "FROM" and call "TO" contacts in Phonecall record based on Contact's Phone Number using web API.
Could anyone confirm is it possible ? If yes,share us the web api for this.
Hi Kiruthigarani,
Both From and To are Party List type, you can use $expand. Once you get the party Id you can search in contacts. Below for reference.
https://[yourorg].crm8.dynamics.com/api/data/v9.1/phonecalls/?$expand=phonecall_activity_parties
Hope this helps
Best Regards
PG
shall we do it in single API?
You have to first fetch the contact Id filter by the Contact's Phone number using the below query.
https://yourorg.crm.dynamics.com/api/data/v9.1/contacts/?$filter=telephone1 eq '123456789'
After that use the below query
https://yourorg.crm.dynamics.com/api/data/v9.1/phonecalls/?$expand=phonecall_activity_parties($filter=_partyid_value eq '25A17064-1AE7-E611-80F4-E0071B661F01')
If a Phone Call activity has From and To as Contacts, the phonecall-activity_parties will retrieve the records.
You can also use the below fetch XML and pass it to the Web API
https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/webapi/retrieve-and-execute-predefined-queries#use-custom-fetchxml
You can use the FetchXmlBuilder to generate oData queries from FetchXML
Instead of 2 webapi calls, we can look for expand attribute in webapi
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tom_Gioielli 55 Super User 2025 Season 2
Daniyal Khaleel 27 Most Valuable Professional
Soundari 15
