Webhook Automate

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.

Customization Guide

- Change Webhook Path: Modify the path parameter in the emitirEtiqueta node to change the endpoint that triggers the workflow.
- Database Queries: Adjust the SQL queries in the dadosProduto and dadosRolo nodes to match your database schema or to retrieve different fields.
- HTTP Request Settings: Update the URL and headers in the PegarConfiguracaoImpressao node to connect to a different API or service.
- Function Node Logic: Modify the JavaScript code in the trataRetorno node to alter how roll IDs are processed or to include additional data transformations.
- Merge Configuration: Change the merge settings in the roloProduto node to use different properties if your data structure changes.