JSON Conversion

HI
I am trying to convert the attached JSON file to a table format. While most of the columns are working fine, I am having a lot of problem converting the column - comments. Can someone help?

Presently I converted JSON to XML, then used Xpath and Ungroup to get rest of the columns but I am having problem getting comments.

Thanks

test.json (31.0 KB)

Instead of converting to XML to use XPath have you tried using JSON Path on the JSON itself?.

JsonPath_Example.knwf (111.2 KB)

Workflow there shows an example of getting the comments. The comments are present as a string so need to be converted to JSON before you can sue JSON Path on them.

Cheers

Sam

5 Likes

Thanks Sam. It worked. I was making mistake by going via XML route. Thanks a lot for your help.

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.