Assuming data is required, the following 216 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
- 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
- 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
- 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: *
-
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
- 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
- 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
- Language: *
-
T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html
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
-
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
- Language: *
-
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
- 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
- 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: Zoho
- 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
- Language: *
-
I tried the SQL Server Management Studio solution to connect to a MySQL database then lost my way wondering what was I trying to achieve? I've written this article because this is how I connected to a MySQL database from within the Business Intelligence...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- 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
-
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
-
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
- Language: *
-
Situation I have a Microsoft Excel 2007 file that connects to a SQL Server 2008 R2 database. The Excel file pulls data using lookup tables and displays the data in an Excel Spreadsheet. The Problem We can select all cells and set row height to be 30 for...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB