Join Product Data from MySQL Databases for Label Printing

The workflow starts with a webhook trigger named 'emitirEtiqueta' that accepts POST requests containing an 'id_produto_grade'. It then executes a complex MySQL query in the 'dadosProduto' node using CTEs to fetch data: 'pg' for product grade details, 'p' for active product info, 't' for tissue width extracted from JSON in a dynamic reporting database, and 'cp' for aggregated composition using JSON_TABLE to parse array data.

This unifies disparate data sources—product tables and dynamic 'i_objeto' tables from a configurable reporting DB—into a single structured output, ideal for generating printable labels with all necessary specs like code, dimensions, fabric width, and material composition.

Benefits include time-saving automation of cross-database joins, reducing manual SQL scripting and errors. Use cases: manufacturing label printing, inventory management, e-commerce product tagging, or any scenario needing consolidated product data from siloed MySQL instances. Highly valuable for operations handling graded products like textiles or apparel.