Error Using Airtable's component Get All Rows

[Ved_Nig]

I have created the app on Kodular using the component sheets.
Then I have used get all rows funcn.
to call all the data present in the app but I am unable to understand the way its response content is written. Can you please help me in decoding it.?
HERE IS .AIA FILE AND SCREENSHOTS

[dora_paz (Dora)]

Can you show the structure of your airtable ? and what are you trying to achieve ? The error is not from airtable but from the json that you are getting when you try to parse

[Ved_Nig]

You Can See it Here:-

Grid view - Airtable

It’s in grid view.

[dora_paz (Dora)]

First of all in order to work with airtable you should never leave empty cells, rows, columns. Fix your table and then proceed with your code. I also suggest to work with dictionary blocks when you get the json response

[balaji_developers]

This is very common

[pepocero]

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:

We create the variables for each airtable column. Note that when you get a Json, you must always get two data that are always the same, which are id and fields:

(In the end I create a result variable to put everything there)

Then with these blocks you get the data from the Name column and the data from the City column:

The foreach block puts the data in a list (result) and it´s displayed on a label

This is the result:

[Ved_Nig]

@dora_paz

First of all in order to work with airtable you should never leave empty cells, rows, columns

Yeah , thank you but actually I was trying to test it first that if it works I would add data.

[Ved_Nig]

@pepocero Thank You very much for the answer. This is a nice method to arrange data.

[dora_paz (Dora)]

You can not test airtable if table is not properly created cause data is not received correctly

[Ved_Nig]

@pepocero

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:

We create the variables for each airtable column. Note that when you get a Json, you must always get two data that are always the same, which are id and fields :

(In the end I create a result variable to put everything there)

Then with these blocks you get the data from the Name column and the data from the City column:

The foreach block puts the data in a list (result) and it´s displayed on a label

This is the result:

I tried this in my app but I am getting another type of result than I want.

I want the red highlighted one only.

Airtable link Here

[Ved_Nig]

@pepocero

GetAllRows

And moreover i am unable to add menu item it is just blank.
Please refer me a tutorial(if any).

[pepocero]

@Ved_Nig

I want the red highlighted one only.

The ListView accepts HTML code.

Just put that html code in the Join block:

And you get something like this:

[pepocero]

@Ved_Nig

And moreover i am unable to add menu item it is just blank.
Please refer me a tutorial(if any).

Tutorial of what? What menu?

If you don’t explain yourself well, people can’t help you. Try it on your own and see what comes out.

[Ved_Nig]

Slide menu item see screen1and slide menu blocks in

[Ved_Nig]

@pepocero

The ListView accepts HTML code.

Just put that html code in the Join block:

I meant how to access urls for attachments in Airtable.
(It gives a query like that)

[pepocero]

@Ved_Nig

I meant how to access urls for attachments in Airtable.

As far as I know, you can’t get files saved in airtable, so we usually use cloudinary to save files and the url is saved in an airtable cell.

If you find a way to get your files saved on airtable, share it with the community