How to parse JSON data from a column

[jaimefuhr]

Is there a function to parse JSON data stored in a column? The data source is SQL Server.

The table structure looks like this where MetaData is a string field that contains the JSON.

ID
CustomerName
MetaData

Example data:

ID=1
CustomerName = "Test Customer"
MetaData = "{"zipcode": 12345,"color":"blue"}]

In my report, I want to display:

ID, CustomerName, Zipcode
1, Test Customer, 12345

[Lech Kulikowski]

Hello,

Unfortunately, directly in the report, it is not possible.

Thank you.