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.
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.
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.