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.

I have a ZAP set up that a Quickbooks Online invoice is created. I then have a filter that looks for the line item descriptions. If one of the line item descriptions matches a value in a Zapier table, I need to update that specific line items product.

The problem I'm running into is on the update invoice action, I cannot figure out how to specify an individual line item.

I have followed guides on handling line items, look at videos, and other support articles and I just cannot figure out how to individually target a specific line item. Does anybody have an experience with this and can help me figure it out?

Hi ​@LPI 

 

To target a specific line item you need to isolate it of course. The line item is basically an Array, so there are several ways to isolate it:

  1. Use a code step by Zapier to get the line item you need then manipulate it
  2. Use a Loop by Zapier to loop through all the items individually, you can add a filter at the beginning of the loop so you can target the line items you want

It looks like you're struggling to target specific line items in QuickBooks Online via Zapier. One thing you can try is capturing the line item IDs when the invoice is first created. This way, you can reference those IDs to update the correct line item later.

If that doesn’t work, you might need to recreate the invoice with the updated line items, as Zapier doesn’t always allow for granular updates like this.

Let me know if that helps or if you need more info!

I tried to use a filter inside of a loop. But I am never able to actually test it because the records that I'm testing against have it on the 2nd line item. And I'm only seeing an option to choose the first line item. Even though it I don't think it should matter because each one of them should be an iteration.

Looping through line items.
Line item 2 returns the QBO invoice description I am looking for.
Selecting the loop iteration fails in testing. I cannot ensure the line item I need is always going to be the second line item.

Is there something I am missing? 

​@Adil Waqas How would I capture a specific ID? 

In the testing it will only give you the first item, but when it's on it will actually loop. 

Terms & ConditionsAccessibility statement