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
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
Flag this post as spam/abuse.
Chris,
On 6 Feb 2015, at 15:04, christian.bryan@capita.co.uk <bounce-christianbryancapitacouk@community.progress.com> wrote:Thread created by christian.bryan@capita.co.ukHi
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.
Have a look at the abljson project by Marian Edu (sourceforge.net/.../abljson)