topic Re: Transforming JSON array to ABAP internal table in Application Development and Automation Discussions

Transforming JSON array to ABAP internal table

Former Member — Thu, 30 Jun 2016 23:15:55 GMT

Hi,

I have tried using the method - cl_fdt_json=>json_to_data to transform JSON to ABAP.

It worked for simple fields but for Arrays it failed.

Need your expert opinion on this.

Regards,

Faiz

Re: Transforming JSON array to ABAP internal table

Former Member — Fri, 01 Jul 2016 00:22:43 GMT

try as below


DATA: lv_json type string, "your json string
            lv_data type zstructure. "your structure
 

DATA(lr_reader) = cl_sxml_string_reader=>create( cl_abap_codepage=>convert_to( lv_json ) ).
       CALL TRANSFORMATION id
         SOURCE XML lr_reader
         RESULT data = lv_data.

Re: Transforming JSON array to ABAP internal table

Sandra_Rossi — Fri, 01 Jul 2016 06:18:24 GMT

Mohammad is right, in that you should use the official way for handling JSON, i.e. use sXML classes (as per the ABAP documentation, read it please).

What we don't know, is the exact type of your internal table containing the JSON, and if it's of byte type in which code page the JSON is stored...

Re: Transforming JSON array to ABAP internal table

Former Member — Mon, 11 Jul 2016 20:15:08 GMT

Hi,

I was able to transform the data using

cl_fdt_json=>json_to_data( EXPORTING iv_json = abap_string
CHANGING ca_data = out_structure ).

Regards,

Faiz

Re: Transforming JSON array to ABAP internal table

srinivasareddybhimanadham — Wed, 08 May 2019 09:35:21 GMT

Hi Faizur,

Greeting of the day,

Thank you very much.... It is 100% working.

Regrads,

Srinivasa Reddy.