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