Connect HomeMarketplaceComponentsAdd Contacts in Salesforce from Multiple CSV Files

Add Contacts in Salesforce from Multiple CSV Files

Solution

Solution

Updated: October 27th, 2020

Published: April 13th, 2020

Downloads: 6

Process: Sales

Language compatibility: Visual Basic

Tags: salesforce

Community Support

Add Contacts in Salesforce from Multiple CSV Files

Solution

Summary: 

Helps for quick Salesforce contacts creation by reading contacts data from multiple CSV files

This solution is helpful for quick Salesforce contacts creation by reading predefined data from multiple CSV files and by using the “Add Contact” activity.
Also, if some of the fields like AccountId and ReportsToId are not populated in the CSV files, this solution is offering the option either to choose to continue anyway (because they are not required fields), to provide CSV file for creating new account/contact, or to choose from the list of existing accounts/contacts from Salesforce.
After contacts are successfully created, they will be validated by using “Check ID” activity.

How to use:
  1. Watch this video in order to establish the connection between UiPath and Salesforce Lightning Platform.
  2. Update the CSV files with appropriate data (CSV files by default are stored in “CsvContactData”, “CsvContact” and “CsvAccount” folders).
  3. Open Main.xaml in UiPath Studio.
  4. Click on Run File.
  5. It will ask you to provide the needed input data such as: Salesforce username, Salesforce password, Security Token, Consumer Key, Security Key and location of the CSV file (in case it was changed from the default location).
  6. If account or/and contact ID are not populated, choose how to proceed:
- Continue Anyway - contact will be created without account/contact ID, since they are not required fields.
- Create new account/contact – update CSV file with appropriate data (CSV files by default are stored in “CsvAccount/CsvContact” folder).
- Choose from existing accounts/contacts – providing list from existing accounts/contacts in Salesforce by using Get Account List/Get Contact List activities, giving the option to choose one of them.

Details

Benefits

Quick contacts creation in Salesforce Lightning Platform and data validation for the created contacts.

Compatibility

Tested in Studio version 2019.12.0.

Dependencies

UiPathTeam.Salesforce.Lightning_Platform.Activities

Resources

- CreateContacts Salesforce.pdf

Licensing

By clicking download you agree to the following license.