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
Solved! Go to Solution.
yup @Archaeopteryx 😅
Wow, Summarize, Concatenate with quotes and all. They thought of everything. Thank you atcodedog05.