Best answer

Make `,1` work in line itemizer?

  • 18 April 2024
  • 1 reply
  • 43 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!

 

icon

Best answer by Osas 18 April 2024, 15:12

View original

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

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.