cancel
Showing results for 
Search instead for 
Did you mean: 

Issue in Flattening JSON objects in Jira

Chandra
8 - Cloud Apps
8 - Cloud Apps

We actually have to flatten the column which has JSON kind of representing data in the sisense elastic cube which was imported from Jira data source through JDBC connector. For this we have tried the JSON_Value() to split JSON consisting column to flatten the data, but it is giving an error like JSON_Value(string,string) is not supported. We tried this using link 

https://support.sisense.com/kb/en/article/flattening-json-objects-in-sql-server#:~:text=Question%3A%...

Do we have any solution for this before or after getting the data in to the cube, if so, how?

Is there any function like JSON_Value() that supports for Jira Data

JSON Issue.png

 

0 REPLIES 0