Zoho Creator: Receive eBay Order Notifications via Webhook https://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-receive-ebay-order-notifications-via-webhook.html
20 September 2021
m_Headers.put("Authorization","Basic " + v_Base64Auth); m_Params = Map(); m_Params.put("grant_type","refresh_token"); m_Params.put("refresh_token",r_Api.Refresh_Token); m_Params.put("scope",r_Api.Scope_s); r_eBayResponse = invokeurl [ url...
Type: Article
Author: Joel Lipman
Category: Zoho Creator
Language: *
Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo https://www.joellipman.com/articles/crm/zoho/zoho-other/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html
13 February 2023
= Map(); m_Header.put("Authorization","Bearer " + v_Token); m_Header.put("Content-Type","application/json"); // // build params of request m_Params = Map(); m_Params.put("model", "gpt-3.5-turbo"); m_Message = Map(); m_Message.put("role", "user");...
Type: Article
Author: Joel Lipman
Category: Zoho Other
Language: *
ZohoCRM: Integrate ChatGPT to ZohoZIA https://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-integrate-chatgpt-to-zohozia.html
06 March 2023
= Map(); m_Header.put("Authorization","Bearer " + v_Token); m_Header.put("Content-Type","application/json"); // // build params of request m_Params = Map(); m_Params.put("model","gpt-3.5-turbo"); m_Params.put("messages",l_Messages); // //...
Type: Article
Author: Joel Lipman
Category: Zoho CRM
Language: *
Migrate Joomla! 1.5.x to 2.5.x+ https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html
30 January 2011
( `parent_id`, `lft`, `rgt`, `level`, `path`, `extension`, `title`, `alias`, `note`, `description`, `published`, `access`, `params`, `metadata`, `created_user_id`, `created_time`, `language`) SELECT @new_jos_banners_parent_id AS parent_id,...
Type: Article
Author: Joel Lipman
Category: Joomla
Language: *
ZohoCRM: Get All eBay Active Listings https://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-get-all-ebay-active-listings.html
01 March 2023
m_Headers.put("X-EBAY-API-CALL-NAME",v_ApiCall); m_Headers.put("X-EBAY-API-IAF-TOKEN",v_AccessToken); // // build params m_Params = Map(); m_Params.put("WarningLevel","High"); m_Params.put("ErrorLanguage","en_GB");...
Type: Article
Author: Joel Lipman
Category: Zoho CRM
Language: *
Zoho Deluge: Get All Orders from eBay https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-all-orders-from-ebay.html
29 March 2023
m_Headers.put("X-EBAY-API-CALL-NAME",v_ApiCall); m_Headers.put("X-EBAY-API-IAF-TOKEN",v_AccessToken); // // build params m_Params = Map(); m_Params.put("WarningLevel","High"); m_Params.put("ErrorLanguage","en_GB");...
Type: Article
Author: Joel Lipman
Category: Zoho Deluge
Language: *
Zoho Creator / eBay: Get all Active Products https://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-ebay-get-all-active-products.html
13 October 2021
m_Headers.put("X-EBAY-API-CALL-NAME",v_ApiCall); m_Headers.put("X-EBAY-API-IAF-TOKEN",v_AccessToken); // // build params m_Params = Map(); m_Params.put("WarningLevel","High"); m_Params.put("ErrorLanguage","en_GB");...
Type: Article
Author: Joel Lipman
Category: Zoho Creator
Language: *
Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures https://www.joellipman.com/articles/else/e-commerce/ebay/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html
31 March 2022
v_FormName = "Inventory_Photo"; v_ReportName = "Inventory_Photo_Report"; m_Blank = Map(); m_CreatorParams = Map(); m_CreatorParams.put("Zoho_Inventory_ID",v_ItemId); r_Creator =...
Type: Article
Author: Joel Lipman
Category: Ebay
Language: *
ZohoDeluge: Get All eBay Orders Given a From and Till Date https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zohodeluge-get-all-ebay-orders-given-a-from-and-till-date.html
28 February 2023
m_Headers.put("X-EBAY-API-CALL-NAME",v_ApiCall); m_Headers.put("X-EBAY-API-IAF-TOKEN",v_AccessToken); // // build params m_Params = Map(); m_Params.put("WarningLevel","High"); m_Params.put("ErrorLanguage","en_GB");...
Type: Article
Author: Joel Lipman
Category: Zoho Deluge
Language: *
Zoho Creator: eBay: Get Item Transaction https://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-ebay-get-item-transaction.html
22 January 2022
m_Headers.put("X-EBAY-API-CALL-NAME",v_ApiCall); m_Headers.put("X-EBAY-API-IAF-TOKEN",v_AccessToken); // // build params m_Params = Map(); m_Params.put("WarningLevel","High"); m_Params.put("ErrorLanguage","en_GB");...
Type: Article
Author: Joel Lipman
Category: Zoho Creator
Language: *
ZohoCRM Webhook: Create ZohoInventory Records from an eBay order https://www.joellipman.com/articles/crm/zoho/zoho-inventory/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html
27 April 2023
m_Headers.put("X-EBAY-API-CALL-NAME",v_ApiCall); m_Headers.put("X-EBAY-API-IAF-TOKEN",v_AccessToken); // // build params m_Params = Map(); m_Params.put("WarningLevel","High"); m_Params.put("ErrorLanguage","en_GB");...
Type: Article
Author: Joel Lipman
Category: Zoho Inventory
Language: *
Zoho Cliq: Integrate OpenAI ChatGPT with Conversation Threads https://www.joellipman.com/articles/crm/zoho/zoho-other/zoho-cliq-integrate-openai-chatgpt-with-conversation-threads.html
06 March 2023
= Map(); m_Header.put("Authorization","Bearer " + v_Token); m_Header.put("Content-Type","application/json"); // // build params of request m_Params = Map(); m_Params.put("model","gpt-3.5-turbo"); // // add latest message to conversation thread m_Message...
Type: Article
Author: Joel Lipman
Category: Zoho Other
Language: *
Zoho Workdrive: Getting Team Folder ID https://www.joellipman.com/articles/crm/zoho/zoho-workdrive/zoho-workdrive-getting-team-folder-id.html
11 September 2024
{ m_Attr = Map(); m_Attr.put("name", v_WorkingFolderName); m_Attr.put("parent_id", v_ParentFolderID); // m_Params = Map(); m_Params.put("attributes", m_Attr); m_Params.put("type", "files"); // m_Data = Map(); m_Data.put("data", m_Params);...
Type: Article
Author: Joel Lipman
Category: Zoho Workdrive
Language: *
Zoho Deluge: Using Remove Key on a Map and Copying Record Tags https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-using-remove-key-on-a-map.html
03 March 2025
m_Tag in m_ContactDetails.get("Tag") { m_Tag.remove("id"); l_Tags.add(m_Tag); } } info l_Tags; // if(l_Tags.size()>0) { m_Params = {"tags": l_Tags}; r_AddTags = invokeurl [ url :"https://www.zohoapis.com/crm/v7/Deals/" + p_DealID + "/actions/add_tags"...
Type: Article
Author: Joel Lipman
Category: Zoho Deluge
Language: *
Zoho Deluge - Get Refresh/Access Token API v2 https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-refresh-access-token.html
17 July 2019
v_State = "testing"; v_ResponseType = "code"; v_Access = "offline"; v_Prompt = "consent"; l_Params = List(); l_Params.add("scope=" + v_Scope); l_Params.add("client_id=" + v_ClientID); l_Params.add("state=" + v_State); l_Params.add("response_type=" +...
Type: Article
Author: Joel Lipman
Category: Zoho Deluge
Language: en-GB
Zoho CRM: Get Unique Values of a Text Field https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-get-unique-values-of-a-field.html
08 October 2021
// build up COQL query v_CoqlQuery = "select distinct Currency from Quotes where Subject!=''"; // // build up parameters m_Params = Map(); m_Params.put("select_query",v_CoqlQuery); // // invokeUrl r_Coql = invokeUrl [ url...
Type: Article
Author: Joel Lipman
Category: Zoho CRM
Language: *
ZohoBooks: Stripe Terminal Integration https://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-stripe-terminal-integration.html
16 March 2023
// // Create payment intent in Stripe v_PaymentIntentEndpoint = "https://api.stripe.com/v1/payment_intents"; m_Params = Map(); m_Params.put("amount",v_StripeAmount); m_Params.put("currency","gbp"); //m_Params.put("automatic_payment_methods[enabled]",...
Type: Article
Author: Joel Lipman
Category: Zoho Books
Language: *
ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM https://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html
05 December 2023
m_Data = Map(); m_Data.put("attributes",m_Attributes); m_Data.put("type","permissions"); m_Params = Map(); m_Params.put("data",m_Data); r_Permissions = invokeurl [ url :"https://www.zohoapis.eu/workdrive/api/v1/permissions" type :POST...
Type: Article
Author: Joel Lipman
Category: Zoho CRM
Language: *
Zoho People: Get Performance Records over API https://www.joellipman.com/articles/crm/zoho/zoho-people/zoho-people-get-performance-records-over-api.html
18 September 2025
= Map(); m_Header.put("ZANALYTICS-ORGID",v_AnalyticsOrgID); m_Columns = Map(); m_Columns.put("columns", m_OutputRecord); m_Params = Map(); m_Params.put("CONFIG", m_Columns.toString()); info m_OutputRecord; // // in analytics, browse to the target table...
Type: Article
Author: Joel Lipman
Category: Zoho People
Language: *
Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pages https://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html
25 September 2025
+ v_OwnerEmail + "/" + zoho.encryption.urlEncode(v_WorkspaceName) + "/" + zoho.encryption.urlEncode(v_ViewName); m_Params = Map(); m_Params.put("ZOHO_ACTION","EXPORT"); m_Params.put("ZOHO_OUTPUT_FORMAT","IMAGE");...
Type: Article
Author: Joel Lipman
Category: Zoho Analytics
Language: *