Dear SAP community,
I hope you can help me with JSON Deserialization in SAP. I receive a JSON string and want to convert it into an internal table. Below you can see an example, which is working, but it doesn't behave like a normal JSON deserialization.
These are the issues:
If the fields in the JSON string are not in the exact sequence (just switch "FirstField" and "SecondField" in the JSON input file), then the transformation dumps. Usually JSON deserializations should find the match regardless of the field sequence.
How can I declare a real boolean value? In my example the boolean value is only working as a string with encapsuled in quotas (").
To test this you have to create the below report and the below transformation.
This is the Report:
*&---------------------------------------------------------------------*
*& Report ZJSON_SEQUENCE
*&---------------------------------------------------------------------*
report zjson_sequence.
parameters: p_file type string obligatory.
class gcl_json definition.
public section.
class-methods main.
endclass.
class gcl_json implementation.
method main.
types: begin of lty_data,
firstfield type c length 10,
secondfield type boole_d,
end of lty_data.
data: lt_string type table of string,
lt_data type table of lty_data,
lv_string type string.
call function 'GUI_UPLOAD'
exporting
filename = p_file
tables
data_tab = lt_string
exceptions
others = 1.
if sy-subrc <> 0.
message id sy-msgid type sy-msgty number
sy-msgno with sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
endif.
loop at lt_string assigning field-symbol(<lv_string>).
concatenate lv_string <lv_string> into lv_string.
endloop.
call transformation zjson_sequence source xml lv_string
result root = lt_data.
loop at lt_data assigning field-symbol(<ls_data>).
write: 'First field = ', <ls_data>-firstfield,
'; Second field = ', <ls_data>-secondfield.
skip.
endloop.
endmethod.
endclass.
at selection-screen on value-request for p_file.
call function 'WS_FILENAME_GET'
importing
filename = p_file
exceptions
others = 1.
start-of-selection.
gcl_json=>main( ).
This is the Transformation:
<?sap.transform simple?>
<tt:transform xmlns:tt="http://www.sap.com/transformation-templates">
<tt:root name="ROOT"/>
<tt:template>
<object>
<array name="SomeData">
<tt:loop ref=".ROOT">
<object>
<str name="FirstField">
<tt:value ref="$ref.firstfield"/>
</str>
<str name="SecondField">
<tt:value option="format(boolean)"
ref="$ref.secondfield"/>
</str>
</object>
</tt:loop>
</array>
</object>
</tt:template>
</tt:transform>
This is the JSON example, which works. It needs to be saved as a text file and uploaded by the report:
{
"SomeData":
[
{
"FirstField": "ABCDE12345",
"SecondField": "true"
}
]
}
This is the JSON example, which doesn't work:
{
"SomeData":
[
{
"SecondField": true,
"FirstField": "ABCDE12345"
}
]
}
Looking forward for your guidance.
Kind Regards
Mark André
Bluesky
