topic Re: JSON parsing in Application Development and Automation Discussions

JSON parsing

Former Member — Wed, 24 Sep 2014 12:33:29 GMT

We're on version 7.02. We have a need to parse JSON data, specifically in OData format. I've tried creating a simple transform (ST), but have run into conversion and others issues, etc. I've created XSLT transforms for XML data to ABAP in the past, just fine.

Thanks

Re: JSON parsing

Former Member — Thu, 25 Sep 2014 13:56:56 GMT

Here is example Odata:

{

"odata.metadata":"http://plpc-11558.cnsl.com/PelotonService/odata/$metadata#Wells","value":[

{

"id":"00059D965F","name":"7778"

},{

"id":"000C169678","name":"test"

}

]

Re: JSON parsing

Former Member — Thu, 25 Sep 2014 15:37:49 GMT

Figured it out: for some reason, the TRANSFORMATION was failing on this string: odata.metadata

As soon as I removed the ".", everything started working.