Connect with JSON Connector

The JSON Connector allows you to upload a JSON (JavaScript Object Notation) response file to Birst.

Note: Ensure that the JSON file is well-formed by using a validator utility such as JSLint.

Review the following before using JSON Connector:

  • The JSON response file size must be 20MB or less. You can split larger files into 20MB files and upload them together in a ZIP file.
  • The file extension must be .json.
  • Key-Value pairs must be in double quotes.
  • The connector will pick the latest value if a file contains more than one key with the same name.

For files greater than 20MB, follow these guidelines:

  • Split the large file into smaller files less than or equal to 20MB in size.
  • Use a naming convention that includes a common keyword. For example, myfile1.json, myfile2.json, myfile3.json, etc.
  • The structure of the file contents must be the same.
  • Put all the files together into one ZIP file. Do not put any other files in the ZIP, it must contain only the .json files.

Before you upload, you must enter the common keyword. When you upload the ZIP file, Birst will extract the file and place all the JSON files into the space data directory.