Daily import CSV file via API

Job ID: 35577775

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.
Related categories: PHP JavaScript Python Software Architecture API