TO_JSON function

TO_JSON function

Function Name	Description	Usage	Input parameter	Return value
TO_JSON	Converts the current value to a JSON object.	TO_JSON()	N/A	A JSON object.

Supported data type

The TO_JSON function supports the following data types:

• Boolean
• Boolean array
• Double
• Double array
• Integer
• Integer array
• String
• String array

Example: Convert a string to a JSON

Sample data: $var1$ = "{product: "cake", id: 21, price: 5}"

Usage: $var1$.TO_JSON()

Convert var1 to JSON.

Output: {product: "cake", id: 21, price: 5}

Note: If your JSON schema has an array with both integer and number elements, using JSON schema version 4 might lead to unexpected errors at runtime. To prevent the error, set the schema to version 7 or greater. For example, "$schema": "http://json-schema.org/draft-07/schema#".

Recommendation

• Learn how to add and configure a Data Mapping task