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
Voice of Customer
Impact Business Intelligence (BI) and Analytics Market Research

Click Here & Complete Dresner's Wisdom of Crowds® Market Study Survey Today!

Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Need additional support?:

Community Support Request

Don't miss out:

Earn a BETA Launch Challenge Badge!