I need to write a progress program to read data from a JSON file with nested information into a dataset in Progress. I keep getting an error 'Error passing JSON: expected bracket, but found brace (15358)'. How can I update the program to get past this error. I don't have control over the creation of the JSON file.
The progress program looks as follows
A copy of the JSON file is attached.
The progress program looks as follows
Code:
define temp-table hotels
field code as character
field name as character
field country as character
field zipcode as character
field address as character
field destination as character
field latitude as decimal
field longitude as decimal
field currencycode as character
field nr_rooms as integer
field hotel_class as integer
field hotel_type as integer
field regions as character extent 100
field themes as character extent 100
field facilities as character extent 100
field created_at as datetime-tz
field updated_at as datetime-tz
field is_created as character.
define temp-table images
field code as character
field category as character
field is_created as character
field url as character
field created_at as datetime-tz
field updated_at as datetime-tz
field tag as character.
define temp-table descriptions
field code as character
field description as character
field created_at as datetime-tz
field updated_at as datetime-tz
field is_created as character.
define dataset dsHotelsInfo for hotels, images, descriptions
data-relation hotelsimages for hotels,
images relation-fields(code, code) nested foreign-key-hidden
data-relation hotelsdescriptions for hotels,
descriptions relation-fields(code, code) nested foreign-key-hidden.
DEFINE VARIABLE cSourceType AS CHARACTER NO-UNDO.
DEFINE VARIABLE cFile AS CHARACTER NO-UNDO.
DEFINE VARIABLE cReadMode AS CHARACTER NO-UNDO.
DEFINE VARIABLE lRetOK AS LOGICAL NO-UNDO.
DEFINE VARIABLE hdsHPROhotels AS HANDLE NO-UNDO.
hdsHPROhotels = dataset dsHotelsInfo:handle.
ASSIGN cSourceType = "file"
cFile = "C:\json\hotels-98.json"
cReadMode = "empty".
lRetOK = hdsHPROhotels:read-json(cSourceType, cFile, cReadMode).
A copy of the JSON file is attached.
Attachments
Last edited: