Adding Inverted Commas to Values Before API Call

Need help
1

Hi everyone - some help with the following would be much appreciated. It may be a simple action but it’s taken me hours to figure out.

I have a list of stored numbered values in my database (sourced from an API call).
My List

To successfully run an API call for multiple items on this list, I need to add inverted commas around each of the numbered items.

In other words, the list: 1, 2, 3, 4, 5, 6 needs to be ‘1’, ‘2’, ‘3’, ‘4’, ‘5’, ‘6’ when queried

How can I add commas around each of the items when making the API Call?

It’s important that the commas are not always present, as several functions of the application recognize only the number itself and would be unrecognizable if there were inverted commas around the numbers.

Here is the API Call:

Adding Inverted Commas
Adding Inverted Commas1534×556 140 KB

Thank you very much in advance for any advice!!

2

Get your list of numbers, :format as text.

The top box of that format should be 'This text' including the speech mark commas as that’s what you want to add.

The delimitter is what separates these numbers. In this case the delimiter should be , (a comma followed by a space although pretty sure the space isn’t strictly necessary).

Note this assumes your ‘list of numbers’ actually is a list of numbers rather than a text type.

3

Worked perfectly. Thank you!

4

This topic was automatically closed after 70 days. New replies are no longer allowed.