Skip to main content
Best answer

Make `,1` work in line itemizer?

  • April 18, 2024
  • 1 reply
  • 46 views

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!

 

Best answer by Osas

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.

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Forum|alt.badge.img+3
  • Zapier Staff
  • 43 replies
  • Answer
  • April 18, 2024

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.