Please only apply if you can complete the following by 12 noon central US time on June 30th. Job will be awarded by noon central time Saturday, June 26th.
The following work needs to be completed using the .net web services API that [url removed, login to view] provides. When applying please note if you've had any previous experience working with the [url removed, login to view] api web services. All coding must be done using [url removed, login to view] vb, please no c#. The local database referenced below will be Microsoft SQL server.
The overall goal of this project is three phased.
1. To retrieve current products from [url removed, login to view] and update existing ms sql server database table.
2. Upload new contact and account records based on a value of existing contacts and accounts that reside in a ms sql database.
3. Upload new event records and associate them with the correct contact.
To achieve the first item a page needs to be created that when accessed will sync all products that currently exist in salesforce down to a load db table.
The second part is to upload all contact records that have been marked to be updated or created as new records in salesforce. When a specific page is accessed then all records that are marked to be uploaded will be uploaded to salesforce.com. Each record will also contain a company name. That company name will need to be created as a contact if the company currently doesn't exist. If the company does exist we just need to grab the account id. Once a contact and account has been added we then need to retrieve the newly generated [url removed, login to view] contact id and account id for the new records The newly generated contact id and account id will need to updated to the table where the information was pulled from.
The last phase is to create an event activity record for each record in a db table that's been marked to have a event created. Each event activity record will be associated with a product which will be noted in the record for that event. Once the event is created and assigned to that contact we then need to update the record with the newly generated id form salesfroce.