404 Not Found Error - Airtable Update x Memberstack

[Sam_Beattie]

Hi all,

I am trying to set up a Scenario where updates to users in my Memberstack account flow through automatically into Airtable. I have set up the Connections to both and have the Watch Updated Members webhook from Memberstack delivering the correct output, however I can’t figure out how to get that output to update the corresponding table in Airtable. I’ve noticed from another post that you need to add a Search module in between the Memberstack Watch Updated Members listener and the Airtable Update a Record. But can’t for the life of me figure it out…

I’ve already double checked the Connections and tried rebuilding the Flow again with entirely new webhooks with no luck. I am probably missing something stupid so if anyone can please let me know what that would be great! Thanks in advance!

Scenario

Payload from Memberstack:

Tried to replicate the mapping Memberstack output to ‘internal ID’ of Airtable in Search Module (as advised by another community thread)

But getting this error:

Scenario blueprint

Update user in Airtable.blueprint.json (38.1 KB)

Output Bundle from Memberstack:
[
{
“auth”: {
“email”: “sambeattie1994+2@gmail.com”
},
“customFields”: {
“acquisition-channel”: “Social”,
“agent-description”: “My agent is a support bot that is designed to solve user queries.”,
“agrees-marketing”: “”,
“company-name”: “Awin”,
“company-size”: “$5m+”,
“company-website”: " Join our global affiliate marketing platform UK | Awin ",
“department”: “Other”,
“description”: "Affiliate ",
“first-name”: “Sam”,
“last-name”: “Beattie”,
“orchestration-platform”: “Langsmith”,
“user-id”: “user_id”,
“user-is-internal”: “is_provider”,
“user-plan”: “user_plan”,
“user-type”: “account_type”
},
“id”: “mem_sb_cmezrbeyh007o0wp39tb14qgf”,
“metaData”: {},
“profileImage”: null,
“stripeCustomerId”: null,
“verified”: false
}
]

Please let me know if there is anything else I need to provide

[AJ_Dev]

Hey @Sam_Beattie,

Assuming the text field name in Airtable where you store the Memberstack member ID is “ID”, you can have the formula in the Airtable Search Records module as {ID}=’MAP_MEMBER_ID_FIELD’ where you can map the Member ID field from Memberstack module.

You are almost there, just ensure that you have the mapped field enclosed in quotation marks as shown in the screenshot below (my field is named as ‘Name’, it would be ID in your case.):

This should fetch you the record which has the relevant member ID in Airtable. Hope this helps.

[Sam_Beattie]

Hey @AJ_Dev , thanks for getting back to me and apologies for the slow response!

I have amended the formula to your suggestion:

and ensure the field in Airtable has the same value:

Now I am getting a new error saying the formula for filtering records is invalid…

Can you please let me know what you think I should do next?

Thanks!

[AJ_Dev]

Hey @Sam_Beattie ,

The quotation marks used in the Airtable formula seems to be a bit inaccurate if you compare the screenshot that I shared earlier with your input or the output screenshot - either it is a backtick or looks like it has some formatting applied (this happens when we copy paste it and some formatting also gets applied along with it).

Can you ensure you have typed the single quotation marks, to avoid confusion you can use double quotation marks instead, and the formula should work the same.

Let me know once you have made this change / ensured that the quotation mark is typed out and tested the flow. Hope this helps.

[Sam_Beattie]

Ahhh that worked! Thanks mate!