Processing of JSON strings inside a JSON object

In Make, JSON-based APIs are natively supported. Nevertheless, some APIs may have a JSON string inside a JSON object.

If an API returns a JSON string inside a JSON object, the data inside a JSON string is treated as text and the child parameters cannot be directly mapped.

However, if the API requires a parameter in JSON string format, Make has to send it in the required format.

Note the address parameter. Since the parameter is a JSON string, the content is not parsed as a collection.

{
    "address": "{\"zip\":\"18000\",\"city\":\"Prague\",\"state\":\"Czechia\",\"country\":\"Czechia\",\"address1\":\"Menclova 2\"}",
    "id": "123",
    "name": "Make Office"
}

Example of an address parameter that has a value in the JSON string format.

Create a JSON String

If the API requires a parameter to be sent as a JSON string, the createJSON() function can be used.

{
    ...
	"body": {
		"{{...}}": "{{omit(parameters, 'address')}}",
		"address": "{{createJSON(parameters.address)}}"
	},
    ...
}

The createJSON() function is used to format the address value to a JSON string.

{
    "address": "{\"zip\":\"18000\",\"city\":\"Prague\",\"state\":\"Czechia\",\"country\":\"Czechia\",\"address1\":\"Menclova 2\"}",
    "id": "123",
    "name": "Make Office"
}

The address parameter is sent in JSON string format.

Parse a JSON String

If the API output contains a parameter in a JSON string format, the parseJSON() function can be used.

{
    ...
	"output": {
		"{{...}}": "{{omit(body, 'address')}}",
		"address": "{{parseJSON(body.address)}}"
	},
    ...
}

The parseJSON() function is used to parse the address value to JSON.

{
    "address": "{\"zip\":\"18000\",\"city\":\"Prague\",\"state\":\"Czechia\",\"country\":\"Czechia\",\"address1\":\"Menclova 2\"}",
    "id": "123",
    "name": "Make Office"
}

If the parseJSON() function is not used, the JSON string is returned in a raw format.

[
    {
        "address": {
            "zip": "18000",
            "city": "Prague",
            "state": "Czechia",
            "country": "Czechia",
            "address1": "Menclova 2"
        },
        "id": "123",
        "name": "Make Office"
    }
]

If the parseJSON() function is used, the value in address parameter is parsed to JSON. The address parameter is returned as a collection.

PreviousBuffer NextStatic parameters

Last updated 8 months ago