Simple JSON Question

[Paul Mulroney]

Hi Das,

Try Do OJSON.$jsontolistorrow(chartoutf8(#S1)) Returns llist

Regards
Paul

Sent from my iPad

> On 1 Aug 2022, at 3:41 am, Das Goravani <goravanis at gmail.com> wrote:
> 
> 
> I have a source for some JSON text, it begins as follows:
> 
> {  
>  "version": "4.3",
>  "transType": "AC",
>  "merchant": {
>    "bin": "000001",
>    "terminalID": "001"
>  },
>  "order": {
>    "orderID": "123456",
>    "comments": "Comments",
>    "industryType": "EC",
>    "amount": "1000"
> Hopefully that text comes through, it’s not pasting correctly in my email client.
> 
> If I put that in #S1 and then do
> 
> Do OJSON.$jsontolistorrow(#S1) Returns llist
> 
> That puts the text into the list in a logical way. 
> 
> If I do the reverse ie
> 
> Do OJSON.$listorrowtojson(llist) Returns #S2
> 
> I get an error, that I’m trying to assign Binary to Character.
> 
> So $listorrowtojson returns a binary field.
> 
> I’m working on credit card processing. The bank requires JSON and the examples they give are like what I pasted above, that is from the Bank’s example input.
> 
> SO I think they want me to input textual JSON
> 
> How do you turn that binary into Text?
> 
> Thank you,
> 
> Das Goravani
> 
> 
> _____________________________________________________________
> Manage your list subscriptions at https://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com