Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Dynamics 365 general forum / Query related to WebAPI
Dynamics 365 general forum
Suggested answer

Query related to WebAPI

(0) ShareShare
ReportReport
Posted on by Manish_Dyanamics 40

Hi All,

I am trying to write a web API query to filter my case records with the Assigned To user field and status of the case if it is Active. Assignedto Field in my case table is a lookup field. I am able to fetch all the records but struggling to filter the records with specific user. Can someone help me?

https://bny-d36-test-uat.crm.dynamics.com/api/data/v9.1/incidents?$select=title,ticketnumber,bnym_assignedtoId&$expand=bnym_assignedtoId($select=fullname)

pastedimage1616846947254v1.png

Categories:
Customization / Solutions / SDK and API
  • Suggested answer
    a33ik Profile Picture
    a33ik 84,321 Most Valuable Professional on at
    RE: Query related to WebAPI

    Hello,

    If you want to build your requests easier start using CrmRestBuilder - github.com/.../2.6.0.0

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,647 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans