JSON Connector

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

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

Implementation and Usage Notes

• 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.
• Starting with 5.21, the connector will pick the latest value if a file contains more than one key with the same name.

For general usage notes see Connect to Cloud Applications Using Application Connectors.

Large File Preparation

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 will enter the common keyword. When you upload the ZIP file, Birst Connect will extract the file and place all the JSON files into the space data directory.

Next Steps

See Extracting Data using JSON.

Optionally, set up a schedule for regular extractions using Birst Connect. See Using Birst Connect and  Extracting Application Connector Data Using Birst Connect Commands.