Assistance with Alteryx Server API – Retrieving Workflow User and Interface Tool Data

digeorgiok

Hello,

I am currently using the Alteryx Server API from the Alteryx Marketplace to retrieve details on all workflows. So far, I’ve been able to access the following information:

• Collections

• All workflow IDs within collections

• Workflow names from workflow IDs

• Job IDs from workflow IDs

However, I am still missing two key pieces of information and could use your help:

1. The user who ran each workflow

2. Most importantly: Each workflow contains a Text Box Interface tool where the user inputs a Client ID. This information is critical for billing purposes, as it identifies the client associated with the run.

Could you advise on how to retrieve:

• The user who executed the workflow job?

• The input values from Interface tools, particularly the Client ID from the Text Box Interface?

Any guidance or documentation references would be greatly appreciated.

Gawa

@digeorgiok I guess it's doable only with access to Mongo DB directly, I'm not sure you have permission to do that tho.

If you can, try to get data from AS_Results. It contains:

1) UserName : ID of user who created Jobs(run WF). *Use 'user' collection to get the corresponding username

2) OutputLog:  It contains message of Jobs. You can configure the Message tool to show value of the Text Input tool, and parse it out from 'OutputLog'