Forum Discussion

arvindnsn's avatar
arvindnsn
Contributor
7 years ago
Solved

How to create multiple hierarchy sets in for API output

Hello, I am having issues structuring the API output i am working in. I have attached both the Source data and the JSON output structure expected in the attachment. I have attached the source file ...
j_angelevski's avatar
j_angelevski
Contributor III
4 years ago
Copy LinkReport

Hi @arunnp ,
You can use this expression:

JSON.parse($['s:Body'].ExecuteApplicationResponse.ExecuteApplicationResult.replaceAll('Windows"', "Windows "))

This will parse all the data and transform it into JSON object, but I had to change the “Windows” part because is invalid. I removed the " from ‘Windows"’.

Result: