JSON Parser
Overview
This Snap reads JSON binary data from its input view and parses and writes it as JSON document data to its output view.
Parse-type Snap
Works in Ultra Tasks
Prerequisites
- A valid account with the required permissions.
Limitations and known issues
None.
Snap views
| View | Description | Examples of upstream and downstream Snaps |
|---|---|---|
| Input | This Snap has exactly one binary input view, where it gets the JSON binary data to be parsed. | Mapper |
| Output | This Snap has exactly one document output view, where it provides the JSON document data stream. | Mapper |
| Error |
Error handling is a generic way to handle errors without losing data or failing the Snap execution. You can handle the errors that the Snap might encounter when running the pipeline by choosing one of the following options from the When errors occur list under the Views tab. The available options are:
Learn more about Error handling in Pipelines. |
|
Snap settings
- Expression icon (
): Allows using JavaScript
syntax to access SnapLogic Expressions to set field values dynamically (if enabled). If
disabled, you can provide a static value. Learn more. - SnapGPT (
): Generates SnapLogic Expressions
based on natural language using SnapGPT. Learn
more. - Suggestion icon (
): Populates a
list of values dynamically based on your Snap configuration.
You can select only one attribute at a time using the icon.
Type into the field if it supports a comma-separated list of values. - Upload
: Uploads files. Learn more.
| Field / Field set | Type | Description |
|---|---|---|
| Label | String |
Required. Specify a unique name for the Snap. Modify this to be more appropriate, especially if more than one of the same Snaps is in the pipeline. Default value: JSON Parser Example: Document Parse |
| Filter path | String/Expression/ Suggestion |
Required. The Filter path property specifies the JSON path to the filter to be applied when parsing the given JSON data. The Snap extracts the parts of data that applies to the filter condition. For more information regarding JSON path, refer to the site http://goessner.net/articles/JsonPath/ Default value: N/A Example: $.items.item.[?]$.items.item[?(@.price > 10)] |
| Non-standard JSON | Checkbox |
Required. The Non-standard JSON property specifies whether or
not the Component should allow non-standard features in the given JSON data. Default status: Selected |
| Process array | String/Expression |
Required. The Process array property specifies whether or
not the Component should take a root JSON array and writes each element of the
array as a JSON document.
Note: Do not select this property if the input data is
not in JSON lines format. If it has no newline character and its data size
exceeds available memory, it may cause an out of memory error. Default status: Selected |
| JSON lines | Checkbox/Expression | This property specifies the Snap's error handling when the input JSON data is
newline-delimited JSON (JSON lines) and contains invalid JSON data:
Note: Do not select this property if the input data is not in JSON
lines format. If it has no newline character and its data size exceeds available
memory, it may cause an out of memory error.
Default status: Selected |
| Support Type Extensions | Checkbox/Expression | Select this checkbox to enable the Snap to format/parse the Snaplogic-specific
syntax indicating objects of the special types, such as byte arrays and date objects
in JSON. . Default status: Deselected |
| Snap execution | Dropdown list |
Choose one of the three modes in
which the Snap executes. Available options are:
Default value: Validate & Execute Example: Execute only |