... = zoho.crm.getRecordById("Calls",123456789012345678);
info r_CallDetails;
//
// system/application is set to EST (America/New_York)
v_SystemCallTime = '2021-11-19 11:12:34';
//
// manual setting to ...
What?
This is an article to document a function used in Zoho Creator to retrieve the Product IDs of all the active products in a client's eBay store.
Why?
The use-case was that I wanted to retrieve ...
... - 1);
}
//
// output
info "[" + l_ProductIDs + "]";
info l_ProductIDs.size();
}
Yields something like:
[
1234567890123,
2345678901234
]
2
Well that produces a lot of ID numbers ...
... this returns something like the following (I've reduced the 200 records to about 6 of them):
{
"data": [
{
"Currency": "EUR",
"id": "123456789000000001"
},
{
"Currency": ...
... photo to CRM:
// init
v_AppOwner = "joel_the_awesomest";
v_AppName = "joels_app";
v_ReportName = "My_Report";
// specify your CRM record ID for this product
v_CrmProductID = 1234567890123456789;
// ...
... m_Currencies;
//
// get Books ID for a currency from an CRM account record
r_AccountDetails = zoho.crm.getRecordByID("Accounts", 9012345678901234567);
v_BooksCurrencyID = m_Currencies.get(ifnull(r_AccountDetails.get("Currency"),"GBP"));
info ...
... the following request to create a Sales Order in Zoho Books would be enough:
{
"date": "2021-09-08",
"zcrm_potential_id": "123456789012345678",
"currency_code": "GBP",
"reference_number": "Salespersons ...
... "v_Filter" appears to do absolutely nothing but I've left it in there in case one day I figure it out:
// init
m_CreateSO = Map();
v_SalesPersonID = "";
//
// eval
v_BooksOrgID = 12345678901;
r_SoDetails ...
...
You would think the following would work:
r_Details = myForm[ID == 1234567890123456789];
r_Details.Account = input.Account;
But it will return the above error.
You need to do the following:
r_Details ...
... // using record IDs cos there's nothing better
m_Link.put("Joel",123456789012345678);
// create link
r_Link = zoho.crm.createRecord("Tests_X_Contacts", m_Link);
}
Code to Add ...
... response somewhat similar to the following:
// this is sample JSON with replaced IDs
"My_CRM_File": [
{
"extn": "pdf",
"is_Preview_Available": true,
"download_Url": "/crm/org12345678901/specific/ViewAttachment?fileId=aaaabbbbccccddddeeeeffff1111222233334&module=CustomModule1&parentId=123456789012345678&creatorId=987654321098765432&id=234567890123456789&name=dummy1.pdf&downLoadMode=default",
...
... through the record variable
r_LeadDetails = Leads[ID == 1234567890];
r_LeadDetails..insert( );
Events I have used this task which contradicts documentation:
In a custom function
In an Action ...
... = row.Upload_File; // looping through rows here but it wants the internal name here eg. "1234567890123_temp.pdf"
//
// build the URL
l_BuildUrl = List:String();
l_BuildUrl.add(v_CreatorDownloadBase);
l_BuildUrl.add(v_AppOwnerName);
l_BuildUrl.add(v_AppLinkName);
l_BuildUrl.add(v_ViewLinkName);
l_BuildUrl.add(v_CreatorRecordID);
l_BuildUrl.add(v_SubFormName ...
... be applied
Solution: I have to convert the node into a map:
info m_Response.get("item").toMap().get("item_id");
// yields: 123456789012345678
Problem: Inserting a date time string into a date ...
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.