Issue in Flattening JSON objects in Jira

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%20In%20instances%20where%20tables,these%20objects%20into%20individual%20fields

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