How I get public API data in database using azure web job

See more:

XML

.NET

ADO.NET

Azure

JSON

API

I should not create a model class.

My requirement: I should pull the public API data and push it to newly created DB(it won't have any schema in it). How to accomplish this in .NET?

is it possible to use ADO.NET? and XML?

I'm clueless. Looking for some guidance.


I don't have any app hosted in Azure. I just need a job to hit API daily and push data to my DB. Which feature should I use in Azure?

What I have tried:

I'm planning to create an Azure web job and hit API to pull data. I can create a model and push data using entity framework. But, I have too many API and properties in it(Columns)

So, I'd like to push the data without creating a model class