5
I've been looking for an API endpoint in Dynamics365 API which provides us with the SystemUser along with their associated Contacts. Please redirect me to an appropriate documentation.
For ex. EmailID xyz@abc.com should be the input parameter of the API and this endpoint should return all the contacts associated with it.
Hello,
Please use below endpoint for your requirement -
org50b8451e.crm8.dynamics.com/.../contacts eq 0 and Microsoft.Dynamics.CRM.EqualUserId(PropertyName='ownerid'))
Replace instance url with your crm instance url.
Please mark my answer verified if this is helpful!
Regards,
Bipin Kumar
Follow my Blog: xrmdynamicscrm.wordpress.com/
Dynamics can be queried using IOrganizationService or the Web API endpoint, here a docs page regarding Web API:
https://docs.microsoft.com/en-us/powerapps/developer/data-platform/webapi/overview
to create the Web API queries you can use my tool Dataverse REST Builder (link in my signature), if you need to use IOrganizationService (usually with the official C# SDK) there are plenty of examples like blog posts and videos on how to use the CrmServiceClient object
Hey Steve,
I was looking for a API endpoint that would give me the list of active contacts associated with the system user.
From the UI the page looks like this, although in this case it is empty for other accounts it shows a list of contacts. I was looking for an endpoint to return this same data from API.
Hi Dynamics365 API,
If you think my answer help you, please verity it. Thanks a lot.
If you have any other doubt related to this issue, feel free to ask.
Hi Dynamics365 API,
I'm not sure what's their associated Contacts mean, the Contacts created by the User or the Contacts' owner? But I think $expand could do this. Below this is the URL which gets the users filtered by Email along with the contacts whose owner is him.
var url = "https://xxxx.crm.dynamics.com/api/data/v9.2/systemusers?$select=fullname&$filter=internalemailaddress eq '" email_address "'&$expand=contact_owning_user($select=fullname)";
Reference:
Retrieve a table row using the Web API (Microsoft Dataverse) - Power Apps | Microsoft Docs
systemuser EntityType (Microsoft.Dynamics.CRM) | Microsoft Docs
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (