Cloud Elements offers the endpoint GET /query
for the Salesforce Sales Cloud (SFDC) element only. Note that this endpoint is non-standard so it is not available in the Swagger / API Docs, but it is available on the element. Here is an example:
/hubs/crm/query?q%3Dselect%20*%20from%20opportunity
The SFDC element also supports a raw query endpoint (GET /raw-query
) that can be used when nested select statements are required. Just as with /query this endpoint is not in the API Docs, but is accessible when you make API calls against SFDC element instances. An example of using this endpoint is:
/hubs/crm/raw-query?q=select%20id%20from%20Account%20where%20OwnerId%20in%20(select%20User.Id%20from%20User%20where%20User.Id%20=%20'005f4111002Nmt1XXX')