Overview
The JSON importer allows you to upload a JSON file, select the relevant part of the JSON structure that you want to import, and push the data to the tabular importer.
The JSON importer is useful for manually testing JSON inputs if you don't want to set up an endpoint connection with the Import Builder.
Selecting Data
Once you have uploaded your JSON file, the JSON importer provides a JSONpath-based selector along with a table preview to show the data that will be passed to the tabular importer in the next step.
The goal of the selector is to extract a set of tabular data. Depending on the structure of your file, you will either be able to select from the root or you will need to select a subset of the full file for import.
Configuring Data
The data from the preview table in the previous step will be brought in to the tabular importer where it can be configured in the standard way.
Note: The order of columns in the preview table may differ from the order of columns in the tabular importer.
Limitations
The JSON importer is unsuitable for JSON structures with many deeply-nested objects and arrays
The JSON importer — like the Excel importer — cannot be scheduled