Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL) https://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html
14 February 2022
m_Header.put("X-Shopify-Access-Token", v_AccessToken); // // graphql v_GraphQl = "{ products(first: 5, reverse: true) { edges { node { id title handle } } } }"; m_GraphQl = Map(); m_GraphQl.put("query", v_GraphQl); // // Let's test with this GraphQL...
Type: Article
Author: Joel Lipman
Category: Zoho Creator
Language: *
Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo https://joellipman.com/articles/crm/zoho/zoho-other/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html
13 February 2023
[ url :"https://api.openai.com/v1/chat/completions" type :POST parameters:m_Params.toString() headers:m_Header detailed:true ]; if(r_ChatGPTResponse.get("responseCode") == 200) { // // retrieve the answer in text l_Choices =...
Type: Article
Author: Joel Lipman
Category: Zoho Other
Language: *
ZohoCRM: Integrate ChatGPT to ZohoZIA https://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-integrate-chatgpt-to-zohozia.html
06 March 2023
[ url :"https://api.openai.com/v1/chat/completions" type :POST parameters:m_Params.toString() headers:m_Header detailed:true ]; if(r_ChatGPTResponse.get("responseCode") == 200) { // // retrieve the answer in text l_Choices =...
Type: Article
Author: Joel Lipman
Category: Zoho CRM
Language: *
Google Authentication - OAuth 2.0 using PHP/cURL https://joellipman.com/component/content/article/google-authentication-oauth-2-0-using-php-curl.html?catid=61&Itemid=165
31 October 2018
retrieve from credentials file function getStoredCredentials($path) { $credentials = json_decode(file_get_contents($path), true); $expire_date = new DateTime(); $current_time = new DateTime(); $expire_date->setTimestamp($credentials['created']-300);...
Type: Article
Author: Joel Lipman
Category: Google
Language: en-GB
Foreign Characters create symbols in PHP and MySQL https://joellipman.com/articles/cms/website-development/php/foreign-characters-create-symbols-in-php-and-mysql.html
25 January 2016
Manual My fix (in some cases): $my_description = html_entity_decode(htmlentities($my_description, ENT_COMPAT, 'ISO-8859-1', true), ENT_COMPAT, 'UTF-8'); A more updated version: $my_description = html_entity_decode(htmlentities($my_description,...
Type: Article
Author: Joel Lipman
Category: Personal Home Page
Language: en-GB
MySQL Group_concat equivalent in T-SQL and Oracle https://joellipman.com/articles/else/database/mysql-groupconcat-equivalent-in-t-sql-and-oracle.html
28 November 2011
from the same table. MySQL SELECT ( SELECT GROUP_CONCAT(column_to_return_as_string) FROM a_pretend_table WHERE a_condition=true ) AS my_field_name FROM another_pretend_table T-SQL SELECT STUFF( ( SELECT ',' + column_to_return_as_string FROM...
Type: Article
Author: Joel Lipman
Category: Databases
Language: en-GB
Zoho Creator / eBay: Get all Active Products https://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-ebay-get-all-active-products.html
13 October 2021
// // include fixed price items m_ActiveList = Map(); m_ActiveList.put("Include","true"); m_ActiveList.put("ListingType","FixedPriceItem"); m_Pagination = Map(); m_Pagination.put("PageNumber",v_Page); m_Pagination.put("EntriesPerPage",v_PerPage);...
Type: Article
Author: Joel Lipman
Category: Zoho Creator
Language: *
Zoho Creator: Public URL of an Image field / Upload to Shopify API https://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html
17 October 2021
encode it but no extras to upload it in addition to the product update): // initialize m_Product = Map(); b_CreateProduct = true; // // I have a field called Shopify Product ID which stores the... um... shopify product id......
Type: Article
Author: Joel Lipman
Category: Zoho Creator
Language: *
Zoho Deluge: a HTML Entity Decoder https://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-a-html-entity-decoder.html
27 January 2022
v_HtmlKey in m_HtmlEntity.keys() { v_StringToDecode = v_StringToDecode.replaceAll(v_HtmlKey, m_HtmlEntity.get(v_HtmlKey), true); } // // output return v_StringToDecode; } Usage: v_TestString = "Father & Sons"; v_DecodedString =...
Type: Article
Author: Joel Lipman
Category: Zoho Deluge
Language: *
ZohoDeluge: Check Shipment Status via DHL API https://joellipman.com/articles/crm/zoho/zoho-deluge/zohodeluge-check-shipment-status-via-dhl-api.html
21 March 2023
+ v_TrackingNumber; // // send request r_ShipmentDetails = invokeurl [ url: v_Endpoint type: GET headers: m_Header detailed: true ]; // // parse response if(r_ShipmentDetails.get("responseCode")==200) { l_Shipments =...
Type: Article
Author: Joel Lipman
Category: Zoho Deluge
Language: *
Zoho Books: Get Invoice Payment Terms via API https://joellipman.com/articles/crm/zoho/zoho-books/zoho-books-get-invoice-payment-terms-via-api.html
06 July 2023
"payment_terms": 60, "is_default": false, "payment_terms_label": "Net 60" }, { "payment_terms_id": "", "is_mandatory": true, "payment_terms": -2, "payment_terms_label": "Due end of the month" }, { "payment_terms_id": "", "is_mandatory": true,...
Type: Article
Author: Joel Lipman
Category: Zoho Books
Language: *
ZCRM Client Script: Correct Decimal Fields OnLoad https://joellipman.com/articles/crm/zoho/zoho-crm/zcrm-client-script-correct-decimal-fields-onload.html
13 December 2023
- ??? ******************************************************************************* */ // freezes the GUI? ZDK.UI.freeze(true); // attempt try { // taken from stackoverflow:...
Type: Article
Author: Joel Lipman
Category: Zoho CRM
Language: *
Zoho CRM: Client Script Confirmation Box and Popup Mailer https://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-prompt-and-popup-mailer.html
06 February 2024
I've set for myself is as follows: Trigger if the contact record has a tickbox called "Extra Confidential" ticked/checked=true Popup a confirmation box to proceed or cancel. Popup the email from CRM mailer with the to email address, bcc, subject and...
Type: Article
Author: Joel Lipman
Category: Zoho CRM
Language: *
Zoho Books: Error 7008: There are no contact persons associated with this Invoice https://joellipman.com/articles/crm/zoho/zoho-books/zohobooks-error-7008-there-are-no-contact-persons-associated-with-this-invoice.html
07 March 2024
the send an invoice API - Need the generated invoice to pre-select a contact person to email - Superceded by including "send=true" in the invoice creation request More Info: Error 1038: JSON is not well formed - Encountered when trying to use the send...
Type: Article
Author: Joel Lipman
Category: Zoho Books
Language: *
ZohoCreator: Using .toFile and Uploading to a Creator field https://joellipman.com/articles/crm/zoho/zoho-creator/zohocreator-using-tofile-and-uploading-to-a-creator-field.html
25 March 2024
{ l_CsvRow = List(); l_CsvRow.add(c_Product.Photo); l_CsvRow.add(c_Product.Product_Name.replaceAll(",", ",", true)); l_CsvRow.add(c_Product.Product_Desc.replaceAll(",", ",", true)); l_CsvRow.add("\"" + c_Product.ID + "\"");...
Type: Article
Author: Joel Lipman
Category: Zoho Creator
Language: *
Zoho Webhooks & Shopify API: Keep Disappearing https://joellipman.com/articles/else/e-commerce/shopify/zoho-webhooks-shopify-api-automatically-restore.html
22 April 2024
// // restore by default b_RestoreOrderUpdateWebhook = true; b_RestoreInventoryLevelWebhook = true; // // retrieve connection details record r_ShopifyConnection =...
Type: Article
Author: Joel Lipman
Category: Shopify
Language: *
ZohoAnalytics & ZohoBooks: Custom Related List from Analytics https://joellipman.com/articles/crm/zoho/zoho-books/zohoanalytics-zohobooks-custom-related-list-from-analytics.html
09 July 2024
Date").toDate().toString("dd-MMM-yyyy")); m_Details.put("po_ref",{"value":m_DataRow.get("PO Ref"),"isExternal":true,"link":"https://books.zoho.eu/app/" + v_BooksOrgID + "#/purchaseorders/" + m_DataRow.get("PO ID")});...
Type: Article
Author: Joel Lipman
Category: Zoho Books
Language: *
Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Template https://joellipman.com/articles/crm/zoho/zoho-books/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html
04 November 2024
} } } } } // // accept or decline if(v_EstimateID != "-") { if(v_Intent == "Accept") { b_ValidResponse = true; // // Mark the estimate as accepted r_Accept = invokeurl [ url :"https://www.zohoapis.com/books/v3/estimates/" + v_EstimateID +...
Type: Article
Author: Joel Lipman
Category: Zoho Books
Language: *
ZohoCRM GetRelatedRecords INVALID_DATA https://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-getrelatedrecords-invalid_data.html
30 January 2025
// mark the deal as processed r_UpdateDeal = zoho.crm.updateRecord("Deals", m_Deal.get("id"), {"Cancelled_Related_Records":true}, {"trigger":{}}); if(!isNull(r_UpdateDeal.get("id"))) { v_CountUpdated = v_CountUpdated + 1; } } } } } Corrected Code: /*...
Type: Article
Author: Joel Lipman
Category: Zoho CRM
Language: *
ZohoCRM / Client Script / Canvas: Hide Tab based on Pipeline https://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-client-script-canvas-hide-tab-based-on-pipeline.html
06 May 2025
on pipeline, show the tab if (v_DealPipeline == "Sales Pipeline") { ZDK.UI.getElementByID("Tab_SalesPipeline").setVisibility(true); ZDK.UI.getElementByID("Tab_SalesPipeline").setActive(); } else if (v_DealPipeline == "Hire Pipeline") {...
Type: Article
Author: Joel Lipman
Category: Zoho CRM
Language: *