Microsoft Dynamics 365 | Integration, Dataverse...

Get Opporutnity ID of Contact

(0) Share

Report

Posted on by Community member

Hi, I want to fetch a contact's opportunity Id using APIs. Is there any way I can get opportunity id if I have the contact id?
I need to update the opportunity but I only have the contact Id. So if I can get the opportunity Id I can update the opportunity.

If there is a way kindly let me know what endpoint should I use and hit to get the opportunity Id?

All responses (3)

Answers (0)

Leah Ju Microsoft Employee on at

Like (0)

Report

Get Opporutnity ID of Contact

Hi Partner,

Based on the documentation you provided, the app you are using is Business Central?

If so, you need post questions on the following forum:

Business Central forum (dynamics.com)
Community member 2 on at

Like (0)

Report

Get Opporutnity ID of Contact

So I need to build an API to get what I want? The API's that are provided by MS Dynamics, does none of them can carry out this request? Like the get opportunity request or any CRUD like https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/api/dynamics_opportunity_get ?

I am using a 3rd party tool to make requests. My end goal is to update the opportunity when I update a contact.
So at the moment of contact update I won't have the opportunity ID, to get that I would need make another request to get all opportunity IDs of that contact and then update them. I would prefer to use the api's listed in documentation. Is it possible in any of those APIs?
Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report
Get Opporutnity ID of Contact

Hi partner,

One contact has many related opportunities through one-to-many relationship between them, if you have the contact id, you can get opportunities related to it.

So you can build web api as following:

Xrm.WebApi.retrieveMultipleRecords("opportunity", "?$select=opportunityid&$filter=(_contactid_value eq 25a17064-1ae7-e611-80f4-e0071b661f01 or _parentcontactid_value eq 25a17064-1ae7-e611-80f4-e0071b661f01)").then( function success(results) { console.log(results); for (var i = 0; i < results.entities.length; i++) { var result = results.entities[i]; // Columns var opportunityid = result["opportunityid"]; // Guid } }, function(error) { console.log(error.message); } );

Result:

Note: 'Dataverse REST Builder' tools help you build api easily, https://github.com/GuidoPreite/DRB
I hope you can verify my answer if it helps you! If you have any questions, please feel free to contact me.
Regards,
Leah