Json Parser In PowerBuilder
I use sailjson’s pblsoft. I have fixed some small bugs, some json can’t parse. and develop some more functions according to my needs. Current functions xml and struct are having problems when its data is an array.
Find Projects On Github click here
Good Luck!
how to get nested item attribute ?
see example get record
Good Day,
Hope you can still reply, as post is already old.
I have a question, i have a test.json file, how do we load this to the mle?
Hope you could answer.
Thanks,
bolivar1985
what do you mean? read file text to mle??
i mean i have a file test.json, how do we load it to a table? i tried to use in isql load table #t_temptable from ‘C:\test.json’;
but can only retrieve the label no data
are you using PB version? High versions have import json function. low versions you have to read each column yourself and assign a value to it. you should bring out the sample string you need to process. In the example, there are examples for old versions, please refer to it.
{ "errorCode":["3","5","34"], "transactionId":"bbb119a9-3690-4016-a1e4-30a2654d05b7", "correlationId":"3268786e-ba1f-4d61-9ad5-a3b15072a544" }i neet to get errorCode values seperatly how ?
String ls_json Sailjson json ls_json = mle_json.Text If Pos( ls_json , "errorCode") = 0 Then Return json = Create Sailjson json.parse( ls_json ) Any ls_array_errorcode[] Int li_cnt li_cnt = json.getarray("errorCode",ls_array_errorcode ) Int li_row = 0 For li_row = 1 To UpperBound(ls_array_errorcode) MessageBox("", String(ls_array_errorcode[li_row])) Next