web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Service | Customer Service, Contact Center, Fie...
Unanswered

How to search a call "FROM" and call "TO" contacts in Phonecall record based on entity's Phone number

(0) ShareShare
ReportReport
Posted on by

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.

I have the same question (0)
  • Pankaj Gogoi Profile Picture
    3,177 on at

    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

  • Community Member Profile Picture
    on at

    Pankaj G

    shall we do it in single API?

  • Pankaj Gogoi Profile Picture
    3,177 on at

    Hi Kiruthigarani,

    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

    pastedimage1597094306442v1.png

    Hope this helps

    Best Regards

    PG

  • venkatsr Profile Picture
    User Group Leader on at

    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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1
11manish Profile Picture

11manish 36

#2
Mallesh Deshapaga Profile Picture

Mallesh Deshapaga 32

#3
ManoVerse Profile Picture

ManoVerse 30 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans