Search - Joel Lipman .Com

1. 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
2. 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
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. 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
17. 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
18. No rows returned in Oracle causes SP to fail: / Oracle PL/SQL /; ... where rownum/rowcount = 0). Consider the following: SELECT NVL(student_accounts.studentID, 0) INTO v_studentreference FROM ...; Created on 24 January 2012
19. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... (with an end!) BEGIN -- initial query to get me the student ID based on the inputted parameter SELECT student_accounts.student_id INTO p_STUDENT_REF FROM ...; Created on 19 January 2012
20. Basic Oracle Stored Procedure Structure: / Oracle PL/SQL /; ... ( c_test out sys_refcursor, p_STUDENT_ADNAME in varchar2 ) IS BEGIN OPEN c_test FOR SELECT * FROM student_accounts WHERE student_username = p_STUDENT_ADNAME; END; View the results? ...; Created on 16 January 2012