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
