make give live : I’m wondering if it’s because my source table is in another base in a free airtable account and my target table is another base in a pro airtable account?
Dylan Sather (Pipedream) : trying to use record IDs across bases might cause issues - I’d recommend reaching out to Airtable support on that one. But as long as you know the record ID exists in your target base / table, and you’re using the correct API key in the Update Records step of the workflow, it should work.
I’m not sure what the core issue is, but if it helps, I’ve gone through a working example of updating a record and wanted to show you exactly what I did. I’ve got a table called Main records in which I have a single field - “NAME”. I expanded the first record to get its record ID from its URL (https://airtable.com/tblDROoSB76wiInPE/viwVztTw2g5HOZw0a/recOkepaWtxPRK5j5), and copied that into this workflow.
Running that workflow successfully sets the “NAME” field to “TEST NAME”:
Dylan Sather (Pipedream) : I’d also recommend making requests to the Airtable API manually, as per their API docs. That’s technically all we’re doing in the update step, so doing that can help you troubleshoot with sample data / record IDs. And in this case, I would recommend reaching out to the Airtable team with the Airtable-specific questions. Happy to support you on anything else Pipedream-related though
make give live : I have done many updates using parabola with patch api updates and they work fine. It’s odd because I have tried hard coding the value and the record id that I 100% know exists in the table and have authorized the correct table id and base id and it still doesn’t work
make give live : I’ll try the same code in postman - I’m guessing I’m missing something quite basic but I can’t figure out what
Dylan Sather (Pipedream) : Yeah, I’d recommend first perhaps creating a test base / table and trying the workflow I just linked to above. Then try to work through some of the potential differences. I can see why it’s complex to manage - lots of variables
make give live : it works!!!
make give live : I needed {{steps.format_airtable_records.records}} not {{steps.format_airtable_records} - facepalm 
Dylan Sather (Pipedream) : ah gotcha 
Dylan Sather (Pipedream) : good find
make give live : I’m blown away - Pipedream is no longer a pipedream - it’s some kind of awesome!!!
Dylan Sather (Pipedream) : 
love it!