Hi guys,
Im pretty new to matillion. I'm trying to pull data from an api and save the response to an S# bucket as .json file. Currently I'm using api query component to pull the data but it mandates the data to be pushed into a database.
Any leads would be of great help
Hey! Welcome to the Matillion Community!
You might want to take a look at the S3 Unload component. Here's a thread showing another user looking at this in the past. Note that it does require you to store the data in a table before unloading but think this is what you want!
Thanks,
Johnathan
Hi John,
I did look into it. But I don't want to store data in a table before doing it
Hmm, okay. You may be better off looking at the Custom Connector in the Data Productivity Cloud, where you can load APIs straight to storage. I was doing this earlier today to debug something with my pagination!
Reading the documentation on API Extract, it doesn't seem possible to avoid going to a table in Matillion ETL.