Getting text log for workflow executions

Kshitij_Bharde · November 21, 2019, 5:54am

Is it possible to get a log of workflow executions?

jan · November 21, 2019, 6:03am

If you have in the workflow-settings defined that the execution should be saved:

You can see all of them when you select in the menu on the left side of the screen on “Executions”.

Kshitij_Bharde · November 21, 2019, 6:22am

Yeah, I got that. My question was to get those execution log in a text format(maybe in a .txt file).
For each workflow execution a text log containing status of every node(In a text format).

jan · November 21, 2019, 6:31am

No, nothing like that exists. What you can do is to simply use the REST-API the Editor-UI uses. You can find the code of it here:

Get all executions:

github.com

n8n-io/n8n/blob/master/packages/cli/src/Server.ts#L840

      
        
            						throw new ResponseHelper.ResponseError(
            							`The URL does not point to valid JSON file!`,
            							undefined,
            							400,
            						);
            					}
            
            
					// Do a very basic check if it is really a n8n-workflow-json
            					if (
            						workflowData === undefined ||
            						workflowData.nodes === undefined ||
            						!Array.isArray(workflowData.nodes) ||
            						workflowData.connections === undefined ||
            						typeof workflowData.connections !== 'object' ||
            						Array.isArray(workflowData.connections)
            					) {
            						throw new ResponseHelper.ResponseError(
            							`The data in the file does not seem to be a n8n workflow JSON file!`,
            							undefined,
            							400,
            						);

Get the full data of a specific execution:

github.com

n8n-io/n8n/blob/master/packages/cli/src/Server.ts#L905

      
        
            								id: In(shared.map(({ workflow }) => workflow.id)),
            								...filter,
            							},
            						}),
            					);
            				}
            
            
				return workflows.map((workflow) => {
            					const { id, ...rest } = workflow;
            
            
					return {
            						id: id.toString(),
            						...rest,
            					};
            				});
            			}),
            		);
            
            
		this.app.get(
            			`/${this.restEndpoint}/workflows/new`,
            			ResponseHelper.send(async (req: WorkflowRequest.NewName) => {

Kshitij_Bharde · November 21, 2019, 6:36am

Thanks Jan, I will check it out.

Kshitij_Bharde · November 21, 2019, 10:55am

Hi Jan, this is exactly what i was looking for, but this api is returning only last 20 executions, how can i get all the executions or set the amount of data i am getting?

jan · November 21, 2019, 11:05am

Great to hear that it is exactly what you were looking for!

You should actually find that information in the code I posted above. There is the “limit” query parameter that you can simply set to whatever you want.

minstrel · August 20, 2020, 2:41pm

If I dared …

Could it be possible to obtain the complete WF log with all nodes details, specially errors ?
For example here for a MySQL node in the WF :

Error: Duplicate entry 'The opposite of etc ...

Convenient for log parsing post-treatment

jan · August 21, 2020, 5:54am

No, something like that is currently sadly not possible. But you can do two things:

Post it as a feature-request in the forum. Depending on how many people are interested we would then implement it.
Program it yourself and create a PR. We would then merge it after it has been checked.

prononext · December 23, 2022, 12:06am

MutedJam · December 30, 2022, 12:06am

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.