SugarCRM relationship to get contacts from active opportunities

Question

I am working on sugarCRM, I need to get all the contacts from active opportunities. I can relate the contacts with Opportunities for single record using the below url

https://xxxxxxxx.trial.sugarcrm.eu/rest/v10/Opportunities/5ae1907a-9408-178f-87d6-523cc7d679b6/link/contacts

But I have to get he contacts details for all opportunities which is active. Can Anyone please help me.... Thanks in advance

If answers help you plz upvote and accept answer. – Amitesh Kumar Apr 05 '17 at 08:12 — Amitesh Kumar, Apr 05 '17 at 08:12

score 3 · Accepted Answer · answered Apr 05 '17 at 06:06

3

you are going right , The url provide by:

https://xxxxxxxx.trial.sugarcrm.eu/rest/v10/Opportunities/5ae1907a-9408-178f-87d6-523cc7d679b6/link/contacts

It will give all record related to that Opportunities.

But you want All contacts of active Opportunities

First you need to hit API for Opportunities which is active :

https://xxxxxxxx.trial.sugarcrm.eu/rest/v10/Opportunities/filter[0][status][$in][]=active

Like this you can apply filter.

For more help check this link

2.Now after that you get array on Opportunities , so will use loop get get Opportunities id and hit your URL.

https://xxxxxxxx.trial.sugarcrm.eu/rest/v10/Opportunities/5ae1907a-9408-178f-87d6-523cc7d679b6/link/contacts

You can make Dynamic according to your need. I hope this will help you.

answered Apr 05 '17 at 06:06

Amitesh Kumar

3,051
1
26
42

Thank you Amitesh – Jagan Apr 05 '17 at 08:41
how can I achieve this API v4 – Jagan Apr 11 '17 at 10:28
This API are available in sugar , when you use sugar it will show which api is hitting in firebug in chrome. Or read sugarcrm documents. – Amitesh Kumar Apr 11 '17 at 10:32
yes I went through the API documentation of API V4 but I have roadblock please look into the question(http://stackoverflow.com/questions/43342365/sugarcrc-access-denied-number-40) and help me – Jagan Apr 11 '17 at 10:35

SugarCRM relationship to get contacts from active opportunities

1 Answers1