... will have the specific OrgID in the URL).
Click on "Add Action"
Give it the Action Name "Ask ChatGPT"
This action should "Answer a Question"
It should be answered by "Construct Answer by Fetching Data" ...
... let v_DealID = r_DealLookup.id;
let r_DealDetails = ZDK.Apps.CRM.Deals.fetchById(v_DealID);
// get Deal/Opportunity fields we need to refer to
var v_OppType = r_DealDetails.Type_of_Opportunity;
...
... fetch all payments against this customer in order of payment reference (oldest to most recent)
r_SearchResults = zoho.books.getRecords("customerpayments",v_BooksOrgID,m_SearchCriteria,"zbooks");
if(!isnull(r_SearchResults.get("customerpayments")))
{
l_SearchResults ...
... = ZDK.Apps.CRM.Contacts.fetchById(v_VendorContactID);
// get the email on this contact record
var v_ContactEmail = r_ContactDetails.Email;
// check it isn't blank
if (v_ContactEmail ...
... int p_ItemID (eBay Item ID)
Purpose: Fetches a line item transaction per item ID
Date Created: 2022-01-22 (Joellipman - Joel Lipman)
- Initial release
More Info:
...
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 ...
... these 2 functions beforehand, as there isn't much time between getting the Session ID, logging in, agreeing, and then running the second function to get the FetchToken.
So first, I need a functio ...
... fetch some XML and return it in JSON formatting as long as the XML is encoded in UTF-8.
// set headers for JSON file
// header('Content-Type: application/json'); // seems to cause 500 Internal Server ...
What?
So this is an article exploring how to convert UPPERCASE text into mixed case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it ...
What?
Somebody said I could pay to get an export list of my Joomla users. I said Joomla is a FREE OpenSource system, why?
Why?
I want to move a client's list of Joomla users to a new system which ...
... @UpdateSqlStatement, N'@UpdateCursor CURSOR OUTPUT', @UpdateCursor OUTPUT
SELECT @NumberLeft = SUM(1)
FROM #Scramble
FETCH NEXT FROM @UpdateCursor INTO @Data
WHILE @@FETCH_STATUS ...
... TABLE #CountRecordsPerTablePerCol
(myValue int, myTable varchar(max), myCount int);
-- Iterate through cursor1
OPEN Cursor1
FETCH NEXT FROM Cursor1 INTO @TableToProcess
...
... TABLE_SCHEMA='dbo'
ORDER BY TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME;
OPEN MyCursor
FETCH NEXT FROM MyCursor INTO @SqlToExecute
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT ' union all ' + @SqlToExecute;
...
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.