Xero and Airtable Integration
- or -
Post a project like this€850(approx. $915)
- Posted:
- Proposals: 10
- Remote
- #2123936
- OPPORTUNITY
- Expired
PPH #1 Service Provider in Development & IT : Wordpress|Magento|React Native|Mobile App Development|Angular|Node.js
Mohali
Customized Mobile apps | Website Design & Development | Digital Marketing |E-commerce Solutions
Ahmedabad
OpenAI | Flutter | FlutterFlow | ChatGPT4 | Wordpress Pro, Prestashop Pro, Django Expert,Shopify
Kharar
128342471735506139759028142265016016092291442234107423465362362046
Description
Experience Level: Expert
A Django web app that contains a Xero Private Application, using a Python wrapper, which is also able to access the Airtable API, which also has a python wrapper.
It needs to be able to:
GET specific data from Xero
GET the equivalent data from Airtable
Cross reference them to identify missing/changed records/fields
POST/PUT any specified differences from Airtable to Xero
Possibly (not confirmed yet) show Xero status in Airtable for specific records
There is data manipulation required between the data retrieved from Airtable before it is POSTed to Xero. For example it needs to be able to:
Read a field value from Airtable (person name) and assign a monetary value (cost price) based on that name
Read a field value from Airtable (2 letter code) and assign a specific account in the Sales Settings of the Contact Financial details
A mapping will be provided for this data.
Depending on which tables are being integrated the integration needs to be either:
Real-time (or close to without exceeding API limits)
Scheduled, eg. every night at 00:00
Triggerable on demand (possibly, not confirmed yet)
The mapping needs to be maintained by the end user not an admin user, so will require some sort of GUI online to manage these mappings and view either logging of API calls, or at least of errors, also with some sort of notification of any errors. Consider using Django as the framework to build a web app to host all of the above.
It needs to be able to:
GET specific data from Xero
GET the equivalent data from Airtable
Cross reference them to identify missing/changed records/fields
POST/PUT any specified differences from Airtable to Xero
Possibly (not confirmed yet) show Xero status in Airtable for specific records
There is data manipulation required between the data retrieved from Airtable before it is POSTed to Xero. For example it needs to be able to:
Read a field value from Airtable (person name) and assign a monetary value (cost price) based on that name
Read a field value from Airtable (2 letter code) and assign a specific account in the Sales Settings of the Contact Financial details
A mapping will be provided for this data.
Depending on which tables are being integrated the integration needs to be either:
Real-time (or close to without exceeding API limits)
Scheduled, eg. every night at 00:00
Triggerable on demand (possibly, not confirmed yet)
The mapping needs to be maintained by the end user not an admin user, so will require some sort of GUI online to manage these mappings and view either logging of API calls, or at least of errors, also with some sort of notification of any errors. Consider using Django as the framework to build a web app to host all of the above.
David N.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
8 May 2024
Spain
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies