I’m calling an API that is returning JSON to ABAP that I’m having difficulty deserializing. This is the format of the JSON that is returned by the API:
{
“outputs”: {
},
“tables”: [
{
“columns”: [
“Column_1”,
“Column_2”,
“Column_3”,
“Column_4”,
],
“rowLimitExceeded”: false,
“rows”: [
[
“Value_1a”,
“Value_2a”,
“Value_3a”,
“Value_4a”,
],
[
“Value_1b”,
“Value_2b”,
“Value_3b”,
“Value_4b”,
]
]
}
],
“transactionNo”: “43”
}
I’ve created multiple versions of a deep structure in an attempt to match the JSON format, but I’m only getting the TransactionNo field to successfully deserialize. I think it might be because this isn’t all valid JSON (the values in the columns and rows sections aren’t seperated by a colon character), but am hoping someone here can help me deserialize this using the /ui2/cl_json=>deserialize method. If not I may have to build my own parser for this data manually.
Thanks.