[login to view URL] API Script - repost

We are looking for a freelancer to build a script that will interact with [login to view URL] in the following ways:

1. Get a CSV file from a specified FTP

1a. CSV must include column headers in the attached format, but not in a specific order

1b. FTP must be configurable, and it must support SFTP in addition to FTP

2. Based upon the CSV columns, remove data from those fields for all contacts in [login to view URL]

2a. Do not remove those contacts - just remove the data in these columns

3. Match Supplier Pollenware ID (PollenID in [login to view URL]) and write data for each PollenID to [login to view URL] for these columns in CSV

4. The script must be configurable to run at a specified time, or re-run at any time

The following are the data fields we need populated via the API/CSV feed

- Next Event AP

- Next Event WA DPE

- Is Churned

- Next Event ID

- Next Event Date

- Next Event Time

- Sweet Spot Status (SweetSpot in [login to view URL])

- Signed TC

- First Participated Event Date (First Participated Date in [login to view URL])

- Last Participated Event Date (Last Participated Date in [login to view URL])

I've attached the sample excel file with data for review with the fields highlighted in green that we use.

CRM Salesforce.com Αρχιτεκτονική Λογισμικού

Ταυτότητα Εργασίας: #4417859

Σχετικά με την εργασία