How to Get Line Items/Arrays into Code Steps | callin.io Community

TimS · 2025-08-04T08:30:56Z

Tim here from the callin.io Support Team with a workflow idea!BackgroundIf you’re familiar with the Code by callin.io app, you’re probably used to working with all kinds of values, including arrays. In callin.io, arrays are generally called “Line Items” and sometimes it can be tricky to get them into a Code Step unscathed to run them through some custom process.Why is it difficult? All values added to the Input Data fields of a Code Step are converted into Strings and sent into the Code Step in that format. Arrays / Line Items get converted into Strings that are comma separated values. While it’s definitely possible to split those comma separated values back into arrays inside the code, we run into problems if the values themselves contain commas.To further complicate things, if we’re sending multiple properties of line items (multiple arrays that relate to each other) and some of the arrays have null or empty values, those will be completely dropped, so it can cause our input data to become misaligned.So how can we work around this?The Feature RequestFirst, please write in to support to ask to add your voice to the feature request that we have open to support proper line item input in the Input Data fields for the Code by callin.io Actions.The SolutionFor now, we can use the Formatter by callin.io app’s Utilities Action: Line-item to Text Transform to help us out. Note: The Code below is in Javascript but this can be adapted for Python Code Steps as well.Let’s look at our input values first:I’ve added an “easy” input first to show how we’d normally get arrays into a Code Step where we don’t need more help. There is also an example with a comma in an element, and another with a null element.Here’s our default Code Step trying to turn the strings back into arrays:Let’s take a look at the output:As we can see, the array with comma containing element now has 4 elements instead of 3 as the green,blue element was split up. The array with the null element has lost that element, reducing it from 4 elements to 3.Let’s add a Formatter Utilities Action: Line-item to Text Transform to add our own delimiter:This gives us a text output with a different delimiter: Now we can run this through the Code Step:And we get the result we wanted where the value with a comma doesn’t get split into multiple elements: Let’s go back and create another Formatter Utilities Action: Line-item to Text Transform to take care of the array with the null value in it. This time, we also add a `-` after the line item input. It could be any single character, and what it does is it adds the text - to each element of the line item/array, even the null elements, so that those aren’t dropped. Here’s the output: Now we can split on our custom delimiter and then remove the last character from each element inside the Code Step. Here’s how we do that: The slice(0,-1) returns the string with the last character removed, so we can get back to our original elements. Here’s our fixed output with the null element in tact:Here’s that final code snippet if you want to copy it and try it out:const { lineItemEasy, lineItemWithComma, lineItemWithNull } = inputData; const lineItemEasyArray = lineItemEasy.split(','); const lineItemWithCommaArray = lineItemWithComma.split('|||'); const lineItemWithNullArray = lineItemWithNull.split('|||'); const lineItemWithNullArrayFixed = lineItemWithNullArray.map((element) => { return element.slice(0,-1); }); output = [{ lineItemEasyArray, lineItemWithCommaArray, lineItemWithNullArrayFixed, }];Once you have your Line item values inside your code step with all elements preserved properly, it will be easier to write code to process them in various ways.Bonus: For a slightly more advanced approach to the above problem but for multiple, related line-item properties, you can also take a look at the answer to the question that inspired this post here:&nbsphope these workarounds help you make more use of the Code by callin.io app!Tim Please NoteThis code is provided as is, without warranty, but we’ll do our best to answer questions you have about it here.Supporting custom code is outside of the scope of callin.io Support, so if you need help with this, or other code you’re working on, the best place to ask is here in the callin.io community and/or on Stack Overflow. You’re still welcome to ask in Support via our contact form just in case it’s something unrelated to the code that isn’t working, but you may be directed to one of these resources to get help from the community.

Page 2 / 2 Prev

How To

Last Post by SamB 1 year ago

17 Posts

14 Users

0 Reactions

10 Views

RSS

NathanielP

(@nathanielp)

Posts: 1

New Member

I'm trying to understand how to use Tables By callin.io (specifically the find record and output as line items feature) along with Code by callin.io. I've seen this and various other community posts, and it's concerning that this remains an issue and a roadblock for users like myself, who are quite familiar with coding and the iPaaS landscape, even after two years. While a "workaround" is available, the necessity of navigating so many complexities to use two supposedly integrated products is making me reconsider callin.io for my solution.

I highly recommend a tighter integration between these two features. Relying on workarounds within core product functionality for something as fundamental as "returning all matching rows from a table as an array of objects for iteration in code" is a basic expectation that should function seamlessly without requiring external searches for solutions.

Posted : 07/08/2024 12:00 am

SamB

(@samb)

Posts: 71

Trusted Member

Hello there! 👋

I sincerely apologize for not catching your messages here earlier.

I've reviewed the feature request, and it remains open. I wish I could offer a timeframe for its implementation, but I've added all your votes to it, which should help boost its priority. We will notify everyone here via email once it's implemented.

I have forwarded your feedback to the Product team for consideration as we enhance the functionality and user experience of the Code by callin.io app in conjunction with our other products, such as Tables.

Thank you all for your valuable insights and continued patience; it is greatly appreciated. 🤗

Posted : 08/08/2024 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