Streaming live at 10am (PST)

Get an item from the CMS based on a specific field

I’m working on integrating a specific API to the CMS that creates Items. On occasions, I will need to update an item. I’m using the Webflow API of course.
I’m trying to figure out if there is a way to search through the items in a collection and get an item based on a specific field value. Kind of like querying for posts by meta value in WP. Are there any ideas or workarounds available?
Thanks in advance.

Hi @Gaia have a look at this … all available in the API docs… is this what you are looking for?

Thanks, but I know the docs :slight_smile: unless Im missing something I did not find a way to get an item based on a field different than the ID

One year later, still no possibility to search a CMS Item by custom field ?

Any update on this? @Gaia did you find a work around?

Lookup tables…

My typical approach has been to backup the CMS into Airtable and then via Integromat (or Zapier) you can search by field values in Airtable. Each row in Airtable has the CMS Item ID so if you need to reference that CMS Item you know can :grinning_face_with_smiling_eyes:

@ChrisDrit does Airtable automatically populate the CMS Item ID? That would be awesome, but I’ve only ever seen tutorials where designer has to go into the CMS list and manually input a field for CMS Item ID. Haven’t actually used Airtable but would hop in if it does that. Thanks!

Gosh no, nothing manual :grinning_face_with_smiling_eyes:

You can setup a Webhook that sends any newly added/edited/deleted CMS item into Airtable automatically.

Here’s a tutorial I wrote walking through how to do this (step-by-step):

Happy to answer any questions here…

1 Like

@ChrisDrit Wow. What a great writeup. Wish I had found this 3 weeks ago when I ended up building my own Webhook Server because I couldn’t figure out why Integromat wouldn’t allow me to select a trigger other than “Form Submission.” :joy:

1 Like

:pray: sorry you didn’t see it then but good to hear it’s open up some doors for you :slightly_smiling_face: