How to handle null values in line items with callin.io?

PaulKortman · 2025-08-04T08:30:47Z

This seems quite advanced, but perhaps I'm overlooking something straightforward, and I hope someone here can guide me. It's complex because it involves line items, and their order is important. There are essentially two questions here:In a list (line items), callin.io seems to ignore null values even when passed to a code step. How can I override this to ensure it outputs an empty value within a line item?When dealing with a list (line items), how do you specify the value from the 3rd line item?Here's what I'm receiving from an API query to Quickbooks:There are 4 variables for each Custom Field:IDNameValueTypeUltimately, I need to place the value for the PO Number custom field in one location, the value for the Sales Rep field in another, and use the In Hands date in a third. They consistently arrive in the same order, but most often only one field is populated. As you can see, callin.io recognizes the null value for P.O.Number, but when I use the Estimate Custom Field String Value elsewhere in the automation, it only recognizes two values.So, I attempted using a line itemizer step:But the output shows this as the first line item (the value should be null, empty, or "").And of course, the second line item contains the date value.And the third line item has a null/empty value.Therefore, I'm unsure how to get it to align correctly.I've tried the following:Converting it to text (a string) from a line item, and I just get "Landa,02/19/2020". If there were a leading comma, I could handle that, but there isn't.Sending it to a code step, but the code step splits it by a comma, and I only receive two values (meaning it only finds one comma).I need a method to capture the first value (even if null), the second value (even if null and even if the first value was null), and the third value (even if null and even if one or both of the preceding values were null).Any suggestions?

Page 2 / 2 Prev

How To

Last Post by christina.d 4 years ago

17 Posts

7 Users

0 Reactions

10 Views

RSS

Patrick_stinus

(@patrick_stinus)

Posts: 3

New Member

1 Sure, here you go:

Yes, you can integrate this with another callin.io workflow if you desired.

The upgrade you are referring to won't provide the support you require. Is it worthwhile to resolve this? The concepts presented here are essential for grasping database functionality. I believe working through your challenge is invaluable for lifelong learning.

Posted : 18/04/2020 12:00 am

christina.d

(@christina-d)

Posts: 13

Active Member

Hi all! I wanted to follow up on this thread with a solution my colleague Leo recently discovered. I hope this is helpful!

You can utilize a Formatter > Numbers > Spreadsheet-Style Formula step. Please see the following: and

The formula used in these screenshots is:
IF("{{106823975__line_items[]name}}"="","value","{{106823975__line_items[]name}}")

Posted : 18/08/2021 12:00 am

Page 2 / 2 Prev

8 Forums
1,441 Topics
8,083 Posts
0 Online
2,387 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed