Search - Joel Lipman .Com

1. 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
2. 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
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. Zoho Deluge - Counting in a Map dataType: / Zoho /; ... info m_ProductCount Yields: { "TEST001": 6, "TEST002": 1 } Counting total products per account: // // count total products per account m_Accounts = Map(); m_Products = Map(); // ...; Created on 02 September 2019
10. Zoho Deluge - Get Refresh/Access Token API v2: / Zoho /; ... does not redirect or reformat the resulting URL // // get Grant Token v_EndPoint = "https://accounts.zoho.com/oauth/v2/auth"; v_Scope = "ZohoBooks.contacts.ALL,ZohoBooks.invoices.ALL,ZohoBooks.purchaseorders.ALL"; v_State ...; Created on 17 July 2019
11. Zoho Deluge - Update Creator from CRM: / Zoho /; ... AuthToken: Browser Mode: Open a browser to https://accounts.zoho.com/apiauthtoken/create?SCOPE=ZohoCreator/creatorapi OR API Mode: https://accounts.zoho.com/apiauthtoken/nb/create?SCOPE=ZohoCreator/creatorapi&EMAIL_ID=&PASSWORD= ...; Created on 18 February 2019
12. GDPR Privacy Policy: / Static Items /; ... only with involvement of a parent or guardian. MYCOMPANY and its associates reserve the right to refuse service, terminate accounts, remove or edit content, or cancel orders in their sole discretion. REVIEWS, ...; Created on 14 February 2019
13. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... private key and token file Here you need to enter the relative or absolute path to your private key, this should be the JSON file that you generated at Google's developer console - service accounts section. ...; Created on 02 February 2019
14. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; ... updates) making it as generic as I can in order to apply it to any client. How? Firstly, you will need to browse to https://accounts.zoho.eu/developerconsole and register your new app (or the one ...; Created on 30 January 2019
15. Google Authentication - OAuth 2.0 using PHP/cURL: / Google /; ... // add in your other scopes as needed // generic $GAPIS = 'https://www.googleapis.com/'; $GAPIS_AUTH = $GAPIS . 'auth/'; $GOAUTH = 'https://accounts.google.com/o/oauth2/'; $REDIRECT_URI = 'http' . ...; Created on 31 October 2018
16. MySQL Transactions in PHP: / MySQL /; ... and add funds to another: $mysqli->query ("UPDATE 'accounts' SET 'balance' = 'balance'-1000000 WHERE 'user' = 'Bob'"); $mysqli->query ("UPDATE 'accounts' SET 'balance' = 'balance'+1000000 WHERE 'user' = 'Fred'"); What ...; Created on 14 December 2016
17. Windows Live Mail Error ID: 0x8DE00005: / Windows OS /; ... account when receiving mail or synchronising" in the account properties dialog. Add an account by selecting 'Accounts' tab and then clicking on 'Email' with the plus sign. Add your account ...; Created on 14 December 2016
18. Migrating from Joomla 2.5.x to 3.4.x: / Joomla /; ... Installer ID in these as well. Copy over users (but with disabled accounts): CHANGE the value of @v25_admin_id to the number (in my example "42") to the admin ID of your installer ID. -- ...; Created on 12 September 2015
19. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... by accounts which do not have access or which do not have the full Windows SDK (ie. access to the global assembly cache). The process of registering the driver etc can be avoided by using a setup program: Open ...; Created on 04 October 2013
20. Data Randomization Function in Oracle PL/SQL: / Oracle PL/SQL /; What? This article describes a function that will return random data based on a given value. The function intends to determine the data type and return data that is absolutely irrelevant to the original ...; Created on 22 August 2012