
Hey Guys,
There is requirement where our SF team has created a report in Salesforce based on some filter criteria and now we have to fetch the data from tha report in our API, any suggestions how to achieve that.
Thanks in Advance !
3 réponses
If it's a scheduled report on Salesforce side, you can use the REST API(/services/data/vXX.x/analytics/reports/<reportId>) as exposed in the article mentioned in the previous answer. You can get either excel or json format of data.
But if it is a report with a simple criteria and not many rollup summaries, then you can read the data directly using Salesforce connector applying the criteria in your SOQL query.