Connection Strings for SQL Serverhttps://www.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 Fieldhttps://www.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 APIhttps://www.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 Webhookhttps://www.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 functionhttps://www.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

Zoho Creator: Receive JSON via a Shopify Webhookhttps://www.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 Decoderhttps://www.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 Delugehttps://www.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 ZohoZIAhttps://www.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 Disappearinghttps://www.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: *

DataJumble - Shuffling characters in a data valuehttps://www.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 rowshttps://www.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 fileshttps://www.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 APIhttps://www.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 JavaScripthttps://www.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 Webhookhttps://www.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 Turbohttps://www.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 CSVhttps://www.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: *

ZohoCreator: Using .toFile and Uploading to a Creator fieldhttps://www.joellipman.com/articles/crm/zoho/zohocreator-using-tofile-and-uploading-to-a-creator-field.html

25 March 2024 text files. // // generate a CSV or TXT v_CSVFilename = "applicable_products.txt"; f_CSVFile = l_CsvLines.toString(zoho.encryption.urlDecode("%0A")).toFile(v_CSVFilename); f_CSVFile.setParamName("file"); Get current file name (optional) To check on...

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

ZohoDeluge: eBay marketplace account deletion/closure notificationshttps://www.joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 v_Response = zoho.encryption.SHA256(v_ChallengeCode + v_VerificationToken + v_Endpoint); // m_Challenge = Map(); m_Challenge.put("challengeResponse",v_Response); // try { // m_MetaData = m_Params.get("metadata"); v_Topic =...

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