Skip to content
Mapping Scenario Da...
 
Notifications
Clear all

Mapping Scenario Data to Airtable 'Update Record' Module

7 Posts
2 Users
0 Reactions
5 Views
ryebag
(@ryebag)
Posts: 10
Active Member
Topic starter
 

What is the workaround for this? To illustrate, I have a social media post scheduler. I want it to post the content, then update an Airtable field to "Posted". However, the Airtable Update Record Field within the module does not allow me to map the Base ID or Table ID using data from previous modules. This seems to render the module fundamentally useless.

The reason I need to set it up this way is because it needs to function as an app, so all clients can run through a single series of scenarios and be able to handle dynamic data.

Notice Mapping Ability in Search Records:

Does Not Exist in Update Record Module:

So, updating a table dynamically is impossible.

Unable to Map Airtable Data in Airtable “Update Record” Module
Cannot Map Airtable Data in Airtable “Update Record” Module

 
Posted : 15/07/2024 7:06 pm
Donald_Mitchell
(@donald_mitchell)
Posts: 36
Eminent Member
 

Hello,

For this, you'll need to utilize the Make an API Call module and interact with the update record endpoint.

It appears they've omitted the capability to map those two fields, which is often due to their reliance on RPCs. This is likely a safeguard to prevent invalid data from being entered into fields that the RPC depends on, which could cause failures.

 
Posted : 15/07/2024 8:36 pm
ryebag
(@ryebag)
Posts: 10
Active Member
Topic starter
 

Could someone assist me? I've spent approximately 5 hours attempting to configure an API call in various ways. Currently, I'm using the HTTP "Send a Request" module. I can successfully retrieve data using GET requests, but whenever I attempt POST or PATCH requests, I encounter one of several different errors. I don't have a coding background, but I've tested this in Postman, where I can perform GET requests but not PUT or PATCH. I'm unsure about API concepts and the structure of API JSON code.

All I'm trying to do is modify a cell, and it's taking me about 12 hours, which is incredibly frustrating. I've looked through many community posts about Airtable, but none have been helpful.

GET:

PATCH:

 
Posted : 15/07/2024 11:01 pm
ryebag
(@ryebag)
Posts: 10
Active Member
Topic starter
 

I attempted to use the code as shown in the API example, but it didn't function as expected:

 
Posted : 15/07/2024 11:09 pm
Donald_Mitchell
(@donald_mitchell)
Posts: 36
Eminent Member
 

Why is there a warning next to the JSON?

From what I can see, everything appears correct. I just tested it in Postman, and it's functioning for me on my Base.

 
Posted : 15/07/2024 11:22 pm
Donald_Mitchell
(@donald_mitchell)
Posts: 36
Eminent Member
 

Could you also show us the configuration of your headers?

 
Posted : 15/07/2024 11:26 pm
ryebag
(@ryebag)
Posts: 10
Active Member
Topic starter
 

Yes, I'm quite certain there was an issue, possibly an API outage, as the API was unresponsive for a period. It's functioning correctly now. Thank you for your assistance.

 
Posted : 16/07/2024 12:13 am
Share: