I’m using Pipedrive trigger and getting product details as line items to a Code zap:
The input data:
When I test, it appears that empty values are stripped out. Here is how “Data in” looks:
Because of that, I’m not able to retrieve the corresponding product values when looping through the line items since because index order is being broken.
Any advice for workaround?
Best answer by Troy Tessalone
+14Hi
Try converting the line items to text: Formatter > Utilities > Line Items to Text
You can specify the delimiter. (e.g. ^)
Then you can parse the text in the Code step using the delimiter to create line items.
I’ve tried using the formatter, however, it doesn’t seem to solve the issue. I've used || as a delimiter. Look at the example for Data in:
As you see the empty line items exists, however without inputs value
And here is what I get in Data out:
The empty line items are gone.
+14
Post screenshots showing how your Formatter step is configured in the CONFIGURE tab while in EDIT mode with the field mappings visible.
Related article to reference that covers the general concept:
+14
+14
If you are looking to hire help, there is a directory of Certified Zapier Experts: https://zapier.com/experts
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
