READ-JSON be able to read single nested child - OpenEdge Development - Products Enhancements - Progress Community

 OpenEdge Development

READ-JSON be able to read single nested child

Today, when we have a valid JSON returned by another application, we just can't read it with READ-JSON because we get the error:

Error parsing JSON: unexpected token: bracket. (15360)

We read the article 000010839 in Progress KB and it says that is not possible. But we can't do integrations with another applications because of this error! It is a valid JSON! We must be able to read it!

Example:

{
"jsonOutput": {
"Vehic": [
{
"Brand": "OPEL",
"RegNumber": "AB-123-CD",
"Model": "Insigna",
"Driver": {
"Name": "Alice Cooper",
"LicenceNum": "1234567890123"
}
},
{
"Brand": "RENAULT",
"RegNumber": "CD-456-EF",
"Model": "Megane Scenic",
"Driver": {
"Name": "Ozzy Osbourne",
"LicenceNum": "1357913579135"
}
},
{
"Brand": "AUDI",
"RegNumber": "EF-789-GH",
"Model": "A6 AllRoad",
"Driver": {
"Name": "Robert Plant",
"LicenceNum": "2468024680246"
}
}
]
}
}

Comments
  • I like the idea to have the option to receive a single object which becomes 1 record in the TT.

    But today you can just store it in a Progress.Json.ObjectModel.JsonObject and work from that so it doesn't stop your integration