I cant parse json.. please Help

[sajibskr000 (AhSan H. SaJiB)]

This is json Url
json stucture

I want these data from each number

What I Have tried

Problem

**

Thanks In Advanced

**

[WatermelonIce (Bryan)]

It seems that your procedure have some problem. Show us the procedure block as well.

[ellailona (Ella-Ilona Stern)]

I’m new to Kodular, and recently I’ve been learning how to convert a JSON string into a dictionary. In my understanding the “Web JSON text decode” method is working on a single level.

For example if I have a string like {“a”:“London”, “b”:{“b1”:12, “b2”:25}} then the {“b1”:12, “b2”:25} value is considered a “string” value with key “b”, so I need to call again the “Web JSON decode” method on the {“b1”:12, “b2”:25} string in order to convert it into a dictionary.

I’m attaching a sample showing my test.

[sajibskr000 (AhSan H. SaJiB)]

procedure is ok… i can get value from airtable.

[ramrajput200021 (Techy Rajput)]

Read this ;

.JSON File Parsing - How I understood It

.JSON File - How I understood It What is Json? (Collected from W3Schools) -JSON stands for JavaScript Object Notation -JSON is a lightweight format for storing and transporting data -JSON is often used when data is sent from a server to a web page -JSON is "self-describing" and easy to understand My View: Now a days .JSON is a language which are mostly used in API services, data structures for storing and receiving as well as dor GeoCoding etc.GeoJson is a perfect…

[WatermelonIce (Bryan)]

@ellailona

“Web JSON text decode” method is working on a single level.

Welcome to the community. Thank you for your information, but I have to say it is wrong. The web JSON decode will make the list of pairs on all level.
I parse the whole JSON text in to list of pairs, and the result is:

[WatermelonIce (Bryan)]

Hello @sajibskr000,
I found the error.
After parsing to itwms_all, it is a list contain 3 list.
after walking all at level, you will get a list contain 1 item. You have to give the index (which is 1)
Therefore, in list by walking key path, add 1 in the middle of the list.

[ellailona (Ella-Ilona Stern)]

Thank you for your follow-up. So the output of the “Web JSON text decode” is actually a list, which might include other lists and so on. Then in my use case the correct code is as attached.

[WatermelonIce (Bryan)]

@ellailona

Then in my use case the correct code is as attached.

Exactly.