Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Troubleshooting missing Line Items ID in Quickbase from Shopify updates

  • February 13, 2025
  • 3 replies
  • 26 views
M

I have a zap setup to enter a Quickbase record when a shopify record is updated. It was working fine and then Zapier made some updates and now I randomly get an error message and a missed zap. It is pretty low frequency but high enough to be a problem. Below is a screenshot of the most recent event. When I checked this order in shopify it is from a Bold subscription purchase (Shopify plug in app) and I’m wondering if that is messing with the ID. It doesn’t happen every time. I cannot see where this ID is empty.

 

 

 

Did this topic help you find an answer to your question?

3 replies

escalateur.com

Hi! Just from the error message, it looks to me that the step just doesn’t know which record to update. 

 

Since you mentioned that it only fails occasionally, could it be that the failures only happen to items that are new to Quickbase? This would explain why this ID doesn’t exist yet.

 

If this matches your experience, a fix might be to split the flow after your trigger with the condition being “1. Line Items ID → Exists” vs “1. Line Items ID → Does not exist”. And respectively adding a “Update Record” and “Create Record” step afterwards. This way you’d be sure that the “Update” action only takes care of preexisting records.

 

If I understood wrong please feel free to share a screenshot of the “Data in” tab :)

Adrien
M
1 person likes this
  • M
    Mechomni
M
  • MechomniBeginner
  • Author
  • Beginner
  • 1 reply
  • February 13, 2025

Hey thanks for the response. I don’t think that’s the case because it’s not a new item. Here is a screenshot

 

 

escalateur.com

Ok thanks for these new details! 

 

Since this action is expecitng an array as an input, it’s possible that it’s only a problem of formatting.

 

Could you try to add a formatting step just before, so as to transform this ID (which I assume is in string format) into a line item value?

 

Formatter > Utilities > Text to Line-item. Then use the output in your Quickbase step. Note that if this is indeed the solution, you may have to repeat it with all of the other fields.

 

An alternative may also be to simply change the step to the more classic “Update Record” Quickbase step. This one should not be expecting Line-items.

Adrien

Reply


Terms & Conditions