Ingesting data from APIs

Anonym40
New Contributor III

Hi, 
I need to ingest some data available at API endpoint. 
I was thinking of this option - 
1. make API call from Notebook and save data to ADLS
2. use AutoLoader to load data from ADLS location. 
But then, i have some doubts - like I can directly write the api response to table,
then Is writing to ADLS is an unnecessary step ? 
Then I thought if I drop the table, maybe I can use the files in ADLS to reload the table. 
Then again, i can restore from Version instead of using something like copy Into using files in ADLS ? 
 Which approach should I take then ? How are other people doing it ? 
Thanks,