About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Best answer

Make `,1` work in line itemizer?

  • 18 April 2024
  • 1 reply
  • 38 views
H

Currently building a private integration where data extraction is performed

 

Screenshot

 

 

Problem is from step 3 to step 4, I tried to line-itemize a `,1` line item output from 3, with config as below

Note this `,1` means empty `` for product A, `1` for product B

Pay attention to `Quantity` value - `,1`

 

When testing, it converted into `productA: 1; productB: none` instead

 

Here’s the bug - if I manually input `,1`, it works as expected

 

Does anyone know how do I fix this? Should I avoid using Zapier line-itemizer and create my own with string manipulation?

 

Thanks a lot!

 

icon

Best answer by Osas 18 April 2024, 15:12

View original

1 reply

O
Userlevel 2
Badge +2

Hi @hungry-pikachu,

Mapping “,1” from step 3 just as you have done renders the value in the Line Itemizer as [“,1”, “ “] which assigns the value “,1” to product A and a blank value to product B.

The format you want is [“ “, “1”] and that would only be achieved in the Line Itemizer by manually typing `,1` in the Line Itemizer (not mapping it from a previous step).

I would suggest that you do either of the following:

  • Return just “1” from the “Find Async Extraction Result” action and manually specify the location in the Line Itemizer

    OR
     
  • Directly return the line item from the “Find Async Extraction Result” action (you may have to manipulate the action’s code to return this). This article should help: Return your data as line item

I hope that helps.

Reply


Terms & Conditions