Query API and seed DB with Results

I am trying to query an API and then use those results to create a new table. The API returns JSON data. I would then need to create a webhook to update the table. Any help would be appreciated.

Richard,

It is not clear to me what you already have and what you need help with. For example:

I am trying to query an API and then use those results to create a new table. 

Is it done? Does it work?

The API returns JSON data

How about this? Are you good with it?

 I would then need to create a webhook to update the table

This is the part where I am not particularly clear. Can you elaborate what exactly you’re looking for? Perhaps describing the desired goal and how you envision it to work would be helpful.

Regards,
Mark