Convert data to another format
Convert JSON to string and a stringified JSON to JSON object
Convert to escaped string
This quick action converts JSON input (or text and JSON) to an escaped string that can easily be transmitted or stored.
- In your workflow editor, click + Add step.
- Select Integrations > Quick action.
- Click Configure.
- Select the Convert to escaped string operation.
- Select the JSON object as data reference (click
{}
) or enter JSON object and /or array. You can convert one object per operation. - (Optional) Toggle to remove the outer JSON brackets.
- (Optional) Select the JSON output and/or input strings as variables to use in later steps.
- Save your changes.
Your output string with the outer brackets removed might look like the following:
Convert to JSON object
- In your workflow editor, click + Add step.
- Select Integrations > Quick action.
- Click Configure.
- Select the Convert to JSON object operation.
- Select an escaped or a regular JSON string as data reference (click
{}
) or enter the string manually. It might look like the following:json JSON "{\"name\": \"John\", \"message\": \"Hello world\"}"
- (Optional) Toggle to remove the outer JSON brackets.
- (Optional) Select the JSON output and/or input strings as variables to use in later steps.
- Save your changes.
Convert CSV to JSON
This operation allows exporting a file and uploading it as a source for a Next Matter table.
-
In your workflow editor, click + Add step.
-
Select Integrations > Quick action.
-
Click Configure.
-
Select the Convert CSV to JSON operation.
-
Enter or select the file URL. For example:
-
Select a delimiter (how the data is separated in the CSV file) and encoding (UTF-8 is the most common modern encoding).
-
(Optional) To use the converted data as a table source in another step, create the following variable:
$["CSV data as JSON"]["data"][*]
(or select it from the dropdown). -
Save your changes.
Now you can use a table form field with a dynamic source and add the
{Quick Action - Integration Step - CSV data as JSON (json)}
variable as the table source.