
Fermé
Publié
Payé lors de la livraison
I need a [login to view URL] (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 [login to view URL] and MySQL. - Understanding of XML/XPath (specifically UBL 2.1). - Ability to work with existing blueprints and optimize them. Full detail in notion url : [login to view URL]
N° de projet : 40234885
94 propositions
Projet à distance
Actif à il y a 22 jours
Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
94 freelances proposent en moyenne $136 USD pour ce travail

Hello, I'll be glad to assist you with this project. I can work with you during the next hours to have this done. I will complete this project with 100% accuracy. Click on the "CHAT" button so we will discuss it in detail. I'm always online and available. Please feel free to contact me at any time. I am available 24/7 for support. Best Regards Sandeep
$150 USD en 1 jour
6,9
6,9

Hello Dear! I write to introduce myself. I'm Engineer Toriqul Islam. I was born and grew up in Bangladesh. I speak and write in English like native people. I am a B.S.C. Engineer of Computer Science & Engineering. I completed my graduation from Rajshahi University of Engineering & Technology ( RUET). I love to work on Web Design & Development project. Web Design & development: I am a full-stack web developer with more than 10 years of experience. My design Approach is Always Modern and simple, which attracts people towards it. I have built websites for a wide variety of industries. I have worked with a lot of companies and built astonishing websites. All Clients have good reviews about me. Client Satisfaction is my first Priority. Technologies We Use: Custom Websites Development Using ======>Full Stack Development. 1. HTML5 2. CSS3 3. Bootstrap4 4. jQuery 5. JavaScript 6. Angular JS 7. React JS 8. Node JS 9. WordPress 10. PHP 11. Ruby on Rails 12. MYSQL 13. Laravel 14. .Net 15. CodeIgniter 16. React Native 17. SQL / MySQL 18. Mobile app development 19. Python 20. MongoDB What you'll get? • Fully Responsive Website on All Devices • Reusable Components • Quick response • Clean, tested and documented code • Completely met deadlines and requirements • Clear communication You are cordially welcome to discuss your project. Thank You! Best Regards, Toriqul Islam
$100 USD en 4 jours
6,1
6,1

I can step into your existing Make blueprint and fix the four blockers you outlined without rebuilding the flow. I’ll correct the foreign-key mapping so the invoice insertId reliably links product rows in MySQL. To fix cross-branch data loss, I’ll implement a Data Store to pass Supplier Name and Invoice Number to the PDF branch for proper Dropbox renaming. I’ll refactor the repeater/aggregator pattern to cut operation usage per invoice while keeping the same outputs. For the UBL 2.1 edge case, I’ll add XPath fallback to pull the PO from <cbc:Note> when OrderReference is empty for MPS invoices. I’ve worked with Make + MySQL and UBL XML parsing and can validate the fixes against a few real invoices on day one. If you grant access to the scenario and a sample XML/PDF pair, I can apply and test these changes immediately.
$200 USD en 3 jours
5,6
5,6

Hello, Hope you're doing great! I am a PHP Developer who builds secure, fast, and business-focused web applications. I work with both custom PHP and frameworks, and always ensure that every project is optimized, scalable, and easy to maintain. What I Do 1. Custom web applications & business automation tools 2. API development and integration 3. Secure login, admin panels, and dashboard systems 4. High-speed, mobile-friendly websites 5. Migration, bug fixing, and performance upgrades Why Clients Prefer My Work 1. Clean folder structure & scalable architecture 2. Fully optimized and secure coding practices 3. Excellent communication & professional approac 4. Quick turnaround time with regular updates Ready to Start Share your requirements or preferred reference — I’ll analyze it and provide: 1. Best technical plan 2. Exact timeline 3. Budget estimate Looking forward to building something amazing for you!
$100 USD en 7 jours
5,6
5,6

Your scenario already works the problem is data integrity and operation cost, not connectivity. The insertId mapping, router isolation, and repeater usage are classic Make blueprint design issues that eventually break accounting data. I’d fix it by restructuring the flow rather than patching modules: capture the invoice insertId in a controlled path, store shared values in a Data Store for cross-branch access, replace repeater/aggregator patterns with iterator-safe mapping, and add XPath fallback to <cbc:Note> for the MPS supplier case. The result is fewer operations and consistent FK relationships in MySQL. I’ve handled Make automations parsing structured documents into relational databases where reliability mattered more than just “getting data in”. Quick checks: Is each email guaranteed to contain a single invoice zip? Do you need idempotency protection to avoid duplicate inserts if the scenario reruns? I can review the blueprint and stabilize it immediately. Imran
$140 USD en 7 jours
4,0
4,0

Hi DavidLasus, hope all is good. I understand your goals and will deliver clear work on time while keeping you updated. I am a skilled freelancer with 5+ years of experience in PHP, MySQL, Automation and I have completed similar projects. Visit my profile to check my latest work and read short client reviews. I would love to connect in chat to discuss details. Looking forward, Vasyl
$140 USD en 7 jours
3,1
3,1

Your Make scenario already does the heavy lifting — I can step in and stabilize the relational logic, fix the Router data persistence, and optimize the XML → MySQL → Dropbox pipeline in one clean pass. I’ve worked extensively with Make (Integromat), UBL 2.1 invoice parsing, and relational database design, so this is very aligned with my daily work. For the insertId issue, I’ll restructure the transaction flow so the main invoice insert executes atomically and its generated ID is deterministically mapped as a foreign key to product rows (avoiding race conditions or mis-scoped variables). If needed, I’ll wrap MySQL modules in a controlled sequence to guarantee referential integrity. For cross-branch persistence, I’ll implement a Make Data Store or use scoped variables with a stable key (Invoice UUID) to pass Supplier Name and Invoice Number to the PDF branch reliably. This eliminates fragile mapping dependencies between Router paths. Regarding optimization, I’ll refactor the Repeater/Aggregator pattern to reduce operations per invoice—likely shifting to iterator-based structured parsing with direct array mapping. This will significantly lower operation consumption and improve maintainability. For the XML fallback, I’ll implement conditional XPath logic to extract PO data from <cbc:Note> when OrderReference is empty (handling the MPS edge case cleanly). I can review your blueprint and Notion spec immediately and deliver a clean, production-ready scenario within Day 1.
$140 USD en 7 jours
3,8
3,8

Hello DavidLasus, I can assist right away. I understand the main goals and will ensure the final result that matches your expectations. I have 8+ years of experience in PHP, MySQL, Automation, Software Architecture, XML. I have completed similar projects. Visit my profile to check my latest work and read what clients say. If this sounds good, connect in chat and we can start. Thanks, Dax Manning
$30 USD en 7 jours
2,0
2,0

Hello, I’m Dinesh Kumar With 14+ years of experience across multiple platforms, I’ve helped build numerous startups through dedication and hard work. I’m committed to delivering high quality work that ensures 100% client satisfaction. Your success is my priority, and I focus on building long term relationships based on trust and excellence. Expertise: Web & App Development – React.js, Node.js, JavaScript, PHP, MySQL, WordPress, Magento, CodeIgniter, Shopify, .NET, Flutter, FoxPro Strong knowledge of frameworks, software design, and development methodologies Proven ability to deliver custom, scalable, and reliable solutions for diverse industries I work with clients globally, providing end to end solutions that meet unique project needs while maintaining the highest quality standards.
$140 USD en 7 jours
1,6
1,6

I specialize in workflow automation and AI-driven solutions using leading tools to streamline operations and eliminate manual tasks. ✅ GoHighLevel: CRM automation, pipelines, AI agents, and funnel workflows ✅ n8n & Make (Integromat): Build complex, scalable automations connecting apps and APIs. ✅ Zapier & Power Automate: Rapid workflow deployment for business processes. ✅ AI Integration: Connect OpenAI/Claude for intelligent content generation and decision-making. ✅ End-to-End Automation: From lead capture to reporting—fully hands-free. ✅ Playwright & Selenium: Headless browser automation for data extraction and process Let's automate your workflows for efficiency and growth. Best, Usman Kokab Workflow & AI Automation Specialist
$140 USD en 7 jours
0,6
0,6

ऐडिटिंग काम किया है और वैब साइट्स डिजाइनर एडिटिंग किया गया इस एकअवसर तों दो न प्लीज मुझे भी कुछ काम काम किया है एडिटिंग और रिपोर्टिंग में खड़ा हुआ और उसने मुझे एडिटिंग फोटोशॉप डिजाइनर फाल्गुनी वैब साइट्स डिजाइनर एडिटिंग बनाना हु
$140 USD en 7 jours
0,0
0,0

Medellín, Colombia
Méthode de paiement vérifiée
Membre depuis janv. 30, 2020
$250-750 USD
$30-250 USD
$250-750 USD
$8-15 USD / heure
$30-250 USD
$20-30 SGD / heure
$30-250 USD
₹1500-12500 INR
$2-8 CAD / heure
₹100-400 INR / heure
₹12500-37500 INR
₹600-3000 INR
₹1500-12500 INR
₹1500-12500 INR
₹37500-75000 INR
$30-250 USD
₹1500-12500 INR
£10-15 GBP / heure
$10-30 USD
$2-8 USD / heure
$250-750 USD
$2-8 USD / heure
$15-25 USD / heure
$750-1500 USD
minimum $50 USD / heure