Utilizing an API as a Data Source in AWS QuickSight

Hello everyone,

I’m working with AWS QuickSight and I’m in a situation where I’d like to use an API as my data source. Specifically, I’m making requests to an endpoint and receiving responses in CSV format.

What I’m not certain about is how I can iconnect this API into QuickSight or set it up as my data source. Does anyone have any advice or step-by-step guidance on how to approach this?

Thank you in advance for your time,
Dan

Hi @kolodnydan ,

You can’t use the API as a data source directly but you can save the response from the API in S3 and use S3 as your data source.

1 Like

Hi, I also would like to ask the best way to automatically upload data from API to S3, for example, every hour, so that I can have fresh data for the Quicksight dashboard?
Or how to do that to have live data?