[Stackoverflow] [Progress OpenEdge ABL] How to retrieve a data value from a nested json file using Progress 4GL

  • Thread starter Thread starter Manny
  • Start date Start date
Status
Not open for further replies.
M

Manny

Guest
How to get the value of Example: "JournalNum" from the below json Object

{ "parameters": { "ds": { "GLJrnHed": [ { "Company": "EPIC06", } ] } }

My code for a non nested JSON is below

TJsonObject = CAST(oResponse:Entity, JsonObject). OP-JOURNAL-NUM = INTEGER(TJsonObject:getJsonText("Company")).

In this case, It won't work because JournalNum is not open directly in the JSON.

I just need only this field , so diverting all data into temp-table via read-json is an expensive option.

Continue reading...
 
Status
Not open for further replies.
Back
Top