How to get REST API information into my Google BigQuery SQL Table?

What I am trying to achieve is this:
1. Access a REST API to download hotel reservation data – the data output format is in JSON
2. Convert JSON data into the correct format to be uploaded into SQL table
3. Upload this table of data onto Google BigQuery existing table as additional rows

Do let me know if any further information is required and if I have been clear enough

Thanks in advance

Answer

1) pretty good REST API tutorial

2) You can use a local SQL DB or use Cloud SQL. The process would be the same (Parse JSON and insert to DB)

If you decide to use Cloud SQL, you can parse the JSON and save it as a CSV then follow this tutorial

or

simply parse the JSON and insert using one of the following API’s

3) Use can easily load data into any BigQuery table by using BigQuery API. You can also directly insert the JSON data into BigQuery

But as Tamir had mentioned, it would be best to ask questions if you encounter errors/issues. Since there are multiple ways to perform this type of scenario, we cannot provide an exact solution for you.