How to sistematically insert data from a function app to sql azure database?

Question

Hi!! Super excited to be part of this community.

Just starting out with some new services, since i'm trying to figure out the best way to

1. Fetch a lot of data from an API automatically everyday at a speciffic hour, takes about 1 hr.
2. Insert that data into an SQL database.
3. Be able to rescue the data from the database as if it was just another API endpoint.

For this, i thought about using function apps for 1 and 3, and an azure sql database for 2.

I already have 1 figured out, but the connection to the database (step 2 and 3) are giving me a lot of trouble. Am I thinking about this the right way? Is this a good solution? How can I do the insertion and query parts (steps 2 and 3)? I'm feeling super lost.

Would greatly appreciate any help. Thanks in advance.