Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
vsabbellavsabbella 

automating the export of the CSV file from SFDC reports

Can we use rest API from tableau to request a CSV file(exported data from report ) fro m salesforce.
Generally using salesforce reports we click the export deatils button to download the csv file. But our company needs to automate the process and send the CSV file from report over to tableau external platform .
Can we leverage Analytics rest api on this one. 

Thanks in advance for the help.
KevinPKevinP
Ramforce,

The Analytics API will return JSON data. If you make an analytics API call to get the json data you can then utilize a json to csv tool.

Here's an online json to csv tool http://konklone.io/json/
vsabbellavsabbella
Hey KevinP,

Thanks for the input.
My question is wether, if tableau has some thing to import the data and store it for future use.

Thanks.
KevinPKevinP
Tableau isn't a Salesforce product and as a result I'm not terribly familiar with it. I suspect Tableau must have something like a local db to store the data, but I can't speak to that.
vsabbellavsabbella
I think any thing that tableau has for storing the data and importing to CSV helps. Thanks.
Jamie MartinJamie Martin
The practical way to reach automated export from SFDC to CSV is to use our tool Skyvia (https://skyvia.com/data-integration/salesforce-data-loader). It is the cloud solution with flexible scheduling features and no-coding at all.