**InterWorks** is **leading software development outsourcing company** in the Eastern Europe region. In the past years, InterWorks has made the first crucial progressive step and introduced its leading software solutions in the USA and European markets. As an offshore department of one of the Largest technical consulting company in Central US, with its own projects, our company is already directly present in the biggest world software market.

58c3184e-f383-4f08-8d54-4b0c6635b3b0.png

6fa401fa-cfe4-4d82-a222-1ad35f9b188a.png

82504ef4-e96b-4887-b24f-1f798c6477d0.zip

This solution is helping for quick Salesforce case creation by reading predefined data from CSV files and by using “Add Case” activity. 

  

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

  

**How to use:**

1.  Watch this [video](https://www.youtube.com/watch?v=FRIfbgbVzfs) in order to establish the connection between UiPath and Salesforce Lighting Platform.
2.  Update the CSV files with appropriate data (CSV files by default are stored in “CSV\_CaseCreation\_Data” folder).
3.  Open Flowchart.xaml in UiPath Studio.
4.  Click on Run File.
5.  It will ask you to provide the required input data such: 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** - case 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 “CSV\_AccountCreation\_Data/ CSV\_ContactCreation\_Data” 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.

Helps for quick Salesforce case creation by reading case data from CSV file

MIT License Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the 'Software'), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED 'AS IS', WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

Version	Release Date	Download Link
1.0	May 13, 2020
Initial Version for Case Creation in Salesforce Lightning Platform by using CSV file

Add Case in Salesforce from CSV file