**Make.com Expert needed to fix XML to MySQL/Dropbox Automation (UBL 2.1 Colombia)**

Заказчик: AI | Опубликовано: 16.02.2026
Бюджет: 250 $

I need a Make.com (Integromat) expert to finalize a partially completed automation. The flow is triggered by Zoho Mail, unzips an invoice file, parses a UBL 2.1 XML (DIAN Colombia standard), inserts data into a MySQL database, and saves the PDF in Dropbox. The current Make Blue print is attached to this project, and the full detail is in notion. **Current issues to fix (Day 1 work):** 1. **Relational Database Logic:** Ensure the `insertId` from the main invoice table is correctly mapped as a foreign key to the product detail table. 2. **Data Persistence between Router Branches:** Use a Data Store to pass variables (Supplier Name, Invoice Number) from the XML branch to the PDF branch to rename files correctly in dropbox. 3. **Optimization:** Remove inefficient "Repeater/Aggregator" logic to reduce operation consumption per invoice. 4. **XML Fallback:** Implement fallback logic to extract Purchase Order numbers from the `<cbc:Note>` tag when the standard `OrderReference` is empty (Specific case for supplier MPS). **Requirements:** - Proven experience with Make.com and MySQL. - Understanding of XML/XPath (specifically UBL 2.1). - Ability to work with existing blueprints and optimize them. Full detail in notion url : https://www.notion.so/lasus/Automatizar-facturas-de-compra-249ebe43945d80d09f05e4ffd8c5add6?source=copy_link