Hi @Aleona
You would need to use the HTTP Connector, to use the link you have (assuming its a viable link).
Then you would have to get the data, loop through it and save it to a CSV. You cannot save it to XLSX format UNLESS you pre-created an Excel file with a Table in it. So you could, if you knew the format of the data, created a dummy excel file. When you got the data, copy it to a new name, fill it with the data.
Then save it to the locations you mention.
And yes you could use a recurring Trigger
Steps
1. Create recurring trigger for that time
2. Use the HTTP Connector to Connect to the Tableau API's to get the data
Option 1.
Use a Compose/Select and Filter Array combination to create the formatted CSV
Use a Create File (SharePoint), where the Content is from the previous Option 1 step
Use a Create File (SharePoint) to create your second file same as the previous
Option 2.
Have an excel file that has the Table in it and headers etc
Copy the File to SharePoint location using Copy File or you can use Get File Content, get it, then use Create file in in Location 1 first
Now you would Loop through all data from Step 2
using add rows to a table, (Excel) to add the rows
outside the loop, now do a Get File Content from the file in location 1
do a Create file in location 2, using the content from the previous option step
Thats the dummy version but its accurate for how you could
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
