No of Records processed in Alteryx Workflow

Hi Team, I'm looking for a solution to fetch the no of records [source/target] processed by Alteryx workflow for historical date or a month back data, hence I would need to understand if Alteryx stores he no of records [source/target] processed in job somewhere in metadata ?

Common Use Cases

Accepted answers

TimN

Hi,

Yes, similar data is stored in Mongo and can be accessed using alteryx apis or query against MongoDb. Api use would require Curator access and Mongo would require logon details from your admin.

I'm on 2021.4 - this api - GET /admin/v1/workflows/jobs/ can return the log data.

All comments

TimN

Hi,

Every Alteryx execution generates a log file. The log file will contain details on inputs and outputs including the number of records. If you are talking about workflows on the server, you can look at logs there as well or what information is kept in the MongoDb (similar to log file data).

Naren86

Thank you @TimN for the reply , I can get those data on log file, however is the similar log file data is stored anywhere in the Mongo DB ?

TimN

Hi,

Yes, similar data is stored in Mongo and can be accessed using alteryx apis or query against MongoDb. Api use would require Curator access and Mongo would require logon details from your admin.

I'm on 2021.4 - this api - GET /admin/v1/workflows/jobs/ can return the log data.

Naren86

Thank you @TimN for your help, I was able to get what I wanted via API v1 😀 however, do you know which table in mongo DB has this information , just to have this information handy.

TimN

Hi,

The version you are on may have changes to Mongodb schemas but try here.

https://help.alteryx.com/current/en/server/configure/mongodb-management/mongodb-schema-reference.html#idm45521461174144

Tim

TimN

It's in the "As_Results". The release I'm on 2021.4 stores the log in a blob.

https://community.alteryx.com/t5/Alteryx-Server-Discussions/Message-Tool-In-Server-Pull-for-Usage-Report/td-p/1175951

Naren86

Thank you @TimN 😀

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703