Best answer

How do I load a Monday.com item by its ID to avoid duplicates when adding to a board?


Scenario - 

CRM entry (FollowUpBoss) get status changed.

Creating zap to add item to “Active Files” board.

I want to make sure I’m not creating duplicates, so when initially create an item, i’m writing the ID back to FUB in a custom field.

Great.  I can _get_ the item’s id when I create it, but how can I then later _LOAD_ an item from monday by its ID?

 

The “Get Item By Column Value” action does not have “Id” as an option.

 

I don’t see any other “Load Item” or “Get Item” or anything like that.

I can UPDATE MULTIPLE using the item ID, but that seems to fail if item id is blank or doesn’t exist.  

How can I search a monday board by the Item ID?  Item names change - that’s a poor “key” value to use. 

 

Thanks!

icon

Best answer by Troy Tessalone 26 June 2023, 17:38

View original

10 replies

Userlevel 7
Badge +14

Hi @chavousc 

Good question.

The Monday API has to be used: https://developer.monday.com/api-reference/docs

Using app APIs in Zaps is an advanced approach.

If you need help, consider hiring a Certified Zapier Expert: https://zapier.com/experts/automation-ace

 

Check this guide:

 

Hi @chavousc 

Good question.

The Monday API has to be used: https://developer.monday.com/api-reference/docs

 

 

I was afraid that would be the answer.  Not beyond my skillset… just…. Not how I wanted to spend my morning. 

 

Thanks for confirming!

Userlevel 7
Badge +14

@chavousc

Check this guide:

 

Got it thanks.  

Userlevel 7
Badge +6

Hi @chavousc,

Awesome! I’m glad Troy was able to point you to the right direction!

If you have any other questions, please don’t hesitate to reach out in the Community. We’re always happy to help! 😊

 

Hi @Troy Tessalone 

I tried this and I get the following error.  I’ve also attached a screenshot of my POST in Webhooks.  

 Basically I have a column called name but the column ID shows text5 (screenshot attached).  I want to know the item id for this row so I can update that row in my next step in Zapier but I keep getting this error.  Should I be replacing items_by_column_values with a different value?  Any help would be greatly appreciated.

Thank you,
Darren

 

Userlevel 7
Badge +14

@DarrenG 

Post screenshots of the Headers you configured.

@Troy Tessalone 

Please see screenshot. I feel like I’m so close but something is obviously missing.

 

Userlevel 7
Badge +14

@DarrenG 

Try removing the trailing line break at the end.

 

Userlevel 7
Badge +14

@DarrenG 

Resources

https://developer.monday.com/api-reference/docs/introduction-to-graphql#query

https://developer.monday.com/api-reference/docs/introduction-to-graphql#graphql-visual-interface-graphiql

Reply