Pulling the user's ID who runs a workflow in the server

Question

Hi, so I am building a workflow that we are looking to upload to our company's alteryx server. Part of the process is knowing who is using the data at the end of the process, so the goal is to pull the user's ID who runs the workflow (we don't want them to manually type it in, since you can type anything in). Is there a way to pull this as a part of the workflow? Thank you!

fmvizcaino · Answer

Hi @adam_rafael_18 ,

The inputs are inside the Alteryx Server System Settings.

Server: localhost:27018

Username: user

Database: AlteryxGallery

Collection: users

https://help.alteryx.com/20221/server/alteryxgallery-mongodb-schema

Best,

Fernando Vizcaino

adam_rafael_18 · Answer

Hi Fernando,

Thanks for the reply. I was looking at that earlier and was still a little confused. I'm relatively new to API scraping so I felt I was missing a couple of steps there.

Big picture first  - using the MongoDB Input tool to pull the data? So based on that, the inputs needed would be:

Server:

Database:

Collection:

Is that correct and if so, what links would I use to connect it to the gallery?

Thanks again!

fmvizcaino · Answer

Hey @adam_rafael_18 ,

Look at this post and see if this helps you out.

https://community.alteryx.com/t5/Alteryx-Server-Discussions/Accessing-the-logged-in-User-name-in-a-workflow-on-server/td-p/616688

Best,

Fernando Vizcaino