Question

How to get an item record from Xero that matches criteria?

  • 26 April 2024
  • 9 replies
  • 40 views

Does anybody know how to get a Xero item line record that matches certain criteria, which can then be used to populate a field in the downstream app?

 

e.g. The quote from Xero will have many item records … we want to bring all the item lines over AND get any Item that matches the word “Misc” to map to a specific field on the downstream app.

 

Hope that makes sense. Any help appreciated.


9 replies

Userlevel 7
Badge +14

Hi @4cubed 

You can use the Looping app to iterate on line items: https://zapier.com/apps/looping/help

Thank you @Troy Tessalone … finding it difficult to understand how looping would work … can you share an example of how I’d do the above? 

Userlevel 7
Badge +14

@4cubed 

For us to have more context, post screenshots with how your Zap steps are outlined and configured.

@Troy Tessalone see attached pdf of steps … hope that makes sense … thanks again 

Userlevel 7
Badge +14

@4cubed 

Step 2 for MRPeasy supports line items.

BUT, the SKU field expects a MRPeasy Part #.

 

It does not look like there is an available MRPeasy Zap action to find part #s.

You may have to try reaching out to MRPeasy Support for guidance about how to get that value to then use in their Zap app integration.

It may involve using the MRPeasy API: https://www.mrpeasy.com/resources/api/

 

 

 

Thank you again @Troy Tessalone  … I do not see this as a MRPeasy question as we may want to take the specific Line Item value and populate another system.… irrespective of MRPeasy how can you get a specific Line Item and Desc value from Xero via Zapier? is there a IF or LOOKUP type action that can get the Item Desc for Item Code = Misc ? 

Userlevel 1
Badge

@4cubed I will message you privately as I am a Xero power use. I am able to follow your example to extract data from Xero! 

Userlevel 7
Badge +14

@4cubed 

If you want to handle each line item individually, then you can use the Looping app: https://zapier.com/apps/looping/help

Action: Looping - Create Loop from Line Items

Map data into the Looping step, then map data from the Looping step to the following Zap action steps.

Userlevel 7
Badge +14

@4cubed 

The Description for a Line Item is an available field to map thru the Looping step.

 

Reply