Streaming live at 10am (PST)

Using Integromat to batch update multi-reference items - Error: 400 invalid request body

Hi,

I’ve set up an automation using Integromat to update a multi-reference item field in a CMS collection based on a rollup of item IDs of each of the items I want to use as multi-references in Airtable. (Hard one to explain online - please ask me to clarify if this isn’t clear).

I’m using the PATCH method on a custom HTTP request.

The response returned is “The operation failed with an error. [400] ValidationError: Invalid request body” in Integromat, but it works perfectly on Postman, so I’m struggling to debug. I think I’m using the right syntax.

I included the name, slug, archived and draft fields after reading on here that they are required in the request body.

Integromat support didn’t seem to know what the issue was.

Here’s the body I’m trying to send (the rollups are for each of the multi-ref fields I want to update).

Can anyone help?

Thanks in advance!
Will

@Will_Hepworth I am also experiencing the same issues. Let me know if you manage to resolve it!

Hey @Will_Hepworth and @MGAVIOLI66, have either of you managed to solve this? I’m experiencing the same issue and have had no luck. It’s working fine on Postman but I’m receiving a 400 in Intergromat. :man_facepalming:

@webseeds I’ve been slowly gaining more momentum using Webhooks and HTTP call’s.
It’s still a bit hit and miss. Happy to share some of my working scenario’s with you if you can give me some indication of your scenario setup, as alot of my focus has been using Memberstack which has other challenges I’m finding.

https://forum.memberstack.io/t/update-specific-user-in-cms/160/23

@MGAVIOLI66 Any progress is moving in the right direction! :grin: Thanks for offering to share some of your working scenarios. That would be very helpful!

Here’s a screenshot of my current scenario:

Here’s how it works on a high level:

1.) Watch on Airtable base using Last Modified Time
2.) Router to update Webflow item if Webflow CMS ID exists in record or creates a Webflow item if the Webflow CMS ID doesn’t exist
3.) Update the Webflow CMS ID record in Airtable
4.) Patch request to Webflow to update multi-reference items using a rollup and lookup (See below for screenshot of the request)

Every time I get an error on the PATCH request:

I regret to hear you’re now facing some challenges with MemberStack. I hope you get them worked out soon! I am also using MemberStack but i’m a bit behind where you are. My current focus is on curated CMS items. User submitted data is coming next.

Thanks again for your help!

Hi Luke,

I ran a simple Airtable (Watch records) and update a multi-reference field in Webflow Collection item in a Loom.
Let me know if this is of any help?

Big thanks to @GlennAtTheFlow for his series

1 Like

My pleasure Matt :blush: I hope it’s all going smoothly for you now?

1 Like

All is well @GlennAtTheFlow just having trouble pulling through Custom fields from Member Stack.
:exploding_head:
I think there is a serious issue with Custom Fields on the MS end.

@MGAVIOLI66 Thanks a lot for the Loom mate, super helpful. I’m working on a two-way reference solution currently. I’ve got it working for single references and about to tackle multi-references, however, I’ve been using Google Sheets. Airtable looks like a much better solution.

1 Like

Hey Matthew - I’m trying to do the same sort of connection from airtable - webflow with integromat, and I’m having a lot of trouble.

I have a collection list in Webflow that I want to make a lot of updates to, and I have duplicated the data from the list in airtable. I’ve created lookup columns for each field to show the CollectionID (because it’s not supposed to be the ItemID, right?). When I try to make the link in Integromat, I don’t have the option to select the CollectionID column. I’ve ran this three times thinking that it could link on just the name of the collection item, but after watching your Loom video, it looks like that’s not the case. See screenshots.

Any ideas? Shot in the dark here, but if you have some time this week to hop on a quick call, I’d really appreciate it. Feel free to email me: toby@chezie.co

@Toby_Egbuna I haven’t been automating lately, as I’ve had too much work on. So I’m a bit rusty!
What error are you getting?

@MGAVIOLI66 No problem! Thanks for the response.

If you look at the screenshots, I can map the company field in airtable to the company field of my CMS collection, but when I run the scenario after making changes in airtable, those changes aren’t reflected in the webflow cms. I’m not getting a specific error (not with that field at least), but the data isn’t changing.

I watched some of the videos you linked in one of your earlier messages, and I saw that he said that you have to make the links based on the CollectionID, so I added columns to my airtable spreadsheet with the Collection ID for each company. When I went back to make the updates in Integromat, I don’t have the option to link it to that column in the spreadsheet (see screenshot).

Does that make sense?

Hey Toby, I’ve been doing a fair bit in Integromat lately - From the screenshot, it looks like you need to map the Item ID to the company field not the Collection ID.

Hey! I actually figured it out. You’re right. Needed to map it to the item ID instead. Appreciate the help