Scripting Class Object
From within VBScript operations (ScriptedVariable, VBScriptProcedure, ScriptedField) in additional to normal VBScript functions, the developer has access to a custom “Starfish” class. The tables below define its usage. This class may also be used ...
System Backup Wizard
The StarfishETL System Backup Wizard will walk you through a series of steps to create a complete backup framework for any system. The System Backup Wizard does not actually back up any data during this process, it only creates the tables and jobs to ...
DateTime Fields Note that when working with "DateTime" fields in SQLite, the value saved in the field and used for comparison operations must match one of the 10 allowed formats: https://www.sqlite.org/lang_datefunc.html. Starfish's FormatDate ...
Connecting to Clarizen Set up your Clarizen connector using your normal Clarizen username and password. You'll be able to select which environment you want to connect to if you have access to multiple Clarizen sites. Origin Queries Origin queries use ...
Pipedrive Connector SQL Select Statements
The API Profile supports SQL-92 Syntax. SELECT Statements includes a comprehensive list of the supported keywords and clauses, as well as syntax reference and examples. Select StatementsLast Modified - A SELECT statement can consist of the following ...