Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://www.joellipman.com/articles/crm/zoho/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

14 February 2022 [ url :v_Endpoint type :POST parameters: m_GraphQl.toString() headers:m_Header ]; return r_GetProduct.toMap(); } Job done! Yields something like: { "data": { "productVariants": { "edges": [ { "node": { "id":...

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

Zoho Creator: Radio group into Calendar Carouselhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-radio-group-into-calendar-carousel.html

09 March 2022 option includes some HTML, specifically a SPAN tag surrounding the date number (eg. "Wednesday9March"), which yields the following: Then I get rid of the label with the following CSS: label.zc-Calendar_Day_Select-label{display:none !important;} Then get...

• 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 picture in a list variable: l_Pictures = x_MainNode.executeXPath("//Item/PictureDetails/PictureURL/text()").toXmlList(); // yields //...

• 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 response text m_Response.put("text","I don't know. Consider doing a Google search."); } } // // output return m_Response; Yields something like the following: Text-Davinci-003: (preceded ChatGPT API) // // initialize m_Response = Map(); v_Answer = "";...

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

Zoho Deluge: Proper Case for Nameshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-proper-case-for-names.html

13 July 2023 = v_LastName.trim(); // // join all together v_FullName = trim(v_FirstName + " " + v_LastName); info v_FullName; // // yields: Billie-Jo McDonald-O'Leary II of Cambridge-Worcester-Oxford Caveat(s): This solution does not cater for the Mac prefix;...

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

Zoho Creator: Sendmail a list of attachmentshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-send-mail-a-list-of-attachments.html

20 July 2023 to: "info@joellipman.com" subject: "Test File: List" message: "This is just a test" attachments: file: l_Downloads ] } Yields

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

Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-using-remove-key-on-a-map.html

03 March 2025 in that if you try to assign this to a new variable name, it will fail. In other words: m_NewTag = m_Tag.remove("id"); // yields null m_Tag.remove("id"); // returns m_Tag map without the ID key-value pair The use-case This is a snippet that gets the...

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

Convert seconds to total time in PHPhttps://www.joellipman.com/articles/web-development/php/convert-seconds-to-total-time-in-php.html

31 January 2012 $total_time.=str_pad(intval($total_seconds%60),2,"0",STR_PAD_LEFT); // yields // 82800 = 23:00:00 // 108000 = 30:00:00 On one line: $total_time=intval(intval($total_seconds)/...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

UNC Paths in Sharepoint 2007 linkshttps://www.joellipman.com/articles/microsoft/sharepoint/unc-paths-in-sharepoint-2007-links.html

08 November 2012 the link when you OK it if you are trying to enter a real UNC path: File://\\myServer\myShare\myFolder\myFile.doc -- yields file:////myServer/myShare/myFolder/myFile.doc

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

Oracle: order by subquery missing right parenthesishttps://www.joellipman.com/articles/database/pl-sql/oracle-order-by-subquery-missing-right-parenthesis.html

05 December 2013 pa.person_reference = ps.person_reference order by pa.last_modified_date desc ) FROM Person_Staff ps -- In oracle, yields "missing parenthesis" error. So you can see my parentheses are fine. Working Solution: SELECT ps.person_id, ps.person_name, (...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: *

SSRS Display question mark when date is blankhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-display-question-mark-when-date-is-blank.html

15 April 2014 moment, the expression in there is something like this: =Format(Fields!MyCompletionTime.Value, "dd/MM/yyyy HH:mm:ss") -- yields 11/02/2014 11:21:32 Sounds good, where's the problem? The problem Putting the date in an IIF (if-then-else) statement...

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

Zoho Deluge: Convert Map to URL Parametershttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-convert-map-to-url-parameters.html

09 March 2020 { l_UrlParams.add(v_Key.toString() + "=" + m_Payload.get(v_Key)); } info v_Endpoint + "?" + l_UrlParams.toString("&"); // yields...

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