Field: Create fields from JSON

Use this action to map JSON data to fields and data tables.

This action is commonly used to handle the output from systems that work in JSON, or other Catalytic JSON actions, such as Web API actions or XML: Convert XML to JSON.

Use case

Since any JSON data can be ingested, this action is used in processes working with JSON data.

  • Output a stringified JSON object from a formula and convert it to multiple fields, instead of using the formula action multiple times
  • Create a table from a JSON array
  • For actions that output in JSON, convert the JSON to fields
  • Get a txt file from an SFTP site that contains JSON and convert it to fields

How to configure this action

This action creates a data table when handling JSON arrays, otherwise it creates individual fields for each JSON pair. Arrays can have any number of objects, and each object can have many attributes, such as number or type.

screen readers look here

Fields for this action

  • JSON input

    • JSON formatted text or the {{field-name}} of a field containing JSON data
      • Example: { "firstName": "John", "lastName": "Smith" }
  • Output Field Prefix

    • To help keep output fields organized, choose an output field prefix to add to the beginning of each output field name as this action may output more than one field.
    • The step’s name is used as the prefix by default.

What will this output?

This action creates a data table when handling JSON arrays, otherwise it creates individual fields for each JSON pair.

This action may generate multiple fields. To help keep output fields organized, the prefix above will be added to the beginning of each of the output field names, separated by two dashes. Each field will result as:{{output-field-prefix--output-field}}. Learn more

Output fields for this action

  • JSON Keys and Values

    • The output of this action depends on the JSON input. JSON arrays are converted into data tables, and JSON objects are converted into fields.

Sorry about that. What was the most unhelpful part?









Thanks for your feedback

We update the Help Center daily, so expect changes soon.

Link Copied

Paste this URL anywhere to link straight to the section.

Need more help?

If you're signed in to Catalytic Community, you can ask other users a question. You'll be redirected to Community where you can add more info.