Stackby Database Automation

This n8n workflow automates Stackby database operations, managing records via the Stackby API. Key nodes include Webhook Trigger (receives POST requests), Extract Request Metadata (captures client data), Stackby Rate Limit Check, Validate and Sanitize Input, Append/Read/List/Delete Stackby Table (API interactions), and Success/Error Response nodes (handle outputs). Set up Requirements and Configuration: Install n8n by downloading from n8n.io for self-hosting or sign up at cloud.n8n.io for cloud setup. Follow installation prompts or create a cloud account. Obtain Stackby API credentials from app.stackby.com: log in, go to 'Account Settings' > 'API,' generate an API Key, and note it. In n8n, import the provided JSON to create the workflow. Configure Stackby nodes (Append/Read/List/Delete) with your API Key under 'Credentials,' selecting 'Stackby API.' Set the Webhook Trigger node’s path to 'stackby/operations,' enable header authentication with a secure key, and ensure it accepts POST requests. The Validate and Sanitize Input node checks operation, stackId, tableName, and recordId. Testing and Deployment Steps: Test by sending a POST request to the Webhook URL (from the Webhook Trigger node) using Postman. Example JSON body: {'operation': 'append', 'stackId': 'stk_123', 'tableName': 'Tasks', 'data': {'name': 'Task 1'}} or {'operation': 'read', 'stackId': 'stk_123', 'tableName': 'Tasks', 'recordId': 'rec_456'} with the authentication header. The 'Stackby Success Response' node returns a 200 status with operation results, or 'Validation Error Response' (400 status) for invalid inputs like missing stackId or tableName. The 'Rate Limit Response' (429 status) triggers if exceeding 30 requests per minute. The 'Stackby API Error Response' (500 status) indicates API failures, such as invalid credentials or non-existent records. Activate the workflow in n8n’s interface for deployment. Monitor logs for errors like invalid API keys or incorrect record IDs, and verify credentials or input formats if issues occur.