Pass ID from a database query to api as an array

[milo]

I have several id’s coming back from a database query in server connect. I need to pass the id’s to an api as an array. I can do a repeat, but it is not very efficient. I’ve been trying set value and all sorts of things, and searching the community with no luck. Any direction would be helpful and appreciated.

[JBM]

Hi Milo,
Im hitting the same problems in getting feedback on array creation from queries…did you manage to sort out you problem?

[Teodor]

You can use the Flatten formatter to get an array with the values of a specific column of a database query:

Select the value in the property option:

And you have your array: