Parsing JSONs from String
Last updated
Was this helpful?
Last updated
Was this helpful?
Was this helpful?
Some connectors and databases return JSON data in an escaped string that you can not use right away. Here an example:
{
"timestamp": 1657722582,
"information" : "{\"id\":\"0001\",\"type\":\"donut\",\"name\":\"Cake\",\"ppu\":0.55,\"active\":false}"
}
If you receive JSON data as a string that you like to convert into a JSON, you can use our dictionary helper.
If we assume that the data is stored in get_data
the following code example will help you to parse the data in a way that it can be read as a JSON:
{{ get_data.information | replace('null', 'None') | replace('true', 'True') | replace('false', 'False') | replace('\\/', '/') }}
The result will be:
{
"id": "0001",
"type": "donut",
"name": "Cake",
"ppu": 0.55,
"active": false
}