Moves a large set of Incidents from ServiceNow to Salesforce. Trigger with an HTTP call either manually or programmatically. Incidents are upserted so that the migration can be run multiple times without creating duplicate records. This example uses batch to efficiently process many records at a time. You can find this template at: https://github.com/Luay-Abdulraheem/mule-snow-sfdc-migration
As a ServiceNow admin I want to migrate incidents to Salesforce
This example should serve as a foundation for the process of migrating Incidents from a ServiceNow instance to Salesforce.
As implemented, this example leverages the Batch Module. Firstly will query the ServiceNow for all the existing Incidents that match the filtering criteria sent as a request parameter. The criteria is based on ServiceNow Incidents caller Id. The last step of the Process stage will group the Incidents and create them in Salesforce. Finally, during the On Complete stage, the results of the batch execution will be presented with some initiate statistics data and an SMS with the summary report will be sent.
Important note about migrated Cases in SalesForce: For now, the migrated Cases Subject field will be set as 'SFDC_MIGRATION_' + ServiceNow Incident Number. This will be used to check if the incident has been migrated to Salesforce or not. Make sure that the migrated case Subject field does not change after migration, or the incident will be migrated again.
In order to have this example working as expected, you should be aware of your own Salesforce field configuration.
In order to have this example working as expected, you should be aware of your own ServiceNow field configuration.
In order to have this example working as expected, you should be aware of your own Twilio field configuration.
Complete all properties in: mule-artifact.properties.
After this, to trigger the use case you just need to hit the local http connector with the port you configured in the properties file, then you should hit: http://localhost:8081/migrate?callerId=ServiceNow_Incidents_CallerId and this will output initiate statistic data and send an SMS with a summary report.
In order to use this Mule example you need to configure properties either in properties file or in CloudHub as Environment Variables. Detail list with examples:
- snow.user
snow_user1 - snow.password
ExamplePassword881 - snow.endpoint
https://instance.service-now.com
- sfdc.username
user@company.com - sfdc.password
secret - sfdc.securityToken
1234fdkfdkso20kw2sd - sfdc.url
https://login.salesforce.com/services/Soap/u/46.0
- twilio.accountSid
account SID - twilio.authToken
Auth Token - twilio.host
api.twilio.com - twilio.port
443 - twilio.basePath
/2010-04-01 - twilio.protocol
HTTPS
- Application plugins:
- File Common Plugin : 1.2.0
- ObjectStore : 1.1.3
- ServiceNow : 6.4.0
- Sockets : 1.1.5
- File : 1.2.0
- HTTP : 1.5.11
- Salesforce : 9.7.10
- Twilio Connector : 3.0.2