Assuming isnull is required, the following 70 results were found.
-
A really quick article to test when to use isNull and isBlank. Why? So I've noticed that looking at people's Zoho Deluge code, there will often be a check on a null before or after the variable: if(v_Test.isBlank()) {... } VS if(isBlank(v_Test)) {......
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// // initialize response variable m_Response = Map(); // // get xero signature v_XeroSignature = "SIGNATURE_FAIL"; if(!isnull(m_Payload.get("headers"))) { if(!isnull(m_Payload.get("headers").get("x-xero-signature"))) { v_XeroSignature =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= zoho.sign.getTemplateById(v_TemplateID); v_OutputMessage = ""; // // get the Action ID for SIGN v_SendActionID = 0; if(!isNull(v_Template) && !isNull(v_Template.get("templates"))) { // _ if(!isNull(v_Template.get("templates").get("actions"))) { // get...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
} // // ---------------------- DETERMINE ZOHOBOOKS CUSTOMER ID ---------------------- if(!isnull(r_QuoteDetails.get("Account_Name"))) { v_AccountID = r_QuoteDetails.get("Account_Name").get("id"); r_SearchResults =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
info "Workdrive response:"; info r_WorkdriveUpload; if(!isNull(r_WorkdriveUpload.get("data"))) { // // set permissions to public and visible m_Headers = Map(); m_Headers.put("Accept","application/vnd.api+json"); for each r_Data in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
timezone: BEGIN // v_CustomerTimeZone = ""; // // build up address from Lead to geocode l_LeadAddress = List(); if(!isnull(r_LeadDetails.get("Street"))) { l_LeadAddress.add(r_LeadDetails.get("Street")); } if(!isnull(r_LeadDetails.get("City"))) {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
+ v_CandidateZohoID + "/associate" type :GET connection:"my_connection" ]; //info r_Associated; if(!isnull(r_Associated.get("data"))) { for each r_Data in r_Associated.get("data") { if(!isnull(r_Data.get("id"))) { v_SearchEndpoint =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Derived column task 2: Add as new Column 'DC_Date' -- (note this is a separate task in the data flow to the previous one): (ISNULL(Date) || (TRIM(Date) == "00000000")) ? NULL(DT_DBTIMESTAMP) : (DT_DBTIMESTAMP)(SUBSTRING(Date,5,4) + "-" +...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
WHEN t1.COLUMN_DEFAULTt2.COLUMN_DEFAULT THEN 'Old [' + t1.COLUMN_DEFAULT + '] New [' + t2.COLUMN_DEFAULT + ']' ELSE ISNULL(t1.COLUMN_DEFAULT, t2.COLUMN_DEFAULT) END AS [ColumnDefault], CASE WHEN t1.IS_NULLABLE IS NULL AND t2.IS_NULLABLE IS NOT NULL THEN...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
the answer in text l_Choices = r_ChatGPTResponse.get("responseText").get("choices"); for each m_Choice in l_Choices { if(!isnull(m_Choice.get("message"))) { if(m_Choice.get("message").get("role")=="assistant") { // // add the answer text to the response...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
and copies it over to the deal record: l_Tags = List(); // r_DealDetails = zoho.crm.getRecordById("Deals",p_DealID); if(!isNull(r_DealDetails.get("Contact_Name"))) { r_ContactDetails = invokeurl [ url :"https://www.zohoapis.com/crm/v7/Contacts/" +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
name it OnSubmit > click on Create Workflow Select you want to run some Deluge Script and plug in the following code if(!isnull(input.Zoho_Inventory_ID)) { // // specify your own Inventory/Books organization ID v_BooksOrgID = 20221234567; // //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
} else { input.GMT_Date_Time_Start = v_CustomersRequestedTime.addHour(v_CustomerHours).addMinutes(v_CustomerMinutes); } if(!isnull(input.GMT_Date_Time_Start)) { input.GMT_Date_Time_End = input.GMT_Date_Time_Start.addMinutes(v_AppointmentDuration); } //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
value obtained earlier v_Auth_Token = "1234567890aaaabbbbccccddddeeeeff"; // // get lead details v_Type = "Leads"; if(!isnull(r_CallDetails.get("$se_module"))) { v_Type = r_CallDetails.get("$se_module"); } // set your default twilio number...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
headers:m_Header ]; // // retrieve the value of field "Deal_Ref" from the ZohoSign Document Request v_DealRef = ""; if(!isnull(r_RequestDetails.get("requests"))) { if(!isnull(r_RequestDetails.get("requests").get("actions"))) { l_Actions =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the answer in text l_Choices = r_ChatGPTResponse.get("responseText").get("choices"); for each m_Choice in l_Choices { if(!isnull(m_Choice.get("message"))) { if(m_Choice.get("message").get("role") == "assistant") { // // add the answer text to the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
type :GET headers:m_Header connection:"my_workdrive_connection" ]; if(!isNull(r_Subfolders.get("data"))) { for each m_Subfolder in r_Subfolders.get("data") { if(!isNull(m_Subfolder.get("attributes"))) {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
v_ListingPublishKey = "AAAAABBBBBCCCCDDDDEEEFFFGGGGHHHIIIJJJKKLLLMMMNNOOOPPPQQWRRRSSTTUUVVWWXXYYZZ122345567890"; if(!isnull(input.Main_Photo)) { v_Filename = input.Main_Photo.getSuffix("/image/").getPrefix("\""); v_ImageSrc =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
{ l_Deals = zoho.crm.getRecords("Deals", v_Page, v_PerPage, {"cvid":123456000012345678}); for each m_Deal in l_Deals { if(!isNull(m_Deal.get("id"))) { v_CountTotal = v_CountTotal + 1; if(m_Deal.get("Stage").equalsIgnoreCase("Cancelled")) { // // cancel...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
SET @StringInput = RTRIM(LTRIM(@StringInput)) WHILE LEN(@StringInput) > 0 BEGIN SET @StringValue = LEFT(@StringInput, ISNULL(NULLIF(CHARINDEX(' ', @StringInput) - 1, -1), LEN(@StringInput))) SET @StringInput = SUBSTRING(@StringInput,...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB