Closed

Salesforce.com API Script

This project received 5 bids from talented freelancers with an average bid price of $364 USD.

Get free quotes for a project like this
Employer working
Project Budget
N/A
Total Bids
5
Project Description

We are looking for a freelancer to build a script that will interact with [url removed, login to view] 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 [url removed, login to view]
2a. Do not remove those contacts - just remove the data in these columns
3. Match Supplier Pollenware ID (PollenID in [url removed, login to view]) and write data for each PollenID to [url removed, login to view] 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 [url removed, login to view])
- Signed TC
- First Participated Event Date (First Participated Date in [url removed, login to view])
- Last Participated Event Date (Last Participated Date in [url removed, login to view])

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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online