Sep 09, 2022

Need adviced on extracting data from tools exposing api

Hi, I'm a newbie here and i've got a question for you. If you have a tool which does not have an existing connector but which exposes apis, what methodology do you use to extract quickly the data and make them available in your data stack ? I mean do you have a standard way to do that or it depends on the source ?

1 Reply

Hi, The first question is what an orchestration tool you use for ELT/ETL?For example, we consume API's with simple Python code (requests library) and then put data into DataFrame (pandas) and then export it to SQL via pandas.to_sql.

2 months ago
Please login to reply