Assuming ifnull is required, the following 61 results were found.
-
= zoho.crm.getRecordById("Quotes", 123456789012345678); // // transform variables for main record v_QuoteName = ifnull(r_QuoteDetails.get("Name"),"Test Quote"); if(!isNull(r_QuoteDetails.get("Contact_Name"))) { r_ContactDetails =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the Opportunity/Deal/Potential record. In this example, the custom field is called "Division": // // init v_DealID = ifnull(p_DealID,0); r_DealDetails = zoho.crm.getRecordById("Deals",v_DealID); // // Map users/owners division to this deal...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
"https://www.zohoapis.com/crm/v6/org/taxes" type: GET connection: "zcrm" ]; info r_TaxRates; // list tax rates l_Taxes = ifnull(r_TaxRates.get("org_taxes").get("taxes"),List()); Source(s): Zoho CRM: Modifying Special Fields: Customize Tax Rates
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
if(!isnull(r_GetFullRecord.get("data"))) { r_CreatorRecord = r_GetFullRecord.get("data"); v_CreatorPhotoUrl = ifnull(r_CreatorRecord.get("Display_Photo"),""); if(v_CreatorPhotoUrl!="") { // // download photo from your Creator (change connection and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
{ // // an error-prone one-liner so that we don't hit an execution statement limit v_ProductSKU = ifnull(r_ShopifyProduct.get("variants").get(0).get("sku"), "UNKNOWN"); m_Sku_IDs.put(v_ProductSKU, r_ShopifyProduct.get("id")); // // getting the last ID...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
m_NewLineItem.put("Quoted_Items.Description", r_LineItem.get("Description")); v_Quantity = (ifnull(r_LineItem.get("Quantity"),1).toDecimal().round(2)).toString().replaceAll(("(?
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the English ordinal bit I used: m_Ordinals = {1:"st",21:"st",31:"st",2:"nd",22:"nd",3:"rd",23:"rd"}; v_Day3_Ordinal = ifnull(m_Ordinals.get(v_NextDay.toString("d").toLong()),"th"); Then in my HTML table, I can use the headers: v_Day1_Header = " Today "...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// Parse body of Xero webhook and update respective CRM record // m_Body = ifnull(m_Payload.get("body"),m_Blank); // // check if events was in the payload if(!isnull(m_Body.get("events"))) { // // parse events out of the webhook (a list) l_Events =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
you like): string DataCleansing.fn_DecodeHtmlEntities( string p_StringToDecode ) { // initialize v_StringToDecode = ifnull(p_StringToDecode,""); // // map string replacements m_HtmlEntity = Map(); m_HtmlEntity.put("&","&"); m_HtmlEntity.put(" ","...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
:"https://www.zohoapis.eu/crm/v7/coql" type :POST parameters:m_Params.toString() connection:"zcrm" ]; l_SortedProducts = ifnull(r_CoqlSortedProducts.get("data"), List()); Source(s): Joel Lipman - ZohoCRM: Process all records of a module Zoho Deluge -...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
we want to check for v_LeadStatus = ""; if(!isnull(m_Webhook.get("record"))) { // // extract lead status v_LeadStatus = ifnull(m_Webhook.get("record").get("Lead_Status"),""); } // // if user profile is not allowed to make this change...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// ************************************************** CREATOR ************************************************** v_ItemId = ifnull(p_InventoryItemID,0); v_PublicUrl = ""; // // send Zoho Creator the inventory ID v_AppOwner = "JoelGoHappy"; v_AppName =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
+ l_Params.toString("&"); r_AccessToken = invokeUrl [ url: v_Url type: POST ]; // // output v_AccessToken = ifnull(r_AccessToken.get("access_token"), ""); // // use the access token to query requests m_Header = Map();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
*/ // // initialize v_ShipmentStatus = "error"; v_TrackingNumber = ifnull(p_TrackingNumber,0); // // specify your DHL API Key (no need for the secret or base64 encoding) v_DHL_API_Key = "1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ"; // // build up header...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
[ url: "https://www.zohoapis.com/crm/v3/settings/business_hours" type: GET connection: "mycrmconnection" ]; m_OrgDetails = ifnull(r_OrgDetails.get("business_hours"),{}); if(m_OrgDetails.get("business_days") != null) { // // let's format a little as the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
+ v_BooksOrgID type :GET connection:"zbooks" ]; m_Warehouses = Map(); l_Warehouses = ifnull(r_Warehouses.get("warehouses"), List()); for each m_Warehouse in l_Warehouses { m_Warehouses.put(m_Warehouse.get("warehouse_name"),...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
:"https://desk.zoho.eu/api/v1/tickets/" + p_TicketID + "/attachments" type :GET connection:"zdesk" ]; l_AttachmentDetails = ifnull(r_Attachments.get("data"),{}); for each r_Attachment in l_AttachmentDetails { m_Attachment = r_Attachment.toMap();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
sure you can lock it down to just the scopes you need. void ZohoBooks.fn_SendZohoBooksInvoice(int p_OrderID) { v_OrderID = ifnull(input.p_OrderID,0).toLong(); /* ******************************************************************************* Function:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
+ r_DealDetails.get("Contact_Name").get("id") type :GET connection:"zcrm" ]; // l_ContactDetails = ifnull(r_ContactDetails.get("data"), List()); for each m_ContactDetails in l_ContactDetails { if(!isNull(m_ContactDetails.get("Tag"))) { for each m_Tag in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
[ url :"https://www.zohoapis.com/crm/v8/Deals/" + p_DealID + "?fields=Pipeline" type :GET connection:"zcrm" ]; l_DealData = ifnull(r_RecordDetails.get("data"),List()); for each m_DealData in l_DealData { if(!isNull(m_DealData.get("id"))) { r_DealDetails...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF