How to iterate a json result with many records as an array (seems to not have a root)

Resolved How to iterate a json result with many records as an array (seems to not have a root)

Advice

Votes

Undo

Alfredo Santibanez
PowerBuilder
Tuesday, 4 February 2020 17:16 PM UTC

Hi,

I am trying to read data records returned from a web service in json format. It contains a complex structure and starts as an array. Please find bellow a sample text.

I need to read all records and from each record find some values.

ls_Error = lnv_package.LoadString(ls_html) does not work, it returns

"Failed to load the JSON data because its root node is not an object"

I am using:

ls_Error = lnv_JsonParser.LoadString(ls_html)
           if Len(ls_Error) > 0 then
               MessageBox("Error", ls_Error)
           end if

           ll_RootObject = lnv_JsonParser.GetRootItem()

           ll_ChildCount = lnv_JsonParser.GetChildCount(ll_RootObject)
           // Obtains the values of child items
           for ll_Index = 1 to ll_ChildCount
               ls_key = lnv_JsonParser.GetChildKey(ll_RootObject, ll_Index)
           next

The child count is correct, but ls_key is always ""

I need the first field "uuid" and then find some others.

Any ideas?

REgards

Alfredo Santibáñez

DATA SAMPLE

Accepted Answer

Kevin Ridley Accepted Answer Pending Moderation

Tuesday, 4 February 2020 20:53 PM UTC
PowerBuilder
# Permalink

Check out the following article which may help. I'd like to see JSON support enhanced. The TreeView object should have Import/ExportJSON functions, and I'd love to see Appeon figure out how to make the TreeViewDW support complex JSON. Right now it's all manual parsing, which can be tedious. The below article looks like it might help you.

https://community.appeon.com/index.php/articles-blogs/tips-tricks-techniques-articles/17-powerbuilder/261-enhanced-json

Comment

Alfredo Santibanez
Tuesday, 4 February 2020 21:17 PM UTC

Thanks for your reply, I have read the article before, from a search and it is very good. I will give a try to the object.

I do have the next comment, the json I have to read is different, please find bellow an adaptation to what I received from your example, with two records in the main array.

1) I have initially an array

2) I need to read "file_name" from both records as it is the unique key of the data

3) this field "file_name" is not a node, is just one more record in the structure

4) in my case, many nodes will contain a record with file_name attribute. I don't need them, but probably will need name and price

How would you apply the object in this scenario?

[

{

"file_name": "example.json",

"number": "5",

"articles": [

{

"name": "watch",

"price": 208.3,

"stock": true,

"file_name":"x.json"

},

{

"name": "phone",

"price": 108.55,

"stock": false,

"file_name":"json2.txt"

}

]

}

{

"file_name": "example2.json",

"number": "52",

"articles": [

{

"name": "watch2",

"price": 208.3,

"stock": true

},

{

"name": "phone2",

"price": 108.55,

"stock": false

}

]

}

]

Best Regards

Alfredo

Helpful 0

There are no comments made yet.

Responses (2)

Alfredo Santibanez Accepted Answer Pending Moderation

Wednesday, 5 February 2020 15:05 PM UTC
PowerBuilder
# 1

Solved using the object, thanks

int counter
string uuid

u_json lu_json
lu_json = create u_json
try
   lu_json.of_load_file("testbtp.txt")
   f=

   for ll_index = 1 to lu_json.of_get_count()

       uuid=lu_json.of_get_node(ll_index).of_get_node('uuid').of_get_value_string()

       counter=lu_json.of_get_node(ll_index).of_get_node('identificationCounter').of_get_value_number()

       messagebox(uuid,counter)
   next

catch (exception le_ex)
   messagebox('json error', le_ex.getmessage(), stopsign!)
end try

Comment

There are no comments made yet.

Page :
1

There are no replies made for this question yet.
However, you are not allowed to reply to this question.

Please login to post a reply

You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »

Forgot Password?

Resolved How to iterate a json result with many records as an array (seems to not have a root)

Find Questions by Tag