... m_Columns);
//
// in analytics, browse to the "Attachments" table and note the URL IDs after workspace and view
v_WorkspaceID = "123456000000123456";
v_TableID = "12345600000123457";
v_Endpoint ...
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? ...
... "id": "123456789000000123456789",
"type": "custom"
}
}
Tidied Up
Want that in a practical format for use in ZohoCreator? Preferably not in the Zoho order, but that of the normal wee ...
... ID which has to be unique as you may have many files called "image001.jpg" but for other records.
Parent Id: The CRM Record ID you are going to attach the file to (eg. "zcrm_123450000000000123456").
...
... this returns something like the following (I've reduced the 200 records to about 6 of them):
{
"data": [
{
"Currency": "EUR",
"id": "123456789000000001"
},
{
"Currency": ...
... Zoho CRM Invoices and noticed that Xero stores its dates in Unix Timestamps.
How?
We're going to filter out the unix seconds from the date provided by Xero then apply a toTime() function to it.
v_XeroTime="/Date(1586995200000+0000)/";
v_StartIndex ...
... r_Response;
// yields: }
info r_Response.get("item");
// yields: "item_id": "2124100000000081031", ....
info r_Response.get("item").get("item_id");
// yields: Value is empty and 'get' function cannot ...
... ID,Name,Phone,Record ID
1457102000000135533,Joel,00441234567890,1457102000000165989
1457102000000135566,Stanley,01709123456,1457102000000167543
1457102000000135608,David,00331234567890,1457102000000166795
My ...
What?
This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...
... and add funds to another:
$mysqli->query ("UPDATE 'accounts' SET 'balance' = 'balance'-1000000 WHERE 'user' = 'Bob'");
$mysqli->query ("UPDATE 'accounts' SET 'balance' = 'balance'+1000000 WHERE 'user' = 'Fred'");
What ...
... Capital International Airport 40°4′20″N 116°35′51″E 40 4 20 N 116 35 51 E 40.07222222 116.597500000 40.07222222 116.5975
Beijing Shahezhen Air Base ...
... be null) and in format DDMMYYYY:
-- Derived column task 1: Replace 'Date'
TRIM(Date) != "" ? TRIM(Date) : "00000000"
-- Derived column task 2: Add as new Column 'DC_Date'
-- (note this is a separate ...
...
For example:
rm_f1st('0','280','true','false','000000','3sv7MUqXeMI','true','ff0000');
or
The Unique ID code would be "3sv7MUqXeMI" (without the double-quotes)
How to do this without ...
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.