Why load JSON data to BigQuery
Export data no-code via API
Transfer data from your apps via the web API with a few clicks using the JSON to BigQuery integration. Retrieve the records and meta data that are not accessible when you manually export data as CSV or Excel. Automate exports of information from your source via API every 15 minutes, hourly, daily, or customize the schedule based on your needs.
Back up historical data
Build a backup of historical data imported from your source application, stock screener, or any other web source with JSON API. Keep the copy of the necessary records in Google Sheets and automate their backup on the schedule you want.
Accumulate data from multiple sources in one destination
Create a data repository of multiple sources in one place - BigQuery. Connect to your apps via API and automate export of the required data to have it updated in your repository. Query the imported JSON records to your BigQuery tables with the power of BigQuery SQL.
What JSON data you can import to BigQuery
Export issues, boards, documents, events, pages and other information stored in your project management software such as Asana, Coda, Pivotal Tracker, and others.
Get a copy of your listings, customers, prices, reviews and other sales data if you use online marketplaces like Etsy or Salesforce for your e-commerce business.
Load records from Toggl, Clockify or other time trackers to have a backup copy for tracking different performance metrics such as employee utilization.
Import valuable insights of your audience obtained with the help of marketing automation tools such as Reply.io, ActiveCampaign and many others.
Increase the efficiency of your collaboration environment by analyzing the statistics exported from communication platforms like Slack, Ryver, etc.
Get the datasets stored in JSON format on open data portals and statistics websites to create a data repository for your project.
Connect to the JSON API of many other miscellaneous apps to pull data to BigQuery without any coding skills, and automate the export to keep the data repository up-to-date.
How to import JSON to BigQuery
Step 1. Select JSON as a source application5 seconds
Step 2. Enter the JSON URL to load data from15 seconds
Step 3. Configure the parameters to connect to the JSON API and query data if required (HTTP method, HTTP headers, URL query string, etc.)2 minutes
Step 4. Select BigQuery as a source application, connect your BigQuery project, then specify the dataset and table to load the JSON data2 minutes
Step 5. Customize a frequency for data refresh20 seconds
Step 6. Run the JSON to BigQuery integration to import your initial records5 seconds
Set up multiple integrations to count on every day
Looking to import data from Pipedrive, Clockify, Xero, or any other app? Not a problem. Use Coupler.io to link a data source to BigQuery to automate workflows and leverage the power of spreadsheets across all your projects!