Saved Search – Array output

Hi Gareth,

How does the data look currently?

Thanks,

Chris

Hi Chris,

Not sure if my response got posted. So, the data is appearing in the saved search results as a string “117, 119”. It’s coming from a Multiple select custom field currently.

The output of the saved search is being used in Celigo. One idea I have is to use handlebars to “convert” or change the data structure into a usable array, would this be a good potential solution perhaps? However, more keen to hear of a NetSuite solution first.

Thanks,

Hi Gareth,

I’m not overly familiar with Celigo but I suspect that anything that comes from NetSuite as a comma-separated list is going to be treated as a string irrespective of what you do in NetSuite itself.

As such, I think your gut feel about handling in Celigo is the way to go.

Thanks,

Chris

You can do it in Celigo , depending on the step/method/objective you are using in Celigo  you can either use handlebars or javascript to reformat the input or output.

If you are trying to convert it to a one-to-many structure javascript id most likely the way to go.

Thanks Chris and rosenk35, that’s  quite useful information.

Looking into the JavaScript aspect and support within Celigo now.

Thanks for directing me in the right direction. Much appreciated 🙂

Thanks,