Announcements
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.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Abhilash Warrier 51 Super User 2026 Season 1
Muhammad Shahzad Sh... 51 Most Valuable Professional
Nagaraju_Matta 50
