Daily import CSV file via API
Budget: €18 – €36 EUR
Project / script should includes checking if customer, address or product already exist.
- There is a CSV file that is put on a FTP location everyday. This file we need to import to a CRM via API.
- Authentication works via OAuth 2.0.
In my opinion this would be the miles stones/phases of the project:
1- Download the file from the FTP location + Create connection with the CRM API
2- Create new CUSTOMER based on the file (so it should check if the customer already exist or not)
3- Create new ADDRESS based on the SAME file (so it should check if the address already exist or not) related to the customer
4- Create new PRODUCT based on the SAME file (so it should check if the product already exist or not each product has a START and END date. So it is possible that 2 products are the same but have different START and END date)
Based on above the same has to be done for adjusted data
- Changes of a CUSTOMER
- Change of a ADDRESS related to the CUSTOMER
- Change of a PRODUCT related to the CUSTOMER/ADDRESS
This is the API information of the CRM: https://www.postman.com/tribecrm/workspace/tribe-crm-api-public/folder/9709290-6cb50140-a871-44e5-a3cf-4db791daf07c?ctx=documentation
I need this little project finished by end of January 2023.
I would like to have a call for this to explain everything, I think this would take minimum of 30 minutes.
- There is a CSV file that is put on a FTP location everyday. This file we need to import to a CRM via API.
- Authentication works via OAuth 2.0.
In my opinion this would be the miles stones/phases of the project:
1- Download the file from the FTP location + Create connection with the CRM API
2- Create new CUSTOMER based on the file (so it should check if the customer already exist or not)
3- Create new ADDRESS based on the SAME file (so it should check if the address already exist or not) related to the customer
4- Create new PRODUCT based on the SAME file (so it should check if the product already exist or not each product has a START and END date. So it is possible that 2 products are the same but have different START and END date)
Based on above the same has to be done for adjusted data
- Changes of a CUSTOMER
- Change of a ADDRESS related to the CUSTOMER
- Change of a PRODUCT related to the CUSTOMER/ADDRESS
This is the API information of the CRM: https://www.postman.com/tribecrm/workspace/tribe-crm-api-public/folder/9709290-6cb50140-a871-44e5-a3cf-4db791daf07c?ctx=documentation
I need this little project finished by end of January 2023.
I would like to have a call for this to explain everything, I think this would take minimum of 30 minutes.