Scripting: Difference between revisions
Jump to navigation
Jump to search
Jkuehlthau (talk | contribs) |
Jkuehlthau (talk | contribs) (→C#) |
||
Line 11: | Line 11: | ||
*[[Upload a file to FTP]] | *[[Upload a file to FTP]] | ||
*[[Log and Ignore Row Error]] | *[[Log and Ignore Row Error]] | ||
*[[Using C# Global Methods]] | |||
==C# Field Scripting Examples== | ==C# Field Scripting Examples== |
Revision as of 20:22, 24 May 2024
Starfish Scripting Resources
Global Scripts
To create a Global script, click on the VBScript Global or .NET GLobal button in the Mapping ribbon:
C#
- Parse XML
- Using Starfish Scripting Class Properties & Methods in C#
- Upload a file to FTP
- Log and Ignore Row Error
- Using C# Global Methods
C# Field Scripting Examples
Javascript
- Examples of using Starfish Class Functions In Javascript
- Online Regex Tester
- Regular Exp Detect URLs in text with JavaScript
VBScript
VBScript Resources
- https://www.w3schools.com/asp/asp_ref_vbscript_functions.asp
- VBScript Constants, like vbCrLf, etc: http://powerasp.net/content/new/vbscript-constants.asp
Sample Global VB Script Functions
Field Scripting Examples
- Check for bad email address
- 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/