I schedule data warehouse report to be delivered to my email regularly. And connect to the csv file via Tableau to build a dashboard. Now I want to use the API and send that AA data to Oracle Data Mart so Tableau can automatically connect and refresh data. How can I get Json request for my original data ware house request.
If you'd like to take the resulting spreadsheet file and do something with it, you'll want to use server-side software to parse the data warehouse file in a format Data Mart can use, then send it off. I know that there are some Adobe consultants who specialize in data connections such as this. If this is something you'd like to pursue, you can get in touch with your organization's account manager.