Need help to split json results

[richardvansoest]

Hello, i need to split the results from this json:

{"jsonrpc": "2.0", "method": "Player.GetItem", "params": { "properties": ["title", "album", "artist", "season", "episode", "duration", "showtitle", "tvshowid", "thumbnail", "file", "fanart", "streamdetails"], "playerid": 1 }, "id": "VideoGetItem"}

I would like to put the results in different labels like: Title, Duration,, Season (if any) etc.

[Taifun]

use the JsonTextDecode block from the web component http://ai2.appinventor.mit.edu/reference/components/connectivity.html#Web

any JsonTextDecode(text jsonText)

Decodes the given JSON encoded value to produce a corresponding AppInventor value. A JSON list [x, y, z] decodes to a list (x y z), A JSON object with name A and value B, (denoted as A:B enclosed in curly braces) decodes to a list ((A B)), that is, a list containing the two-element list (A B).

see also

• How to work with Lists by Saj
• How to work with Lists and Lists of lists (pdf) by appinventor.org

Taifun

---

Trying to push the limits of App Inventor! Snippets and Tutorials from Pura Vida Apps by Taifun.         

[richardvansoest]

I get stuck on this:

first 2 are ok but index 3 has to become an index itself i think.

can someone help me here ?

[Taifun]

use nested select list item blocks, see an example here

An example of a complex List of Lists

Taifun

[Taifun]

also you additionally might want to use the lookup in pairs block

How does the lookup in pairs block work?

Taifun

[richardvansoest]

i tried that already but stil get a lot of errors :(

How deep does the make list go ?

i understand the makelist > makelist etc

but not in combination to the json

i looked into the pairs to, but dont see how to use that with json either. 

[Taifun]

How deep does the make list go ?

it can go very deep ... ;)

you should first learn how to work with lists and list of lists

• How to work with Lists by Saj
• How to work with Lists and Lists of lists (pdf) by appinventor.org

i looked into the pairs to, but dont see how to use that with json either. 

if you have a list of lists, you can search for a key to get the corresponding value back

Taifun

[richardvansoest]

efirst 2 working from id i get VideoGetItem and from jsonrpc i get 2.0, but after that comes: 

(result ((item ((album *empty-string*) (artist ()) (episode -1) (fanart *empty-string*) (file F:\Movies\Wild Card (2015)\QoQ-sbuSLN.462x.1.5DD.LD-BEW.p027.5102.draC.dliW.mkv) (label QoQ-sbuSLN.462x.1.5DD.LD-BEW.p027.5102.draC.dliW.mkv) (season -1) (showtitle *empty-string*) (streamdetails ((audio (((channels 6) (codec ac3) (language eng)))) (subtitle (((language dut)) ((language eng)))) (video (((aspect 2.41509) (codec h264) (duration 5539) (height 530) (stereomode *empty-string*) (width 1280)))))) (thumbnail *empty-string*) (title *empty-string*) (tvshowid -1) (type unknown))))))

i can filter result and get all the data after the space behind result.

I cant figure out how to get the data from that. tried item / (item / ((item  etc.....

do i have to split it first ?

[Abraham Getzler]

I developed a little JSON browser utility to try to analyze RSS feeds.

It uses a stack and a ListView to show different levels and branches of

a JSON tree.

You have to paste your feed URL into the Block Editor,

in the global with URL in its name, and hit the Go button to

initiate the Web Get and the JSON parse, then 

navigate with the ListView and the Back buton.

I've attached screen shots,  block shots, and .aia source.

I notice two problems with it...

I only get 25 items per level.

I don't know if this is a limitation of the Web1.JSONDecode block or

my feed.

Also, my Back processing doesn't quite touch down properly

at the root of my stack.

It's usable, but not yet publication quality.

I hope you find it useful.

ABG

[richardvansoest]

Thanks Abraham, i am playing with it now to see if i can use some parts of it.

[Taifun]

(result ((item ((album *empty-string*) (artist ()) (episode -1) (fanart *empty-string*) (file F:\Movies\Wild Card (2015)\QoQ-sbuSLN.462x.1.5DD.LD-BEW.p027.5102.draC.dliW.mkv) (label QoQ-sbuSLN.462x.1.5DD.LD-BEW.p027.5102.draC.dliW.mkv) (season -1) (showtitle *empty-string*) (streamdetails ((audio (((channels 6) (codec ac3) (language eng)))) (subtitle (((language dut)) ((language eng)))) (video (((aspect 2.41509) (codec h264) (duration 5539) (height 530) (stereomode *empty-string*) (width 1280)))))) (thumbnail *empty-string*) (title *empty-string*) (tvshowid -1) (type unknown))))))

first you have to select the inner list, which contains the tag/valaue pairs, I market it in red for you

in your case try

then you can use the lookup in pairs block

for example to get the value of the file tag, you would use this block

Taifun

[richardvansoest]

I strugled all day with this. so i decided to make the program more rudimental for this problem.

Stil no real progres.

this is my whole program icl comment and error screen.

the json output depends on audio data or video data, on this image its video data from ncis episode.

(see comment)

What do i do wrong ?

 

[Taifun]

you should use Do it to find out how kodi_player_data looks like

then you will realize, that you need 

select list item get global kodi_player_data

                      3 

instead of just get global kodi_player_data to get your pairs list, as you did in in your previous screenshot

edit:

listJson from my screenshot is your 

select list item get global kodi_player_data

                      3

hope that helps

the trick is to use Do it for each step ...

Taifun

[Taifun]

actually a better solution to get the listJson from my screenshot is to do a 

lookup in pairs "result"

                      get global kodi_player_data

                      "not found"

Taifun                                                                               

[richardvansoest]

Do i have to use diferent global pair names for every step ?

or can i use global pair for everey next item ??

[richardvansoest]

I have made somthing that works..... pfffff dont know how exactly but it is getting me the date i need.

I think i do a lot wrong but now i have somthing i can try to make better, before i go further (for audio and normal movies)

any comments ?