Searching A Specific Value From A Long And Complicated JSON

Im working with a project which deal with very long and complicated json data structure, i have 3 types of json data and i want a specific string value which is contextJSON but the problem is that, the string contextJSON is not located on a particular location,

If anyone know any logic to find contextJSON from my long json, please suggest me

These are my JSON data i m working with
output 1.txt (41.4 KB)
output 2.txt (96.4 KB)
output 3.txt (125.0 KB)

You need a good json formater


so path shoudl be require, 2, 4, 1, contextJSON

I only checked your output 3.txt

1 Like

Can i do this with the help of inbuilt dictionary blocks

You could also cheat and take advantage of the fact that the text appears only once, and is always followed by ,\r\n"isGuideEmbed":

That's just two text splits, as in the Taifun parse procedure.

Correction - that only works on JSON that has been Tidied.

Because of the varying tree structure in these samples, a more general purpose approach was needed.

Here is my general purpose table extractor, able to extract tables from mixed dictionaries and tables, given a list of headers.

I preloaded it with your 3 sample JSON files.


parseJSON.aia (59.3 KB)
Sample run

3 Likes

awesome its working :heart_eyes: :heart_eyes: :heart_eyes: :heart_eyes:

this block will be enough:

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.