Examples of using StarfishETL Class Functions In Javascript

Examples of using StarfishETL Class Functions In Javascript

This code was used to lookup a value inside of SugarCRM using the Sugar REST connector.

function scriptedField() {
	var res = "";
	res = vals["Branch Name"];
	if (res) {
		Starfish.LogMessage(res.toString());
	}
	res = SmartLookup("TA6_Branch","id","[{\"name\":\"" + res + "\"}]");
	return res;
}
    • Related Articles

    • Using StarfishETL Scripting Class Properties & Methods in C#

      See available StarfishETL Scripting Class Variables, Properties and Methods. To use these variables, properties and methods, you must append "Starfish." to the beginning of variable, property or method AND you must use the exact capitalization as ...
    • 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 ...
    • StarfishETL security features

      StarfishETL security features Compliance and data privacy · No data kept at rest on StarfishETL iPaaS servers · Data in motion is encrypted using HTTPS Infrastructure protection · StarfishETL iPaaS servers hosted on AWS · Servers are hosted on the ...
    • Repeating a Stage using Queued Datasets

      Sometimes when building maps, it becomes necessary to call a stage multiple times to process a subset of nested data. Take for example an Origin which may return an Account, but then also a list of Contacts in a structured format (such as JSON). To ...
    • VBScript Functions

      This is a link to a page that contains all the built-in VBScript functions: https://www.w3schools.com/asp/asp_ref_vbscript_functions.asp