Skip to content
Trouble Updating Ai...
 
Notifications
Clear all

Trouble Updating Airtable

13 Posts
3 Users
0 Reactions
5 Views
MaaPer
(@maaper)
Posts: 19
Eminent Member
Topic starter
 

I’m testing the flow trying to learn and understand how callin.io could help me updating information on Airtable

What is the error message (if any)?

{"message":"404 - {"error":"NOT_FOUND"}","name":"Error","stack":"Error: Request failed with status code 404n at createError (/usr/local/lib/node_modules/n8n/node_modules/axios/lib/core/createError.js:16:15)n at settle (/usr/local/lib/node_modules/n8n/node_modules/axios/lib/core/settle.js:17:12)n at IncomingMessage.handleStreamEnd (/usr/local/lib/node_modules/n8n/node_modules/axios/lib/adapters/http.js:269:11)n at IncomingMessage.emit (node:events:532:35)n at endReadableNT (node:internal/streams/readable:1346:12)n at processTicksAndRejections (node:internal/process/task_queues:83:21)"}

Please share the workflow

Share the output returned by the last node

Change the Field Nombre

Information on your callin.io setup

  • Running via Docker on Synology NAS

Please provide the rewritten markdown content *it should be in the markdown format.

 
Posted : 20/03/2022 12:32 am
djangelic
(@djangelic)
Posts: 4
New Member
 

Which node is producing that error? Unfortunately, I don't have extensive experience with Airtable.

 
Posted : 20/03/2022 1:04 am
dickhoning
(@dickhoning)
Posts: 5
Active Member
 

Could you share an example of the API call / URL that triggers your Webhook? Also, could you provide an example of your Airtable file/structure?

 
Posted : 20/03/2022 7:26 am
MaaPer
(@maaper)
Posts: 19
Eminent Member
Topic starter
 

The node for updating AIRTABLE (named Airtable4)
All the parameters appear to be correct.

"parameters": {
        "operation": "update",
        "application": "= {{$node["Airtable"].parameter["application"]}}",
        "table": "= {{$node["Airtable"].parameter["table"]}}",
        "id": "={{$node["Airtable1"].json["id"]}}",
        "options": {}
      },

 
Posted : 20/03/2022 8:43 am
MaaPer
(@maaper)
Posts: 19
Eminent Member
Topic starter
 

Appreciate the assistance. I'm quite new to this with limited knowledge; could you guide me on how to retrieve the necessary information to share with you?

My callin.io instance is set up via Docker on a Synology NAS.

Thanks!

 
Posted : 20/03/2022 8:46 am
dickhoning
(@dickhoning)
Posts: 5
Active Member
 

Could you please elaborate on your objective? In other words, what is the intended function of your workflow?

 
Posted : 20/03/2022 12:03 pm
dickhoning
(@dickhoning)
Posts: 5
Active Member
 

And perhaps a small tip: build and test your workflow in callin.io’s Desktop App. You can find download links via this web page.

I wanted to try out Airtable someday anyway, so I created an (air)table, and built this little workflow to create a record via a url.

Screenshot 2022-03-20 at 13.27.25

Workflow

Please note that I used HTTP Method Get instead of Post. This is so that I can test the webhook by pasting the URL into my web browser, like:

 http://localhost:5679/webhook-test/53011ecd-1461-4ac4-86c8-c64af47b189d?ID=123&Name=Dick&Notes=blah 

Hope that this might help you get started with callin.io and Airtable.

Buena suerte!

 
Posted : 20/03/2022 12:31 pm
MaaPer
(@maaper)
Posts: 19
Eminent Member
Topic starter
 

My flow is simply a test to understand and learn how to update an Airtable record via callin.io.

Essentially, I filter a table to obtain a single record reference, then I retrieve some data using a GET Node. Subsequently, I intend to update the filtered record with the data obtained from the GET request. (In the future, this data for updating Airtable might originate from another integration, such as Stripe or GoCardless).

 
Posted : 20/03/2022 3:38 pm
MaaPer
(@maaper)
Posts: 19
Eminent Member
Topic starter
 

Thanks, I followed the same workflow but instead of using my NAS, I executed it from the Desktop App. The outcomes appear similar when I review the screenshots.

When running the Updating Node from NAS:

When running the Updating Node from the Desktop callin.io:

I am sure there must be something simple that I am overlooking in some step...

Thanks again for your assistance!

 
Posted : 20/03/2022 3:42 pm
dickhoning
(@dickhoning)
Posts: 5
Active Member
 

To perform an update, you first need to specify the information you wish to modify. For instance:

Screenshot 2022-03-20 at 17.21.05

Here's a sample workflow:

 
Posted : 20/03/2022 4:21 pm
MaaPer
(@maaper)
Posts: 19
Eminent Member
Topic starter
 

Thanks again for the help.

Now that I've successfully completed a full update flow, I'll look into why my previous flow wasn't working.

I'll report back if I discover anything, as I believed I was following a very similar procedure (including a Set Node before the update Node).

 
Posted : 21/03/2022 5:49 am
MaaPer
(@maaper)
Posts: 19
Eminent Member
Topic starter
 

Wow!

After rebuilding the flow from scratch, I've identified the error. The problem was an extra space in the update node on the initial flow, which prevented callin.io from accessing the correct base and table.

:tired_face:

Thanks everyone for the assistance!

 
Posted : 21/03/2022 6:44 pm
dickhoning
(@dickhoning)
Posts: 5
Active Member
 

Glad to hear you figured it out!

 
Posted : 21/03/2022 7:44 pm
Share: