Store API Response JSON in DB Table

Yes it can but we need more information. I assume the API connection is correctly set up and the schema imported if necessary.

If set up correctly you should be able to assign it directly to a database field or variable

Take a look at the later part of this guide for an example