Assuming read is required, the following 69 results were found.
-
type :POST parameters:m_Data.toString() connection:"myconnection" ]; or if converted to JSON, the request would read as: { "data": { "Subject": "My Test Quote", "Quoted_Items": [ { "Product_Name": "123456789012345678", "Quantity": 5, "Discount": 0,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
} Additional Note(s): Scope(s) required: for the connection I think it was ZohoBooks.settings.READ for the sales persons and then ZohoCRM.modules.all for the CRM sales orders.
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
every time we want to tweak the code. There are also cases we don't want to use a standalone function as we want the code to read from the input fields dynamically and in real-time. To this end, I create a field called "Audit_Change" and then I add to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
or https://books.zoho.com. You will also need your own CRM to Books connection name (joel_books) with scope to read settings: // our made up books org id but enter your own v_BooksOrgID=20210924095; // // get currencies m_Currencies = Map();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
one of the column values into the target How? So this is my plan: Setup a connector to CRM with the scopes ZohoCRM.coql.READ and ZohoCRM.modules.ALL Build up a SQL query, or more specifically, a COQL - CRM Object Query Language Try using distinct on a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
type :POST parameters:x_Params headers:m_Headers ]; // // output response info r_ResponseXML; /* // // if successful then read the response if(r_ResponseXML.contains("Success")) { // // parse the data v_MainNode = "Item"; x_MainNode =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
in Zoho Inventory and this feeds the website. More than often, however, this request comes in when the customer has already been setting their Zoho environment up and the Wordpress site has the more information. How? So first, this article shows you how...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
There are already articles out there that document this but I use this more and more and would rather just find it on my site than going through multiple bookmarks. Why? This use-case is for a customer who simply wanted a quote template to be rendered...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
but according to documentation (to be taken with a grain of salt), the scope should be ZohoInventory.settings.READ. I have another connection called "zinventory" which is used here to retrieve the item/product record. // // initialize m_Blank = Map();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
or if it is a subfolder, then use the team_subfolder_id Ensure the scope for your connection includes WorkDrive.teamfolders.READ and note that header has to be added otherwise you get a blank response: m_Header = Map();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Workdrive
- Language: *
-
this script can access it. The same goes for the access token, store it off the web but where this script can access it (read/write). // Location of private key on your server (JSON downloadable from Google) $api['keys']['private']['file'] = '.json'; //...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
bbq, barbecue, barbeque beer: beer, beers, Oktoberfest, October Fest, Octoberfest billiard: billiard bookclub: book club, reading bowling: bowling breakfast: breakfast, breakfasts, brunch, brunches camping: camping chinesenewyear: chinese new year,...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: *
-
on how to remove the first two entries from a RSS feed produced by a bunch of java files collectively known as "SimpleRssReader. Why? The original file reads of a feed from PCWorld.com. I adapted this to read a google news rss feed and the first two...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
and use depending on the situation. This is a quick article on how I got time conversion working in an SSIS package which read from a text file. Note that the example below converts a string in European Date Format (ie. "ddmmyyyy" to "dd/mm/yyyy")....
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
error I'd get was An error occurred during local report processing. An error has occurred during report processing. Cannot read the next data row for the dataset DataSet1. Conversion failed when converting date and/or time from character string....
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
join two tables and receiving the error "Conversion failed when converting the varchar value 'B110' to data type int" then read on. How? So where does the 'B110' string come from, well from one of our tables which looks similar to the following: Table:...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
2000-02-20 003 1.00 1999-02-25 003 1.00 1999-02-26 Some thing(s) to consider: User running the SQL query needs permission to read the master database. If run by a service account, ask a DBA to emulate the user for testing. the Items column may vary from...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
for everyone else is to change/reset the password of the connecting database user, but herein lies the problem. When you read my workaround, you'll say that I haven't solved anything; but this is a production database I want to export for offline...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
page on the site, the contents background disappears and reveals the overall background (blue) making the text very hard to read. Why? Took me a while to figure out what was the problem, I'd visit some pages and they'd be fine, but when visiting a long...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
characters. The Joomla! articles were displaying the correct characters for that language set. I needed to make my extension read data from a MySQL database and display the caracters as intended with UTF8. I tried enough extensions and forum solutions,...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB