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

20 September 2021 = r_Api.Access_Token; // // zoho.currentttime can be server time as this function will check expiry against the server time anyway if(zoho.currenttime >= r_Api.Access_Token_Expiry) { v_Base64Auth = zoho.encryption.base64encode(r_Api.Client_ID + ":" +...

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

ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://joellipman.com/articles/crm/zoho/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

08 February 2023 // // note that ordering here seemed to do nothing... it's in an order, not sure what order. Let's loop through every page anyway. l_Candidates =...

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

Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://joellipman.com/articles/crm/zoho/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

20 February 2023 by forcing the sort criteria to be by order of cursor alphabetically; but we were happy with the results the above code did anyway so I haven't tried this. Source(s): Shopify Dev - Paginating results with GraphQL

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

ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://joellipman.com/articles/crm/zoho/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

18 September 2023 the attention/phone number goes along as my client didn't include these in her estimate template... But I'm sending them anyway. Note(s) The following code accesses APIs on the EU datacenter. I have a connection called "zbooks" which has the necessary...

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

MS Excel: Convert a text to a numberhttps://joellipman.com/articles/microsoft/excel/ms-excel-convert-a-text-to-a-number.html

15 November 2013 website is as helpful as the Microsoft paperclip, in other words, not worth the time or effort to try (didn't work anyway). The TRIM() function will not work for you either, nor with the VALUE() function.... The culprit was a suspicious space which had...

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

MS Excel - Open CSV with Long Numbershttps://joellipman.com/articles/microsoft/excel/ms-excel-open-csv-with-long-numbers.html

23 July 2019 on opening a CSV in MS Excel but without converting long numbers into exponential notations (which are incorrectly rounded anyway). My Data: Account ID,Name,Phone,Record ID 1457102000000135533,Joel,00441234567890,1457102000000165989...

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