Saved Search – Array output

Hi,

I’m wanting to output integer numbers as an array from a saved search results. Is this possible to do, so it’s simply the array without quotes around it (making it a string)?

 

Thank you,

Rookie Asked on December 6, 2020 in How To's.
Add Comment
5 Answer(s)

Hi Gareth,

How does the data look currently?

Thanks,

Chris

Intermediate Answered on December 7, 2020.
Add Comment

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,

Rookie Answered on December 7, 2020.
Add Comment

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

Intermediate Answered on December 8, 2020.
Add Comment

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.

Rookie Answered on December 8, 2020.
Add Comment

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,

Rookie Answered on December 8, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor