GDPR Privacy Policyhttps://www.joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 part of the customer experience, through relevant privacy notices presented in context and choices that are on brand. More info about GDPR. Terms & Conditions Conditions of Use Welcome to our online store! JoelLipman.com and its associates provide their...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

SSRS Hide results table if emptyhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 what I've been searching for for the past hour and although you may think I'm just adding to the cyberspace pile of useless info, at least I'm not just copying and pasting from other sites to add content to my own. And I'm not just adding content, the...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Accessing Apimo WebService APIhttps://www.joellipman.com/articles/automation/api-misc/accessing-apimo-webservice-api.html

29 March 2016 // set url curl_setopt($ch, CURLOPT_VERBOSE, 1); // For debugging purposes (read CURL manual for nore info) curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 30); // Timeout options curl_setopt($ch, CURLOPT_TIMEOUT, 30); // Timeout options curl_setopt($ch,...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Zoho Deluge - Get Refresh/Access Token API v2https://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 + v_Access); l_Params.add("prompt=" + v_Prompt); v_Url = v_EndPoint + "?" + l_Params.toString("&"); info v_Url; openUrl( v_Url , "new window"); This will open a page for you with a Zoho Consent form where you confirm whether your app is allowed to...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

Zoho Deluge - Counting in a Map dataTypehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-counting-in-a-map.html

02 September 2019 } else { v_PreviousValue = m_ProductCount.get(v_SKU); m_ProductCount.put(v_SKU,v_PreviousValue + 1); } } info m_ProductCount Yields: { "TEST001": 6, "TEST002": 1 } Counting total products per account: // // count total products per account m_Accounts =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

Zoho Deluge: Duplicate/Clone a Recordhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-duplicate-clone-a-record.html

17 March 2020 I haven't done any benchmark tests on this to compare but looking at different ways to exclude elements from a list: info l_FieldApiNames; l_FieldApiNames = {"a","b","c","d","e"}; l_ExcludeFields = {"b","d"}; for each v_FieldName in l_ExcludeFields {...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Projects: Add a Time Log to an Issue using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

30 April 2021 r_CreateTimeLog = invokeurl [ url :v_Url type :POST parameters:m_CreateTimeLog connection:"joels_connector" ]; info r_CreateTimeLog; Example #2: Pushing a time log defaulting to the current time as start time: // // init (from dropdowns you have made...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.https://www.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-please-ensure-that-the-shipping_address-has-less-than-100-characters.html

22 September 2021 to ZohoBooks r_CreateSO = zoho.books.createRecord("salesorders",v_BooksOrgID,m_BooksCreateSO,"ab_books"); // output response info r_CreateSO; // read response if(!isnull(r_CreateSO.get("salesorder"))) { v_SalesOrderID =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Upload a Product Photo using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-upload-a-product-photo-using-deluge.html

27 September 2021 + v_CreatorPhotoUrl; r_CreatorPhoto = invokeUrl [ url: v_Endpoint1 type: GET connection: "joels_creator" ]; info r_CreatorPhoto; // // set the param name to file (this is important) r_CreatorPhoto.setParamName("file"); // // upload the photo to CRM (and...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator / eBay: Get all Active Productshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-all-active-products.html

13 October 2021 Fetches current listings / active products Date Created: 2021-10-13 (Joellipman.com - Joel Lipman) - Initial release More Info: - API Explorer Test Tool:...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Generate List of TimeZoneshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-list-of-timezones.html

19 October 2021 // replace any commas in the value (for list conversion later on) v_TimeZone = v_TimeZone.replaceAll(","," ", true); info v_TimeZone; l_TimeZones.add(v_TimeZone); } //info l_TimeZones; Yields something like: (GMT-10:00) Hawaii Time (GMT-8:00) Alaska...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

21 October 2021 r_Templates = invokeUrl [ url: "https://zohoapis.com/writer/api/v1/templates" type: GET connection: "joels_connector" ]; info r_Templates; // // yields something like: /* { "total_count": 5, "templates": [ { "created_time": "2019-08-28T16:30:33Z",...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Schedule a Call using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-call-with-deluge.html

18 November 2021 snippet of code: // test to get the JSON response format r_CallDetails = zoho.crm.getRecordById("Calls",123456789012345678); info r_CallDetails; // // system/application is set to EST (America/New_York) v_SystemCallTime = '2021-11-19 11:12:34'; // //...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: eBay: Get Item Transactionhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-item-transaction.html

22 January 2022 Fetches a line item transaction per item ID Date Created: 2022-01-22 (Joellipman - Joel Lipman) - Initial release More Info: - API Explorer Test Tool:...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: a HTML Entity Decoderhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-a-html-entity-decoder.html

27 January 2022 } Usage: v_TestString = "Father & Sons"; v_DecodedString = thisapp.DataCleansing.fn_DecodeHtmlEntities(v_TestString); info v_DecodedString; // yields: Father & Sons A more comprehensive list v_HtmlEntityNames =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Schedule a Meeting using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-meeting-using-deluge.html

02 March 2022 an article on creating a Meeting or an Event using Zoho Deluge. Why? Because at time of print, I couldn't find that much information on how to build up a JSON request to create a meeting (previously known as Event) in Zoho CRM. Here's a quick snippet of...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttps://www.joellipman.com/articles/crm/zoho/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

17 August 2022 r_UpdateInvoice = zoho.books.updateRecord("invoices",v_BooksOrgID,v_InvoiceID,m_UpdateInvoice,"zbooks"); info r_UpdateInvoice; } } // // send ourselves an email as evidence that the workflow was triggered and ran this function sendmail [ from...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttps://www.joellipman.com/articles/crm/zoho/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html

17 October 2022 //r_File.setParamName("file"); r_File.setFileName(v_DocumentName); r_Attach = zoho.crm.attachFile("Deals",v_DealID,r_File); info r_Attach; // // to send this as an email as well sendmail [ from :zoho.adminuserid to :"info@joellipman.com" subject...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Recruit: Rollup Number of Recruit Candidates to CRM Accounthttps://www.joellipman.com/articles/crm/zoho/zoho-recruit-rollup-number-of-recruit-candidates-to-crm-account.html

19 October 2022 time but here's the code I used: r_CandidateDetails = zoho.recruit.getRecordById("Candidates",p_CandidateID,"zrecruit"); //info r_CandidateDetails; if(!isNull(r_CandidateDetails.get("Which School do you go to?"))) { v_SchoolName =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Inventory: Enable Tracking using the APIhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-enable-tracking-using-the-api.html

04 May 2023 inventory tracking m_CreateBooksItem.put("item_type","inventory"); // // other less important values to include re purchase information m_CreateBooksItem.put("product_type","goods"); m_CreateBooksItem.put("reorder_level",0);...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *