Examples of using Starfish Class Functions In Javascript: Difference between revisions

From Starfish ETL
Jump to navigation Jump to search
No edit summary
No edit summary
Line 11: Line 11:
//Starfish.LogMessage(obj.email_address.toString());
//Starfish.LogMessage(obj.email_address.toString());
Starfish.XRefWrite("SugarID_to_Email_Address",OriginData("ID").toString(),obj.email_address.toString());
Starfish.XRefWrite("SugarID_to_Email_Address",OriginData("ID").toString(),obj.email_address.toString());
attachmentURLs = [];
ui = 0;
var re = /(https:\/\/basyspro.com\/index.php\?gf-download=[^"<> \n]+)/g;
var body = Origin("UniqueBody");
attachmentURLs = body.match(re);
if (attachmentURLs) {
Starfish.LogMessage(attachmentURLs.toString());
}
}
}
</source>
</source>

Revision as of 14:12, 16 August 2019

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

function jsProcedure() {
	//SugarID_to_Email_Address
	//var obj = JSON.parse('{"email_address": "justin.kuehlthau@starfish.com", "primary_address": true, "reply_to_address": false, "invalid_email": false, "opt_out": false, "email_address_id": "a876b74c-a9a7-11e9-9d45-525400ec9068"}');
	var json = OriginData("EMAIL").toString();
	json = json.substring(1);
	json = json.substring(0, json.length - 1);
	//Starfish.LogMessage(json);
	var obj = JSON.parse(json);
	//Starfish.LogMessage(obj.email_address.toString());
	Starfish.XRefWrite("SugarID_to_Email_Address",OriginData("ID").toString(),obj.email_address.toString());

	attachmentURLs = [];
	ui = 0;
	var re = /(https:\/\/basyspro.com\/index.php\?gf-download=[^"<> \n]+)/g;
	var body = Origin("UniqueBody");
	attachmentURLs = body.match(re);
	if (attachmentURLs) {
		Starfish.LogMessage(attachmentURLs.toString());
	}
}