Paul Rubens

REST API(v10) GET link record entity name

Discussion created by Paul Rubens on Jun 15, 2016
Latest reply on Jun 16, 2016 by Tevfik Tümer

Hi, I'm trying retrieve Opportunity and the related venue records via SugarCRM REST API. I've had no involvement in the SugarCRM UI and the end user has shown me what fields they want me to retrieve from the standard UI.

 

I am able to retrieve Opportunity details and then make a separate call to then retrieve the Venue details.

 

https://URI/rest/v10/Opportunities/d7deae19-9ed1-a6d3-d94d-56cc5416e77f

https://URI/rest/v10/ven_venues/6707289b-8ccf-25ac-915d-51b217aa7d15

 

I don't know if the Venue entity is a standard Sugar entity but I was hoping there would be a way to retrieve the opportunity with the venue details in one request (to cut down round trips to the server). I’ve looked at the API documentation which describes record linking and tried various forms of this ‘link’ call.

https://URI/rest/v10/Opportunities/d7deae19-9ed1-a6d3-d94d-56cc5416e77f/link/ven_venues

 

The returned Opportunity record JSON contains these fields:

"ven_venues_opportunities_1_name":"Some Venue Name","ven_venues_opportunities_1ven_venues_ida":"6707289b-8ccf-25ac-915d-51b217aa7d15"

 

When I try using the ven_venue in the link call I get a http response of not found.

 

Any suggestions would be gratefully received.

Thanks,

Paul

Outcomes