Skip to main content

SalesForce's modified SQL

Exporting from Salesforce SOQL to Drupal Feeds. SOQL to SQL via via GuzzleHTTP

Interesting issue with an integration between a new Salesforce application and a legacy enterprise application. The data from salesforce API was limited to 50 records at once so as a workaround the Salesforce team gave access via a SQL call which could send more records each time. Consuming the data came via GuzzleHTTP which absorbed the data from Salesforce and delivers as an object as a nested associative array. E.g.

 

Subscribe to SoQL