Webhook Database Automation

Target Audience

• Developers: Those looking to automate data retrieval and processing from MySQL and PostgreSQL databases through webhooks.
• Data Analysts: Professionals needing to integrate various data sources and generate reports efficiently.
• Business Owners: Individuals seeking to streamline their operations and improve the accuracy of their inventory management.
• API Integrators: Users who want to connect different systems via webhooks for seamless data flow.

Problem Solved

This workflow addresses the challenges of manually retrieving and processing product and roll data from multiple databases. It automates the entire process, allowing users to:

• Quickly access product details and composition based on specific criteria.
• Efficiently manage inventory by integrating data from multiple sources.
• Reduce human error in data entry and retrieval processes.

Workflow Steps

1. Webhook Trigger: The workflow starts when a POST request is received at the emitirEtiqueta endpoint, containing product grade information.
2. Retrieve Configuration: An HTTP request fetches configuration settings from a specified API endpoint to ensure the workflow uses the correct database settings.
3. Query Product Data: A MySQL query retrieves product details, including product ID, description, brand name, and composition based on the product grade ID received from the webhook.
4. Process Roll Data: A function node extracts roll object IDs from the webhook payload and prepares them for database querying.
5. Fetch Roll Information: A PostgreSQL query retrieves detailed information about the rolls based on the IDs extracted in the previous step.
6. Merge Data: The results from the product and roll queries are merged by matching the id_movimentacao_detalhe, creating a comprehensive dataset for further processing or reporting.