Im working with long json file but im a little confused that how to get the value which i want...
Also i asked someone but he asking for payment
Can you please help me... if anyone have some free time please look into it...
Here is a row json file...
raw.json (5.9 KB)
I want module name from every list then after that i want show name show id image url which is inside list...
Sorry im unable to explain properly
But hope you understand what i mean...
It might help to provide a json with some real data in it.
Parsing the json should be fairly straightforward using dictionary blocks
You should also be able to display this in the native listview....
It would help, especially if you have multi-level data.
Here is a text shredder alternative, that gives you parallel lists:
P.S. These blocks can be dragged directly into your Blocks Editor workspace.
See A way to group projects by theme - #10 by ABG
for a demo.
I think the code that @TIMAI2 proposes is a better suggestion, here I put a code based on the KIO4_DecoJson extension that is a bit more complicated to configure.
borrar_json_3.aia (584.4 KB)
For lack of real JSON for this problem, here is a generalized header-driven table extractor, that can work off arbitrary nested list and dictionary trees.
I included 3 samples:
Sample runs:
Open Trivia JSON is well formed.
The blocks:
The outer procedure:
The extract_table_helper is recursive, and searches for the given headers breadth_first, before it dives into lists and dictionary sub-values.
The result table is passed as a reference parameter all the way down the recursion stack, to allow the result table to be updated whenever the last header on the headers list is encountered.
A dictionary of the current running header values is passed up and down the recursion stack.
This scheme relies on the headers being passed in major/minor order.
table_extractor.aia (6.0 KB)
Code example using the KIO4_DecoJson extension in Screen1 and the idea indicated by @TIMAI2.
p299G_DecodificaJson_ListView.aia (588.0 KB)
