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
How to parse JSON data from a column
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: How to parse JSON data from a column
Hello,
Unfortunately, directly in the report, it is not possible.
Thank you.
Unfortunately, directly in the report, it is not possible.
Thank you.