Skip to content
Level 2 - Combining...
 
Notifications
Clear all

Level 2 - Combining and adding data to Airtable

6 Posts
4 Users
0 Reactions
6 Views
BeardedWarlock
(@beardedwarlock)
Posts: 3
Active Member
Topic starter
 

Hi

I'm working through the level 2 course and have configured the nodes correctly according to the instructions. However, I'm encountering an issue where the fields.region and fields.subregion are not updating from the name.region and name.subregion fields in the HTTP feed. When I merge these, the output (set to both inputs merged) shows that the matching is happening correctly.

After the merge, I proceed to the Airtable update node. I've set the correct Base and Table IDs, but the update isn't occurring. Using 'All Fields' results in an error, so I've attempted to update fields individually. My question is, how do I specify that fields.region should be updated with the value from name.region?

Nodes

Merge

AirTable (this shows the correct matching on the left but no update on left)

I hope you can assist (please!)

 
Posted : 27/07/2023 2:09 pm
jesperbylund
(@jesperbylund)
Posts: 1
New Member
 

Hi

If it’s just the fields.region that is missing, you can do the following: Before the update node, add a set node that changes the name of name.region to fields.region.

 
Posted : 27/07/2023 2:31 pm
BeardedWarlock
(@beardedwarlock)
Posts: 3
Active Member
Topic starter
 

Thanks, that really helped clarify things. I believe I need to use the ID from Airtable for the record ID. However, as soon as I do, I get this error:

ERROR: Your request is invalid or could not be processed by the service

You must provide an array of up to 10 record objects, each with an “id” ID field and a “fields” object for cell values.

I've searched the forum for this, but I'm a bit of a beginner and got a bit lost with the responses.

Does anyone have any suggestions?

 
Posted : 27/07/2023 3:29 pm
BeardedWarlock
(@beardedwarlock)
Posts: 3
Active Member
Topic starter
 

Understood. For some reason throughout this process, my Airtable fields were contained within an array named fields. So, while the SET control was utilized to resolve this (thanks jesperbylund), I also had to rename the ID field in Airtable. It is now updating correctly.

Thanks for the assistance.

 
Posted : 27/07/2023 3:36 pm
EmeraldHerald
(@emeraldherald)
Posts: 5
Active Member
 

Thanks for posting your solution!

 
Posted : 27/07/2023 3:36 pm
system
(@system)
Posts: 332
Reputable Member
 

This discussion was automatically closed 7 days following the last response. New replies are no longer permitted.

 
Posted : 03/08/2023 3:36 pm
Share: