Unable to convert JSON XML to TEXT data Below is the JSON Data stored in clob column of a table.
Unable to convert JSON XML to TEXT data Below is the JSON Data stored in clob column of a table.
{
"expand": "renderedFields,names,schema,operations,editmeta,changelog,versionedRepresentations",
"id": "18312",
"self": "https://inoappsproducts.atlassian.net/rest/api/3/issue/18312",
"key": "RPC-260",
"fields":{
"statuscategorychangedate":"2018-11-27T08:20:52.339+0000",
"issuetype":{
"self":"https://inoappsproducts.atlassian.net/rest/api/3/issuetype/10101",
"id":"10101",
"description":"A task that needs to be done.",
"iconUrl":"https://inoappsproducts.atlassian.net/secure/viewavatar?size=xsmall&avatarId=10318&avatarType=issuetype",
"name":"Task",
"subtask":false,
"avatarId":10318
},
"timespent":102000,
"project":{
"self":"https://inoappsproducts.atlassian.net/rest/api/3/project/11220",
"id":"11220",
"key":"RPC",
"name":"Reporting Packs Content",
"projectTypeKey":"software",
"simplified":false,