Scripting

Starfish Scripting Resources

• Starfish Scripting Class
• Execute When

Global Scripts

To create a Global script, click on the VBScript Global or .NET GLobal button in the Mapping ribbon:

C#

Field Scripting Examples

• Convert Time Zone

VBScript

VBScript Resources

• http://www.w3schools.com/asp/vbscript_ref_functions.asp
• VBScript Constants, like vbCrLf, etc: http://powerasp.net/content/new/vbscript-constants.asp

Sample Global VB Script Functions

• Format Phone Number
• Clean String Functions - Remove Unwanted Characters

Field Scripting Examples

• Convert state abbreviations to full name with VBScript
• Look in many xref lists for an origin ID
• Parse text and look up ID based on result
• Write Null instead of Blank

Job Scripting Examples

• Check for duplicates using xref
• Interact with the local file system
• Pull data from a source and write to file
• Retrieve Records Modified After Last Run DateTime
• Use Before Save and After Save operations to loop through a single origin record multiple times
• Use the same job to loop through multiple origins
• Using Row Hashing for Incremental Integrations

JSON

• Validate and parse JSON: http://jsonlint.com/