Access Ifthenpay Payment Integration
Budget: €250 – €750 EUR
Our invoicing system is built in Microsoft Access and organised as a classic relational database (customers ↔ invoices ↔ payments). I now need a compact piece of code that talks to the Ifthenpay API so that, whenever we create an invoice, the application automatically requests a Multibanco entity/reference pair and writes it straight into the appropriate table.
Essential flow
• The routine receives InvoiceID and Amount from Access.
• It sends the request to Ifthenpay, handles any required authentication, and retrieves entity, reference and validity data.
• The response is stored in our Payments table and linked back to the originating invoice record for future use.
I only need the “generate reference” step; tracking or auto-updating settlements will be added later, so please keep your code modular enough to extend.
Deliverables
1. A well-commented VBA (or compatible) module ready to import into our ACCDB.
2. Any helper libraries, connection strings or JSON helpers required.
3. A short setup guide showing where to paste credentials and how to test with both sandbox and live endpoints.
4. Proof of concept: a sample call that creates a reference and shows the new record inside the database.
Acceptance criteria
– Successful API call returns valid Multibanco reference for at least three test invoices.
– Data persists correctly and survives application restarts.
– All external dependencies documented.
If you have already integrated Access with REST APIs (especially payment gateways), this will be quick work. Let me know your approach and timeframe—once I can run your demo inside a copy of our database, we’re good to go.
Essential flow
• The routine receives InvoiceID and Amount from Access.
• It sends the request to Ifthenpay, handles any required authentication, and retrieves entity, reference and validity data.
• The response is stored in our Payments table and linked back to the originating invoice record for future use.
I only need the “generate reference” step; tracking or auto-updating settlements will be added later, so please keep your code modular enough to extend.
Deliverables
1. A well-commented VBA (or compatible) module ready to import into our ACCDB.
2. Any helper libraries, connection strings or JSON helpers required.
3. A short setup guide showing where to paste credentials and how to test with both sandbox and live endpoints.
4. Proof of concept: a sample call that creates a reference and shows the new record inside the database.
Acceptance criteria
– Successful API call returns valid Multibanco reference for at least three test invoices.
– Data persists correctly and survives application restarts.
– All external dependencies documented.
If you have already integrated Access with REST APIs (especially payment gateways), this will be quick work. Let me know your approach and timeframe—once I can run your demo inside a copy of our database, we’re good to go.