Khargeswar
(application developer)
December 27, 2021, 7:52am
#1
Hello kodars
I want get all the data of my spreadsheet for my admin app. All the data’s are coming successfully but it is not coming in that format as what i aspecting. Please help me.
dora_paz
(Dora)
December 27, 2021, 7:56am
#2
You are using got all rows, so the response is in json format. After got all rows response you have to use dictionary blocks in order to get data
1 Like
As per your block , it works fine and shows the result. If you want data columwise then You must split JSON response into fields, from the fields you need to separate each colum into separate list, and then create dynamic component
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.…
1 Like
dora_paz
(Dora)
December 27, 2021, 8:30am
#6
Pm me your aia if you wish to check it
1 Like
Khargeswar
(application developer)
December 27, 2021, 8:31am
#7
I have modified my blocks according to this article. it is not working…no any error…
dora_paz
(Dora)
December 27, 2021, 8:54am
#8
Just add select item list global Title index get number
1 Like
Khargeswar
(application developer)
December 27, 2021, 9:03am
#9
Thank you dora_paz. It is working good.
1 Like
system
(system)
Closed
January 26, 2022, 9:04am
#10
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.