... can use the following code, note that the parameter is the eBay Item ID:
void API.fn_eBayQuery_GetItemTransaction(int p_ItemID)
{
/*
Function: fn_eBayQuery_GetItemTransaction()
Input: ...
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 ...
... *******************************************************************************
// Generate your access token to connect to Xero and query Xero records
// See my article: https://www.joellipman.com/articles/crm/zoho/zoho-deluge-sync-to-xero-api.html
//
v_TenantID ...
... sunday but we want to start counting from Monday 00:00
v_FirstDateOfWeek = zoho.currentdate.toStartOfWeek().addDay(1).toString("yyyy-MM-dd");
//
// build up COQL Query
v_CoqlQuery = ...
... Map datatype.
How?
I'm not going to go into detail on how I create an access token to query the eBay Trading API as you can read this in my article: Joellipman: Zoho Creator: Push to eBay Listings. ...
... It then outputs a JSON list as a response and the total record count:
void API.fn_ShopifyQuery_GetActiveProducts()
{
m_Header = Map();
m_Header.put("Content-Type","application/json");
//
// ...
... up a SQL query, or more specifically, a COQL - CRM Object Query Language
Try using distinct on a single-line text field
Adapt the query for unique values in a lookup field
I won't demonstrate ...
... notification preferences are setup. This one didn't tell me much first time I ran it but I can use it later on to check if my "setting the notifications" process worked.
void API.fn_eBayQuery_GetNotificationPreferences()
{
/*
...
What?
This is an article of code snippets to query a Zoho Bookings instance from within Creator. This one focuses on getting the available slots.
Why?
This is for a Creator app which had a form ...
... D = r_CreateCrmQuote.toMap().get("data").get(0).get("details").get("id");
}
}
}
Retrieving a record with 2.1 JSON
The following is a snippet when querying a CRM module (invoices) from a CRM functio ...
What?
This is an article documenting how to create a Zoho Creator Widget which includes the Bootstrap and jQuery frameworks as well as other JavaScript functionality.
Why?
Quite simply that at ...
... own version of Bootstrap and jQuery. This is the first example I have where you would want dynamic content in a Zoho Creator page without the use of JavaScript or 'Widgets JS'.
How?
Here are some ...
... I have found to work each time is using the CRM Object Query Language or Zoho's COQL. Similar to SQL but subject to similar issues of escaping special characters...
1. Setup a CRM Connection to Search ...
... URL: put our corporate website URL, this is for developers who need to query what this app belongs to or does. eg. "https://www.joellipman.com/"
Authorized Redirect URIs: for this put in one of the following ...
What?
This is an article to document how to output the most frequently used words in a MySQL database column.
How?
Note this only applies to MySQL.
So the following query will return a count ...
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.