Search - Joel Lipman .Com

1. Zoho Analytics: Setup DataSource via FTP Connection: / Zoho /; ... client who wants to import data via FTP (SFTP - to be precise) and have this available to their Zoho apps. My aim(s) are: Setup recurring FTP connection. Make data readily available to ZohoCRM. ...; Created on 12 January 2022
2. Zoho Deluge: Setup an API Connection for InvokeURL: / Zoho /; ... details how to setup a connection to use in an invoke URL statement. Specifically for Zoho Books, Subscriptions or Inventory. Why? Setting up a connection avoids the hassle of having to generate ...; Created on 12 August 2020
3. mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connec: / MySQL /; ... "Data Export" using MySQL Workbench. This is not regarding the connection issue as I can connect to my database using MySQL Workbench (I have enabled the old authentication protocol). The error ONLY appears ...; Created on 28 July 2014
4. Connection Strings for SQL Server: / SQL Server /; Download Connectors from dev.MySQL.com MySQL Connector/Net Type: .NET Framework Class Library Usage: MySql.Data.MySqlClient.MySqlConnection Manufacturer: MySQL Standard Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Default ...; Created on 05 January 2011
5. Zoho Inventory: Enable Tracking using the API: / Zoho /; ... + v_BooksOrgID type :GET connection:"zinventory" ]; m_Accounts = Map(); if(!isnull(r_ChartOfAccounts.get("chartofaccounts"))) { for each r_Account in r_ChartOfAccounts.get("chartofaccounts") { m_Accounts.put(r_Account.get("account_name"),r_Account.get("account_id")); } } // // ...; Created on 04 May 2023
6. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... ZohoCRM webhook, because CRM webhooks run more reliably then the ones we have found in ZohoBooks and other Zoho Apps. Prerequisites: Setup a connection called "joel_books" that has the necessary scopes ...; Created on 27 April 2023
7. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... your connection has the scope to access both Organization details (ZohoCRM.org.READ is enough - perhaps optional) and access to Settings (ZohoCRM.settings.READ). I'm calling mine "mycrmconnection". r_OrgDetails ...; Created on 28 March 2023
8. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... + "/status/delivered?organization_id=" + v_BooksOrgID; r_ZohoShipmentUpdate = invokeurl [ url :v_EndpointUpdate type :POST connection:"ab_inventory" ]; inf ...; Created on 21 March 2023
9. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... the deluge code): Click on "Manage Connections" Click on Create Connection Select Service "Zoho OAuth" Give it a name, I'm calling mine "ChatGPT CRM" Untick "Use Credentials of Login User" Under ...; Created on 06 March 2023
10. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... going into how to generate an access token / connection from Zoho to eBay, that is documented in my article: Zoho Creator: Push to eBay Listings The megafunction So I'm going to call this function ...; Created on 01 March 2023
11. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... + v_FromTime + "&limit=50"; r_ChatDetails = invokeurl [ url: v_Endpoint type: GET connection: "ab_cliq" ]; // // let's build up the conversation thread if(!isnull(r_ChatDetails.get("data"))) { for ...; Created on 13 February 2023
12. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... Another single line text field Candidate x JobOpening Name: Mandatory name field that we will use so as to create unique records The connection Within any syntax editor of ZohoRecruit (where you ...; Created on 08 February 2023
13. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM template: / Zoho /; ... type :GET connection:"zcrm" ]; f_FileRequest.setParamName("file"); f_FileRequest.setFileName(r_QuoteDetails.get("Subject") + ".pdf"); // // get a greeting name ...; Created on 18 August 2022
14. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... sources below). Here's the code for our function; note it is within ZohoBooks and not ZohoInventory (moved) and the connection "zbooks" has a fullaccess scope: // // initialize v_PaymentMode = ...; Created on 17 August 2022
15. Zoho Inventory: Mark a package slip as delivered and shipped: / Zoho /; ... is triggered when a user ticks a decision box in Zoho Creator (on iPad displays as an on/off switch). My connection here called "jl_inventory" has the minimum required scopes: ZohoInventory.salesorders.READ ...; Created on 14 July 2022
16. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Deluge: / Zoho /; ... at the moment, and the endpoint will depend on your datacenter (eg. COM or EU), and lastly the connection "joel_books" is my connection to ZohoBooks: // // declare ID of item in Zoho Inventory v_InventoryId ...; Created on 21 June 2022
17. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... connection from Zoho Creator to Zoho Inventory 3 lines icon in the top-left of your Creator (in edit this application mode) Then go to Setup > Connections > Add Connection Select Zoho OAuth and specify ...; Created on 31 March 2022
18. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... £959.84 Total: £2,059.65 Not Used Case Fans 2 fans from the 3rd pack of the CoolMoon 120mm Crystal - - The Result: Monitor cable connections I need to practice what I preach: ...; Created on 12 March 2022
19. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... + v_CrmContactID + "/Attachments/" + r_Attachment.get("id"); r_Download = invokeurl [ url :v_AttachmentEndpoint type :GET connection:"ab_crm" ]; r_Download.setParamName("file"); r_CheckIfDocumentAlreadyExists ...; Created on 11 March 2022
20. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... form (I call mine "API Integration") ready with the following fields: Connection Name (Single Line) Dev ID (Single Line) Client ID (Single Line) Shop ID (Single Line) Client Secret (Single ...; Created on 14 February 2022