Utilizing an API as a Data Source in AWS Quick Sight

Q&A
,
1

Hello everyone,

I’m working with AWS Quick Sight 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 Quick Sight 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

2

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
3

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?