Assuming data is required, the following 229 results were found.
-
// // send to CRM l_RecordsToSend = List(); l_RecordsToSend.add(m_CreateQuote); m_Data = Map(); m_Data.put("data", l_RecordsToSend); // // this is REST API so by default all triggers run. Use an empty list to stop or prevent these from triggering....
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
window"); This will open a page for you with a Zoho Consent form where you confirm whether your app is allowed to access the data within the specified scope(s). If you run this as a standalone, then this will simply tell you what the link is to go to....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
"zworkdrive" which has the scopes as specified in the function header. Also note, that this Zoho instance is in the EU datacenter (zoho.eu) rather than the US datacenter. The most important tweak in order for the below to work, is to add a file upload...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
based on the results from a survey. Apparently this will be done in Zoho Analytics. The Brief: We would like the survey data to be generated as a chart and embedded in a PDF brochure we send out to our customers... How? Well fulfilling the brief...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
This is a stored procedure I've nabbed from some consultants from my day job. It shuffles the records and matching data values: Before: ID Name DateOfBirth --------- ------------ ----------- 1 John Smith 1988-06-24 2 Fred Bloggs 1972-11-17 3 Another...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
Review and Placement Tech Survey having been disabled)... How? So this might seem obvious but after trying to scan the meta data (snippets at the bottom of this article), the simplest way was right in front of us. We're going to use the interface to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
only covered the USA, this one I wrote covers the world and can be added to really easily. It works by reading the weather data from api.openweathermap.org and the flight restriction details from api.joellipman.com (my own personal website). This allows...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
Recruit. Why? We're creating a custom module where our client wants to query Zoho Recruit via the API but couldn't find a database table to determine who has been associated to what job. In Zoho Recruit reports (Analytics), you can include the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Recruit
- Language: *
-
using the integration. Other tables will sync but we couldn't find attachments, so our solution here is to create a data table and then to push the attachment from ZohoDesk to ZohoAnalytics using the API. The use-case here is that a client wants...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Desk
- Language: *
-
type :GET headers:m_Header connection:"my_workdrive_connection" ]; if(!isNull(r_Subfolders.get("data"))) { for each m_Subfolder in r_Subfolders.get("data") { if(!isNull(m_Subfolder.get("attributes"))) {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Workdrive
- Language: *
-
a for loop. I have a map with 3 columns: first_name, last_name, and ID. What I want is a HTML table now with the headers and data but without using a for loop. What I have:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
would you want to do that?". Anyway, I was looking for something like the record separator in Oracle SQL*Plus where a row of data (blank or made of symbols) separates two sets of data from within the same select query based on a column that's different....
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
on from the article: Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo. This is the next step as we get it to look at data within ZohoCRM. Why? Because it is a serious improvement upon ZohoZIA and we get a lot of requests around customizing ZohoZIA......
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Hmm... I was writing a stored procedure that will scramble data given a table as a parameter. Because I only want to update a temporary table and not the original (source) table, I needed the following stored procedure (or part of). What? This will copy...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
" + v_StripeCustomerKey); // // capture response webhook m_Webhook = Map(); m_Webhook.put("data",body.get("data")); m_Webhook.put("type",body.get("type")); // // Check Type m_Data = ifnull(m_Webhook.get("data"),m_Blank); v_Type =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
out of whack and some records would slip through the net while every day, the process to tidy these all up would leave the data more and more unreliable. So Shopify want your webhooks to respond within 1 second. This is about enough time to store the...
- Type: Article
- Author: Joel Lipman
- Category: Shopify
- Language: *
-
The key trick to use here the ability for Zoho Analytics to display different images based on a criteria or a value within a data table. As documented in an earlier article, put the URL of the image, then change it's format to show the image and not the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
+ p_QuoteID; r_QuoteDetails = invokeurl [ url :v_Endpoint type :GET connection:"zcrm" ]; l_RecordData = ifnull(r_QuoteDetails.get("data"),List()); for each m_RecordData in l_RecordData { // // apply changes to any of the line items l_NewLineItems =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
This is a quick article to remind me on how to skip blank rows when using a Flat file as a data source. I would receive another Microsoft error as clear as mud: Error: The conditional operation failed. Error: SSIS Error Code...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
time taken for each one. The breakdown or what I was able to measure with the default installation are the times taken for "data retrieval", "processing", "rendering", and then the totals of these. I haven't Googled this at the time of print so there...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB