How can I get Number of Records in a JSON Data

[none (Aditya Sharma)]

I am fetching data from Airtable using API and the Web Component. So, the data is in JSON format. Now I want to know the number of records in that data. I am using the JSON Extension. Please help me with this…

[WatermelonIce (Bryan)]

Which JSON extension?

[none (Aditya Sharma)]

The Extension is JsonUtils

[WatermelonIce (Bryan)]

One more thing, could you give me an example json so that I would know how the structure looks?

[none (Aditya Sharma)]

Okay, I want to create a List. I have provided all the List in the Airtable. So If I have 10 lists in the Database. I will dynamically create 10 lists in my app. So How will I get the number of List or records which I have provided in the Database? But I don’t want to use the Airtable Component, I will use the API and the Web Component. I hope you got the Point…

[dora_paz (Dora)]

See an example here

{
    "records": [
        {
            "id": "rec0kNhBSfBZ6uA6n",
            "fields": {
                "Name": "dora",
                "phone number": "(999)-999999999"
            },
            "createdTime": "2021-05-19T15:04:11.000Z"
        },
        {
            "id": "recHGhMXZmOXTWcVO",
            "fields": {
                "Name": "mary",
                "phone number": "(333_-333333333"
            },
            "createdTime": "2021-05-20T08:19:23.000Z"
        },
        {
            "id": "reccud1wpNW0tXS5H",
            "fields": {
                "Name": "john",
                "phone number": "(444)-555555555"
            },
            "createdTime": "2021-05-20T08:19:33.000Z"
        },
        {
            "id": "receINv0BO2xtKGSp",
            "fields": {
                "Name": "nick",
                "phone number": "(666)-999999999"
            },
            "createdTime": "2021-05-20T08:19:35.000Z"
        }
    ]
}

[WatermelonIce (Bryan)]

According to this, you can get the records array and use the arraylength method.

[none (Aditya Sharma)]

thank you very much it worked…

[Still-learning (1-2-3-4...)]

I hope instead of using JSON array method, if you use this , you can see the few sec speed up the process. Earlier me too used JSON array only but after this I forget it due to simple blocks .

Error Using Airtable's component Get All Rows

That kind of error is obtained when you try to get data from a Json and the logic you use to extract the data does not match with the structure of the json Here is an example of how you can get data from Airtable using the GetAllRows block (with this block you get a Json in the response content) using dictionaries Note: In airtable it is easier to get each column and then work with those data as lists This is my Airtable structure: [imagen] We create the variables for each airtable column.…

[WatermelonIce (Bryan)]

Agree, I also prefer the build-in dictionary blocks, as it is easier and has much more features.

[dora_paz (Dora)]

Me too, I also prefer to work with dictionaries