Airtable api to upload data

[Dario_R_Navarro]

HI!! To get data from airtable (filtering and sorting data) I recently learn to use AIRTABLE API without api-keys.

Now I need to upload/modify/erase data to airtable table. But I don't understand how to do it after watching API-HELP from airtable.

Someone can to guide me??

Thankssssss!!!!!!!!!!!1

[TIMAI2]

Perhaps this ?

Airtable extension - 浮云小站

[Dario_R_Navarro]

Thanksss, but I was thinking to use Airtable using API with WEB component.

[TIMAI2]

Then see here to convert curl commands to blocks

cURL to blocks automatic generator

You can convert cURL command to AppInventor blocks hassle free Convert curl to blocks by Getaix Preiview [image] How to? Copy & Paste curl text into the textbox Hover over generated blocks and click download image Drag and drop downloaded image to AppInventor workspace Report bug if found cURL to blocks by Getaix is inspired from CurlToBlocks by @HritikR . CurlToBlocks by Getaix is still in beta and would like to know your reviews. Thank you Jerin Jacob

You may still have more work to do but it gives you an idea....

[Dario_R_Navarro]

yes, Thanks.

[Dario_R_Navarro]

where I put the data to store??

[TIMAI2]

Use a POSTText block, and put your data into a dictionary format, that matches what you show above.

[Dario_R_Navarro]

Hello,

I'm trying to get data... but I am doing something bad....

I'm using this blocks:

This is the response content/code:

I get 200 code: conecctión is ok, but I don't get nothing.

Do It Result: from frist Make Dictionary block

{"records":
["fields:",{
"IdPedido":0,
"IdCliente":0,
"EstadoPedido":0,
"ListaPedido":"38.85",
"ComentarioPedido":"comentarios n",
"FechaPedido":"05/15/2023 16:31",
"PedPagado":0,
"PVPPedido":"Efectivo",
"FormaPago":100,
"PlayerIdPedido":0,
"NombreCtePedido":"",
"TlfClientePedido":"",
"DireccCtePedido":""
}
]
}

Any idea??

Thansssss!!!!!

[TIMAI2]

This is the dictionary format for an example record

{
"records": [
{
"fields": 
{

"field1":"one",
"field2":"two",
"field3":3,
"field4":false

}
}

]
}

I believe you are missing a set of curly brackets (marked with XX)

{
"records": [
XX
"fields:",{

"IdPedido":0,
"IdCliente":0,
"EstadoPedido":0,
"ListaPedido":"38.85",
"ComentarioPedido":"comentarios n",
"FechaPedido":"05/15/2023 16:31",
"PedPagado":0,
"PVPPedido":"Efectivo",
"FormaPago":100,
"PlayerIdPedido":0,
"NombreCtePedido":"",
"TlfClientePedido":"",
"DireccCtePedido":""
}

XX
]
}

[Dario_R_Navarro]

Hi again....

I'm trying and trying but something I am doing wrong...

this is the DO IT result from dictionary: It's look OK.

But, how you can see, the Response CODE = 200, but RESPONSE CONTENT= [NO RECORD]

What I am doing wrong?????

[Taifun]

You are trying to send a POST and a GET request at the same time... what does the API expect? POST or GET?

Edit: it looks like you are trying to upload data? Remove the Get block...

Taifun

[Dario_R_Navarro]

POST, I just want to post. Create a new record in Airtable. I mistakenly thought that the last block activated everything. I'm delete the GET block. I Will try again... Thankx!!

[Dario_R_Navarro]

Finally I got to upload data to Airtable with this block:

POST or GET?

and using only POST block...

And (for other noob like me) to UPDATE records exactly same but using PATCHTEXT bock and you need to indicate record ID to update.

As always, thanks @Taifun @TIMAI2 for your tireless help!!!