0

We want to fetch the data from DataSet present in Salesforce CRM Analytics and insert the same data into the database using Mulesoft. Currently we are exporting the DataSet in a CSV using a recipe that creates an external Salesforce object and then we are querying that external object to fetch the data in parts, but now we're stuck because the size of our data is above 50 GB and when we are trying to export the data the whole full load data we are getting an error saying we are exceeding the maximum amount of data that is 50 GB per day.

Can I use Salesforce REST API to fetch records from DataSet?

enter image description here

James Z
  • 12,209
  • 10
  • 24
  • 44
Kunal Awasthi
  • 29
  • 3

1 Answers1

0

Yes you can query datasets, using Mulesoft, from CRM Analytics. You can use /services/data/v58.0/wave/query enpoint. In Mulesoft you just need to use HTTP Request connector with POST method. In the payload you set the SAQL statement - same as you would use it in a lens. The volume of data you have is huge - so maybe you should use a watermark with a scheduler that takes the newest data only.

Cristian Cocioban
  • 1