R
Robin Brown
Guest
The JSON you describe cannot map to a temp-table or dataset, in order to be loaded with READ-JSON. For our JSON representation , Temp-tables are arrays of row objects, and a dataset is an object made up of temp-table arrays. So for 10.2B, this will not work. We added the ABL JSON API in Release 11, which might help you. Regards, Robin From: christian.bryan@capita.co.uk [mailto:bounce-christianbryancapitacouk@community.progress.com] Sent: Friday, February 06, 2015 10:05 AM To: TU.OE.Development@community.progress.com Subject: [Technical Users - OE Development] Reading JSON without Arrays Reading JSON without Arrays Thread created by christian.bryan@capita.co.uk Hi I have to read some JSON that does not contain an object name or Arrays: I.e. { "BankBIC": "CP75851", "BranchBIC": "SMC", "BankName": "THE CO-OPERATIVE BANK PLC", "BankOfficeTitle": "SMILE - CURRENT", "BranchName": "Smile - Current", "OfficeTitle": "SMILE - CURRENT", "ContactAddress1": "P.O Box", "ContactAddress2": "Delf House", "ContactAddress3": "", "ContactAddress4": "", "ContactAddressCity": "Blah", "ContactAddressCounty": "Lancashire", "ContactAddressPostCode": "WN8", "ContactAddressPostCountry": "UNITED KINGDOM", "ContactPhoneNumber": "08457 212212", "SortCode": "089286", "DateLastChanged": "2009-09-16T00:00:00.000", "TransactionInfo": { "BacsCredits": true, "BacsDebits": true, "FasterPaymentsService": true, "ChapsSterling": true, "DirectDebitInstructions": true, "UnpaidChequeClaims": true, "DividendInterest": true, "BuildingSocietyInterest": true }, "ChapsBankBIC": "CP2", "ChapsBranchBIC": "XX" } I can't see a way of defining a prodataset or temp table to match this data in OE 10.2.b for this? Any help appreciated Stop receiving emails on this subject. Flag this post as spam/abuse.
Continue reading...
Continue reading...