M
M
Matsun2019-10-24 09:56:15
Google Cloud Platform
Matsun, 2019-10-24 09:56:15

How to load JSON data in Google BigQuery using GET requests?

Hello! Please help me with one issue.
Briefly, the task is to have a table in BigQuery with order IDs and their statuses. Our site gives 5 last orders at a time with this data. To get this information, you need to make a GET request https://site.ru/export-json.php. And in response, the site gives the last 5 orders with statuses in JSON format.
Next, you need to check which of the 5 order IDs are already in the BigQuery table and add only those that are not. You need to make a GET request every 5 minutes.
A big request to suggest a way and a bunch of Google services that you need to use in order to accomplish this task.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question