Posts

Connector - DB Remove Special Character

  escapeSql(String str)  

Enhanced Query Execution

UPDATE SELECT  'Active' AS Accounts__status , a.accountkey as  accounts__PRIMARYKEY FROM accounts a where a.accountkey=72 INSERT SELECT 'NEWCUSTOMERTEST500' AS customer__customername,'International Development' AS customer__description,'543256' AS customer__customproperty1,'543256 International Development' AS customer__customproperty2,'StarHR' AS customer__customproperty3,'Imported' AS customer__customproperty4,'BU56.5.4.00003444.543256' customer__customproperty5,'Global Business Support' AS customer__customproperty7,'1' AS customer__parentcustomer,SYSDATE() AS customer__CREATEDATE,1 AS customer__RISK,1 as customer__SCORE,1 AS customer__STATUS,SYSDATE() AS customer__UPDATEDATE,'2024-01-01' AS customer__ENDDATE FROM customer select 2095 AS accountowners__OWNERUSERGROUPKEY,ACCOUNTOWNERKEY as accountowners__PRIMARYKEY,1 AS accountowners__RANK, 'sysdate()' AS accountowners__UPDATEDATE , 1 AS ac...

Connector - REST - Escape Special Characters

  ${org.apache.commons.lang.StringEscapeUtils.escapeJava(reqAttrs.customproperty10)}

Email Variables - Report Email

  date = 2023-11-23 02:29:32 endpoint = null totalRecords = 14 analyticsConfig = com.saviynt.ecm.analytics.AnalyticsConfigES : 1570 endpointDisplayName = null baseUrlForEmail = https://-dev.saviyntcloud.com/ ownerEmail = out = java.io.PrintWriter@135a96e3 [date:2023-11-23 02:29:32, endpoint:null, totalRecords:14, analyticsConfig:com.saviynt.ecm.analytics.AnalyticsConfigES : 1570, endpointDisplayName:null, baseUrlForEmail:https://-dev.saviyntcloud.com/, ownerEmail:, out:java.io.PrintWriter@135a96e3] 

Email Variables - Task completion Disconnected Revoke Access

  ApprovedEntitlementWithBJ = RejectEntitlement = randompassword = null out = java.io.PrintWriter@63184313 password = requesttype = Remove accountname = Rushikesh.Vartak@.com ApprovedEntitlement = endpointDisplayName = Costar account_name = Rushikesh.Vartak@com requestormanager = 84809 RejectEntitlementWithBJ = tasks = com.saviynt.ecm.task.ArsTasks : 99424 endpoints = Costar tasktype = Modify Account manager = 84809 rolename = entitlement = [Financial Reporting] requestor = 137658 users = 137658 account_password = Welcome123 task = com.saviynt.ecm.task.ArsTasks : 99424 requestid = 4310001 baseUrlForEmail = https://release-n-plus-one.saviyntcloud.com/ECM user = 137658 taskaction = Modify Account account = Rushikesh.Vartak@.com

Email Variables Task Completion -Disconnected Application Add Access

  Non-Vehicle Portfolio ApprovedEntitlementWithBJ = RejectEntitlement = randompassword = null out = java.io.PrintWriter@6437bab1 password = requesttype = Add accountname = Rushikesh.Vartak@.com ApprovedEntitlement = endpointDisplayName = Costar account_name = Rushikesh.Vartak@.com requestormanager = 84809 RejectEntitlementWithBJ = tasks = com.saviynt.ecm.task.ArsTasks : 99417 endpoints = Costar tasktype = Modify Account manager = 84809 rolename = entitlement = [Non-Vehicle Portfolio] requestor = 137658 users = 137658 account_password = Welcome123 task = com.saviynt.ecm.task.ArsTasks : 99417 requestid = 4300001 baseUrlForEmail = https://release-n-plus-one.saviyntcloud.com/ECM user = 137658 taskaction = Modify Account account = Rushikesh.Vartak@.com

REST Connector Variables

 Create Account JSON REST/Azure AD ${task?.requestAccessKey?.collect{ it.request_access_attrss.findAll{it.attributeName.toString().equalsIgnoreCase(' SomeValue ')}?.collect{it.attributeValue}}?.get(0)?.get(0)} SomeValue is the Dynamic Attribute Name