Skip to main content

JSON

Prophecy Automate

Read or write a JSON file from an external connection.

info

You can also use the upload file feature to use JSON files. These will be stored in the SQL warehouse configured in your fabric.

Supported connections

Parameters

ParameterTabDescription
Connection typeTypeLocation you want to connect from.
Format typeSource locationFormat of the gem. In this case, json.
Select or create connectionSource locationWhether to select an existing connection, or to create a new one.
FilepathSource locationFile path where you want to read and write files according to the connection type.
PropertiesPropertiesOptional table properties to apply. Source and target properties are outlined below.
SchemaPropertiesSchema definition of the table (custom or inferred).

Source properties

PropertyDescriptionDefault
DescriptionDescription of the table.None
Multiple documents per fileWhether the file contains multiple JSON objects separated by newline.False
Inference Data Sampling LimitMaximum number of rows to sample for inferring the schema.0

Target properties

PropertyDescriptionDefault
DescriptionDescription of the table.None
Multiple documents per fileWhether the file will contain multiple JSON objects separated by newline.False