Connection Strings for SQL Serverhttp://mail.joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 server to use. Server=serverAddress1 & serverAddress2 & etc..;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Using encryption This one activates SSL encryption for all data sent between the client and server. The server needs to have a certificate...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *

Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

19 September 2021 To any other fields I would add the code: if(input.Update_Preview) { input.Audit_Change = "Title: " + zoho.encryption.md5(input.Title); } This still causes endless loops in certain cases because OnEdit, when we reach field 1 and audit change is invoked,...

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

Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

17 October 2021 r_DownloadPhoto = invokeUrl [ url: v_ImageSrc type: GET ]; r_DownloadPhoto.setParamName("file"); v_EncodedImg = zoho.encryption.base64Encode(r_DownloadPhoto); m_Params = Map(); m_SubParams = Map(); m_SubParams.put("position", 1);...

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

ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-xero-real-time-invoices-receive-webhook.html

10 January 2022 = m_Payload.get("headers").get("x-xero-signature"); } } // // encrypt body with Sha-256 v_WebhookBodyHMACSHA256 = "ENCRYPTION_FAIL"; v_ResponseCode = 401; if(!isnull(m_Payload.get("body"))) { v_WebhookBodyHMACSHA256 =...

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

Zoho Deluge - MD5 functionhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-md5-function.html

19 November 2018 it would be. At time of print, the Zoho documentation (and Google search results) make no mention of using MD5 in an encryption task. Why? I'm trying to create an ETag for a synchronization process between Zoho Creator and Zoho CRM. Combining all the...

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

ZohoCRM & Xero: Function to pull most recent invoiceshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-invoices.html

09 October 2025 DESC"); // // get the first page of Xero invoices v_FilterReceivables = "?where=" + zoho.encryption.urlEncode("Type=\"ACCREC\""); r_AllXeroInvoices = invokeurl [ url :v_DataEndpoint + "/Invoices" + v_FilterReceivables type :GET parameters:m_Params...

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

Zoho Creator: Receive JSON via a Shopify Webhookhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-receive-json-via-a-shopify-webhook.html

15 July 2021 // default response code (unauthorized) v_ResponseCode = 401; // // encrypt body with Sha-256 v_WebhookBodyHMACSHA256 = "ENCRYPTION_FAIL"; if(!isnull(m_Payload.get("body"))) { v_WebhookBodyHMACSHA256 =...

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

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

27 January 2022 want to display these as decoded HTML entities. (Zoho if you're listening) Ideally, Zoho may add this to their zoho.encryption namespace such as zoho.encryption.htmldecode(string). But at time of print, it doesn't exist and in the meantime, I've made a...

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

Zoho CRM & Zoho Inventory: Upload Image to Item Record using Delugehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-zoho-inventory-upload-image-to-item-record.html

21 June 2022 = "https://picsum.photos/200"; r_DownloadedPhoto = invokeurl [ url :v_ImageSrc type :GET ]; v_DownloadedBase64 = zoho.encryption.base64Encode(r_DownloadedPhoto); f_base64 = zoho.encryption.base64DecodeToFile(v_DownloadedBase64,"my_image.png"); // // set...

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

ZohoCRM: Integrate ChatGPT to ZohoZIAhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 v_Response = "I don't know. Would you like me to Google: [" + v_Message + "](https://www.google.com/search?q=" + zoho.encryption.urlEncode(v_Message) + ")?"; } } // // build up response to user m_Prompt = Map(); m_Prompt.put("param_name","banter");...

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

Zoho Webhooks & Shopify API: Keep Disappearinghttp://mail.joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

22 April 2024 // // build the hash based on the payload body v_Data = ifnull(m_Payload.get("body"),""); v_VerifyHash = zoho.encryption.hmacsha256(v_ClientSecret,v_Data,"base64"); // // retrieve Shopify's Hmac SHA256 from the header v_ShopifyHash = "";...

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

Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttp://mail.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 is check your TLD (eg. .com or .eu or...) v_Endpoint = "https://analyticsapi.zoho.com/api/" + v_OwnerEmail + "/" + zoho.encryption.urlEncode(v_WorkspaceName) + "/" + zoho.encryption.urlEncode(v_ViewName); m_Params = Map();...

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

DataJumble - Shuffling characters in a data valuehttp://mail.joellipman.com/articles/database/t-sql/data-shuffling-function.html

01 August 2012 ; GO -- Create user defined function CREATE FUNCTION ufn_DataJumble ( @OrigVal varchar(max) ) RETURNS varchar(max) WITH ENCRYPTION AS BEGIN -- Variables used DECLARE @NewVal varchar(max); DECLARE @OrigLen int; DECLARE @CurrLen int; DECLARE @LoopCt int;...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

DataScramble - Randomizing data rowshttp://mail.joellipman.com/articles/database/t-sql/datascramble-randomizing-data-rows.html

07 December 2012 ; GO -- Create user defined function CREATE FUNCTION ufn_DataScramble ( @OrigVal varchar(max) ) RETURNS varchar(max) WITH ENCRYPTION AS BEGIN -- Variables used DECLARE @NewVal varchar(max); DECLARE @OrigLen int; DECLARE @CurrLen int; DECLARE @LoopCt...

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

MS-DOS: Copy folders without overwriting fileshttp://mail.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 /L Displays files that would be copied. /G Allows the copying of encrypted files to destination that does not support encryption. /H Copies hidden and system files also. /R Overwrites read-only files. /T Creates directory structure, but does not copy...

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

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

29 March 2016 $apimo_version = 2; // specify data output $apimo_method = 'getAgencies'; $apimo_type = 'xml'; // specify key and encryption $apimo_key = 'abcd1234abcd1234abcd1234abcd1234abcd1234'; // specify your assigned key here $apimo_sha =...

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

Zoho Creator: Create a Widget which uses JavaScripthttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 added note/step if you get the following error when trying to access your app on your localhost: “127.0.0.1 normally uses encryption to protect your information. When Google Chrome tried to connect to 127.0.0.1 this time, the website sent back unusual...

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

Zoho Creator: Receive eBay Order Notifications via Webhookhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 check expiry against the server time anyway if(zoho.currenttime >= r_Api.Access_Token_Expiry) { v_Base64Auth = zoho.encryption.base64encode(r_Api.Client_ID + ":" + r_Api.Client_Secret); v_TokenEndpoint = r_Api.Token_Endpoint; m_Headers = Map();...

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

Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttp://mail.joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

13 February 2023 all v_Response = "I don't know. Would you like me to Google: [" + v_Message + "](https://www.google.com/search?q=" + zoho.encryption.urlEncode(v_Message) + ")?"; m_Response = {"text":v_Response }; } } return m_Response; Error(s) Encountered: Exceeded...

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

ZohoDeluge: Inserting a new line character in a CSVhttp://mail.joellipman.com/articles/crm/zoho/zohodeluge-inserting-a-new-line-character-in-a-csv.html

01 March 2023 l_CsvFileRows.add("a,b,c"); // v_CSVFilename = "Test.csv"; f_CSVFile = l_CsvFileRows.toString(zoho.encryption.urlDecode("%0A")).toFile(v_CSVFilename); // // yields: // Me,Myself,I // a,b,c Additional Adding to a screen output: eg. a button response or...

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