Search - Joel Lipman .Com

1. Stored Procedure to List Distinct Values and Counts: / Transact-SQL /; ... columns. How? IF OBJECT_ID('usp_ListDistinctValuesAndCounts', 'P') IS NOT NULL DROP PROCEDURE [usp_ListDistinctValuesAndCounts]; GO CREATE PROCEDURE [usp_ListDistinctValuesAndCounts] ( ...; Created on 26 October 2012
2. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; ... statements; this is not true as the following counts 3 statements executed prior to the loop: // l_LoopInnerInner = " ".leftpad(5000); l_LoopInner = l_LoopInnerInner.replaceAll(" ", ","); l_Loop ...; Created on 31 July 2024
3. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... 'https://analytics.zoho.eu/clientapi/imageLibrary/fetchImage?ZDBFILEID=12345000034567890&ZSOID=20240725001' ) ) AS "Status" FROM "Accounts" ORDER BY "Modified Time" DESC /**** Pseudo: Select Modified ...; Created on 25 July 2024
4. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; ... Type is "Page Event" Event is "onLoad" Click "Next" Method 1 This includes a function which counts the number of decimals. I didn't need to use this method for my client; just rounding the decimals ...; Created on 13 December 2023
5. Zoho Books: System Values Maps: / Zoho /; ... Map fn_GetSystemValues() Trigger: Snippet to be used at beginning of code to get dynamic maps of system values Purpose: Taxes, Currencies, Payment Terms, Sales Persons, and Nominal Accounts Inputs: ...; Created on 07 November 2023
6. Zoho Inventory: Enable Tracking using the API: / Zoho /; ... enabled. But to flesh that out a little more along with setting the other options under "Advanced Tracking" // // get chart of accounts to use r_ChartOfAccounts = invokeurl [ url :"https://books.zoho.eu/api/v3/chartofaccounts?organization_id=" ...; Created on 04 May 2023
7. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... to view taxes and chart of accounts Setup a connection called "joel_inventory" that has the necessary scopes to do everything under the sun Setup a function that generates an access token of the Trading ...; Created on 27 April 2023
8. ZohoBooks: Stripe Terminal Integration: / Zoho /; ... create payment record if(v_ZB_InvoiceID != 0) { // // get ZohoBooks nominal account for Stripe v_NominalAccountID = ""; r_ChartOfAccounts = invokeurl [ url :"https://www.zohoapis.com/books/v3/chartofaccounts?organization_id=" ...; Created on 16 March 2023
9. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... ales Person", if_null(sp."Sales Person ID", if_null(i."Sales Person ID", if_null(so."Sales Person ID", if_null(e."Sales Person ID", '-')))) AS "Sales Person ID" FROM "Customers" c LEFT JOIN "Accounts" ...; Created on 03 November 2022
10. Zoho Recruit: Rollup Number of Recruit Candidates to CRM Account: / Zoho /; ... = zoho.crm.searchRecords("Accounts","Account_Name:equals:" + v_SchoolName,1,10,m_Blank,"zcrm"); for each r_School in l_SchoolSearch { // check no search error and valid records are returned if(!isnull(r_School.get("id"))) { // ...; Created on 19 October 2022
11. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; ... admin account) Log in to https://accounts.zoho.com/developerconsole Click on Add Client ID Select "Self Client" Provide the details and register your application Upon successful authentication, ...; Created on 17 October 2022
12. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... Admin API scopes": This will be dependent on what your app needs to do. In this example, mine needs to sync orders, products, customers, and some reports; the other things like discounts, fulfillment ...; Created on 14 February 2022
13. Zoho CRM: searchRecords with sorted results: / Zoho /; ... loop through all pages for each v_Page in l_Pages { r_SearchResults = zoho.crm.getRecords("Accounts",v_Page, v_PerPage, m_SortCriteria); // loop through all results per page for each r_Result i ...; Created on 10 February 2022
14. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense): / Zoho /; ... + "@api.twilio.com/2010-04-01/Accounts/" + v_Account_SID + "/Messages.json"; // // build up the JSON request m_Data = Map(); m_Data.put("Body",v_Message); m_Data.put("From",v_OurTwilioNumber); m_Data.put("To",v_CustomerNumber); // // ...; Created on 16 December 2021
15. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; What? A quick article to demonstrate code that creates a task in CRM based on the time logged against an Event/Meeting. Why? As developers, we're keep account of our time and we are currently ...; Created on 02 December 2021
16. Zoho CRM & Zoho Books: Get Books Currency and Tax IDs: / Zoho /; ... m_Currencies; // // get Books ID for a currency from an CRM account record r_AccountDetails = zoho.crm.getRecordByID("Accounts", 9012345678901234567); v_BooksCurrencyID = m_Currencies.get(ifnull(r_AccountDetails.get("Currency"),"GBP")); info ...; Created on 24 September 2021
17. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... ampersand with unicode value v_SearchName = v_SearchName.replaceAll("&","\u0026",true); // // build up COQL query v_CoqlQuery = "select id from Accounts where Name='" + v_SearchName + "'"; // // build ...; Created on 28 August 2020
18. Zoho Deluge: Setup an API Connection for InvokeURL: / Zoho /; ... Authorize URL: Enter the Zoho authentication URL based on the client's datacenter: US datacenter: https://accounts.zoho.com/oauth/v2/auth EU datacenter: https://accounts.zoho.eu/oauth/v2/auth CN ...; Created on 12 August 2020
19. Windows 10: Shortcut Apps to Settings: / Windows OS /; ... tbody tr:nth-child(even) Settings PageApp to Run Settings Homepage ms-settings: Accounts Access work or school ms-settings:workplace Email & app accounts ms-settings:emailandaccounts ...; Created on 30 July 2020
20. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... perform this operation This is a quick issue to resolve as it may be incorrect scopes specified but in my case is more than often the wrong accounts server: v_DataEndpoint = "https://books.zoho.com/api/v3/contacts?organization_id=123456789"; r_Response ...; Created on 06 February 2020