[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: JSON - Why does not this work?

[Peter Judge]

Does the approach that Edsel posted above work? The help for READ-JSON says JsonArray A reference to a Progress.Json.ObjectModel.JsonArray object. This JsonArray object must fit one of the valid patterns for a temp-table object. If any part of the JsonArray object does not fit one of the accepted patterns, the READ-JSON ( ) method generates an error message and returns FALSE. If the JsonArray object fits an accepted pattern, but contains fields whose names do not match the existing temp-table schema, the mismatched fields are ignored. JsonObject A reference to a Progress.Json.ObjectModel.JsonObject object. This JsonObject object must fit one of the valid patterns for a ProDataSet or temp-table object. If any part of the JsonObject object does not fit one of the accepted patterns, the READ-JSON ( ) method generates an error message and returns FALSE. If the JsonObject object fits an accepted pattern, but contains tables whose names do not match the existing ProDataSet schema, or contains fields whose names do not match the existing temp-table schema, the mismatched tables or fields are ignored. Which seems to say that what you want to do will work. But the doc isn't as clear for passing in a LONGCHAR.

Continue reading...