Make one column of data into one quoted, comma separated field

[Archaeopteryx]

Hi,

I'm running an API where I provide UserIDs as quoted, comma separated values. Like this:

{"userIds":["12345-67890-54321-54321","67583-02751-22331-54545","21234-00900-44567-13135","...",",,,",".."]}, and on and on.

The API in question generates a User Status Detail Report, which is a canned report within the Admin Portal that carries its own ID. 

First I run a stored procedure to fetch all the users from the database table. I then "Select" the UserID column all by itself. Now for the tough part - and you guys may be able to show me a better way, but ...

I would like to take that UserID column, and make it into one field whos IDs are quoted and comma separated. I would pass that field into an Alteryx formula that is the payload API for the Download tool. 

Is this possible? Thank you for any assistance.

Chris

[atcodedog05]

yup @Archaeopteryx 😅

[Archaeopteryx]

Wow, Summarize, Concatenate with quotes and all. They thought of everything. Thank you atcodedog05.