xlat / pbjson Goto Github PK

see json.sru line 253 : \r should be translated into ~r, not 'r'.

my json array response is as follows
[{"route":"Transaction","service_status":"Active","balance":82,"validity":"2022-08-11T18:30:00.000Z"},{"route":"Promotional","service_status":"Active","balance":100,"validity":"2022-12-30T18:30:00.000Z"}]

01 How do I access 2nd row and balance attribute
02 Is there is any way I can determine do I have how many rows I mean it might have one or more rows

I tried out this but didn't works
ln_json.retrieve("/1/route", ref la_data)

I am using PB 12.5 Classical and I want to display json data into datawindow. PB REST is supported from 2019 onwards I believe. my json response is a standard array with fixed structure, my idea is to picked up only values and put it in a string and append , end of row.

01 Do we have any function to determine which will extract only values something like Object.toString().
02 If I parse it one row at a time how do I find how many keys in the row ?
03 XML generator
[
{ "col1":"r1c1","col2":"r1c2"},
{ "col1":"r2c1","col2":"r2c2"},
]
Thanks in advance