JSON Advanced Connector

Connection Method

Select whether you want to connect to your JSON file via file transfer (SFTP) or HTTP request.

• Select File Transfer (SFTP) if your JSON file is on an SFTP server.

• Select HTTP Request if you need to access your JSON file using an HTTP GET request. The request is triggered by the use of a unique URL parameter defined by the service providing the JSON file.

URL to Your JSON File

Enter the URL for the JSON file. Supported protocols are HTTPS and SFTP.

Does Your JSON Text Require a Line Reader?

Select Yes if your JSON text includes multiple lines to read.

Should the Backslash Be Escaped?

Select Yes if your JSON text includes backslash characters that should be escaped.

Do You Require Additional Options?

Select Yes if you need to enter header or data tags or exclude fields.

Header Tag (Optional)

Enter the tag for the header in your JSON text. JSON headers are not normally included in JSON, but when they are included, they will most likely use one of the following formats:

{
        "People": {
                    "name": "John",
                    "age": 30,
                    "car": null
        }
}
 

or

{
        "header": [
                    "name",
                    "age",
                    "car"
        ],
        "data": [
                    "John",
                    30,
                    null
        ]
}

Note that the first example does not include the "header" tag, while the second does. In the second example, the headers are listed separately from the actual data tags. 

Data Tag (Optional)

Enter the tag for the data in your JSON text.

Fields to Exclude (Optional)

Provide a comma-separated list of fields to exclude from the JSON import.