Assuming accounts is required, the following 39 results were found.
-
procedure to return no rows without erroring (ie. where rownum/rowcount = 0). Consider the following: SELECT NVL(student_accounts.studentID, 0) INTO v_studentreference FROM student_accounts WHERE student_accounts.studentUsername =...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
into this field. 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 datacenter:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// can be any endpoint that 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 =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
Yields: { "TEST001": 6, "TEST002": 1 } Counting total products per account: // // count total products per account m_Accounts = Map(); m_Products = Map(); // // loop through each row for each r_StockRecord in Stock_Upload[ID != 0] { // // create map...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
and pass the record ID via a button to it, I'm adding it here in case I need to refer to it in future. Why? We have an Accounts module which holds all the companies we deal with in our Zoho CRM. I want our sales team to be able to click on a button off...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Zoho Apps. Prerequisites: Setup a connection called "joel_books" that has the necessary scopes 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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
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=" + v_BooksOrgID...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
from my previous article ZohoCRM & Xero: Function to pull most recent invoices - along with their Contacts and Items (accounts/contact & products respectively). Why? This took me so much longer than I thought it would. It was meant to be based on the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
only one open parameter, the OR clause just compares against the same parameter. So for example: Instead of... (student_accounts.student_name=@StudentName or student_accounts.student_id=@StudentID) I set this to......
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
errors (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 student_accounts WHERE student_accounts.student_username = p_STUDENT_ADNAME; -- opening...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
) ) AS "Status" FROM "Accounts" ORDER BY "Modified Time" DESC /**** Pseudo: Select Modified Time of Record If Modified Time is greater than yesterday's date (today) Use URL of the image representing OK Else If Modified Time is greater than 5 days ago...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
when I get this request again. The additional benefit of having this template is that it includes creating contacts, accounts, and products on-the-fly as well as recording payments and checks as to which record is more up to date between ZohoCRM and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
this was never meant to work in the first place. When did the connection last work? Within ZohoBooks > Banking > Active Accounts > Account > Filter by "Matched Transactions" Bank Issue: Check with client which bank they use, type in the "Search" when...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
server space - expected size of website including all uploaded files. Add domain folder to the server. Setup FTP Accounts (just one username/password). Setup automated backup system. Create test space with same access details. Database Setup For...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
I recently made a joomla module that displays the lastest members to signup. It goes a little further and counts activated accounts for the past day, week, month and year (the below examples count all accounts irrespective of being activated or not). It...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
you should run the respective commands to update the 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. --...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
"Success" } Method #2: Using API v1 (using JSON not XML) Generate AuthToken: Browser Mode: Open a browser to https://accounts.zoho.com/apiauthtoken/create?SCOPE=ZohoCreator/creatorapi OR API Mode:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
type the value in the 2nd column "App to Run" then OK to run it: Settings Page App to Run Settings Homepage ms-settings: Accounts Access work or school ms-settings:workplace Email & app accounts ms-settings:emailandaccounts Family & other people...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
for latest endpoint) v_Endpoint = "https://" + v_Account_SID + ":" + v_Auth_Token + "@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);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
to get your Client ID and Client Secret. (Login as the client super admin or ascentcloud 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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF