How to Display Report Execution Time in SQL Server Reporting Services 2008 R2
So there are other articles out there but I was looking to display in milliseconds the execution time it took for a particular ...
... - Order Update
Trigger: Function executed when a webhook from Shopify is sent to ZohoCRM (Order Update)
Inputs: String crmAPIRequest
Outputs: String crmAPIResponse
Date Created: ...
... "Tickets" under "Module"
for the Rule Name, I called mine "Tickets - On Create or Edit"
Execute On: Create, Edit, Customer Reply
No Criteria
Under 4. Actions, I click on "All Actions" and select "Custom ...
... that key. I can't sit there entering one customer at a time. Even a loop would hit a statement execution limit.
Why?
My use-case is that I need this done over a dataset of 20k+ contact records ...
What?
This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records...
Why? ...
What?
Following on from my article: ZohoCRM: Get All eBay Active Listings, this is how to get all the orders from a client's eBay.
Why?
Our use-case is a data migration from eBay to a fresh instance ...
... Ask ChatGPT - Context Handler Function
Trigger: Function executed in ZIA chat when "Ask ChatGPT" button is clicked
Purpose: This will query the OpenAI ChatGPT API but at the same time retain ...
What?
Another one of these articles talking about getting all the active product listings from eBay for a specific client.
Why?
Our use-case scenario here is that we want to get an inventory ...
What?
An article on how I can query all the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well.
Why?
Because I need this ...
... Standalone function triggered on execute
Purpose: Loops through all candidates and creates records referring to the Candidate Ref and Job Opening
Date Created: 2023-02-02 (JoelLipman.com ...
... and payment date to appear on the invoice.
How?
This sounds rather straightforward, write a function that given an invoice, checks the customer payments and updates the custom fields. Executing ...
... quick parsing instruction to get the eBay photos; this snippet stores the URL of each picture in a list variable:
l_Pictures = x_MainNode.executeXPath("//Item/PictureDetails/PictureURL/text()").toXmlList();
/ ...
... Another REST API CRM function which generates an eBay Access Token for me
r_Response = getUrl("https://www.zohoapis.eu/crm/v2/functions/fn_ebay_getaccesstoken/actions/execute?auth_type=apikey&zapikey=1003.");
if(!isnull(r_Response.toMap().get("details")))
{
if(!isnull(r_Response.toMap().get("details").get("output")))
{
v_AccessToke ...
... *******************************************************************************
Function: fn_Validate_LeadStatusChange
Trigger: Function executed when a record is changed
Inputs: ...
... in mind script execution limits set by Zoho.
Set the search criteria string to your specific requirements (:equals:, :starts_with:, |=|). If 1 expression then you can omit the parenthesis. If multiple ...
... are zeros... But I'm keen on avoiding using loops where possible so we don't breach a statement execution limit in the Zoho app function.
How?
If we're not going to use loops, then the next best thing ...
What?
This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify.
Why?
Previously, we would receive an eBay notification and create an ...
... Reminder 1 Hr Before"
When is "On a Date/Time" based on "Call Start Time" with execution date "On" the date and execution time "1 hour before".
Condition 1: rule is applied to all calls
Action is the ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.