Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

JSON parsing

Former Member
0 Likes
702

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
597

Here is example Odata:

{

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

    {

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

    },{

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

    }

  ]

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

2 REPLIES 2
Read only

Former Member
0 Likes
598

Here is example Odata:

{

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

    {

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

    },{

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

    }

  ]

Read only

0 Likes
597

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

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