Ryze Automation Logger icon

Ryze Automation Logger

Log Ryze workflow execution metrics to MySQL database

Ryze Automation Logger

AI-generated

Summary

Logs Ryze workflow execution metrics to MySQL database

Inputs

  • Main (required) — Single item with JSON payload containing 'execution' field; monthly mode triggered when 'execution.mode' is 'monthly', otherwise regular mode processes input

Output shape

Main

Always returns an array with one result item: [{ json: { success, logged_at, script_id, log_data }, pairedItem: 0 }] on success, or [{ json: { success, error }, pairedItem: 0 }] on failure when failOnError is false

Examples

Example 1: Regular execution mode with failOnError disabled

database='backoffice', table='n8n_scraper_logs', executionMode='auto' (auto-detect from input), options={ failOnError: false, verboseLogging: false }, input payload with execution.script_id, summary, details fields present; output: [{ json: { success: true, logged_at: '2024-01-15T10:30:00Z', script_id: 123, log_data: { script_id: 123, execution_id: 'exec-1', execution_mode: 'regular', execution_type: 'scheduled', workflow_name: 'MyWorkflow', status: 'success', items_processed: 150, pixel_new: 145, pixel_duplicates: 3, pixel_updated: 2, event_summary: '{}', full_details: '[]' } }, pairedItem: 0 }]

Example 2: Monthly execution mode with verbose logging and failOnError enabled

database='backoffice', table='logs', executionMode='monthly', options={ failOnError: true, verboseLogging: true }, input payload with execution.mode='monthly', execution.upload_type, execution.year_month, execution.script_id, summary, uploads array; output on success: [{ json: { success: true, logged_at: '2024-01-15T10:30:00Z', script_id: 456, execution_mode: 'monthly', upload_type: 's3', year_month: '2024-01', brands_processed: 5, total_rows_input: 10000, files_created: 20, log_data: { ... } }, pairedItem: 0 }]; on error with failOnError=true: throws NodeOperationError('Failed to log monthly execution: ...')

Links

Discussion