Microsoft Dynamics 365 | Integration, Dataverse...

Appropriate Dynamics 365 API URL to find the system user along with associated contacts

(0) Share

Report

Posted on by Dynamics365 API

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.

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Community Member on at

Like (1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Dynamics365 API 5 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Guido Preite 54,086 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,985 Moderator on at

Like (0)

Report
Copy link

Link copied!

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/

Was this reply helpful? Yes No