Assuming response is required, the following 90 results were found.
-
a group by to the query which works (tested with both the keyword 'distinct' and without it with no difference in the response): // // build up COQL query v_CoqlQuery = "select Currency from Quotes where Subject!='' group by Currency"; // // build up...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
with ID=0) retrieving 250 per call and using since_id to not list the same one twice. It then outputs a JSON list as a response and the total record count: void API.fn_ShopifyQuery_GetActiveProducts() { m_Header = Map();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
// m_MergedData = Map(); m_MergedData.put("merge_data", {"data":m_Data}); // // to generate and attach r_DownloadResponse = zoho.writer.mergeAndDownload("aaaabbbbccccddddeeeeffff000011112222333344445555", "pdf", m_MergedData, "joels_connector");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Instead, it's turned into over an hour of figuring this out. So here's a working snippet of code: // test to get the JSON response format r_CallDetails = zoho.crm.getRecordById("Calls",123456789012345678); info r_CallDetails; // // system/application is...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
m_Data.put("From",v_OurTwilioNumber); m_Data.put("To",v_CustomerNumber); // // JSON request r_TwilioResponse = invokeurl [ url :v_Endpoint type :POST parameters:m_Data ]; // // display to user/developer the response return r_TwilioResponse; Adapting it...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
This is an article to document how to use the searchRecords function in CRM and to sort the results response. Why? This is unclear and not always working as coded below since each system (CRM, Creator, Books) seems to interpret this sorting feature...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
allow you to change the lead status back to \"" + v_LeadStatus + "\""); m_Output.put("status","error"); } } // // return response return m_Output; Click "Save" and Done! Yields: Additional Note(s): If the user's profile is blank, the rule will not apply...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
r_GetProduct = invokeurl [ url :v_Endpoint type :POST parameters:m_GraphQl.toString() headers:m_Header ]; // // parse the response if(!isnull(r_GetProduct.get("data"))) { if(!isnull(r_GetProduct.get("data").get("productVariants"))) {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
// // send request and create record r_CreateMeeting = zoho.crm.createRecord("Events",m_ScheduleMeeting); // // output response (for debugging purposes) info r_CreateMeeting;
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
:v_Endpoint type :POST parameters:m_GraphQl.toString() headers:m_Header ]; //info r_GetProductVariants; // // parse the response if(r_GetProductVariants.get("data") != null) { if(r_GetProductVariants.get("data").get("productVariants") != null) {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
v_TotalNumberOfPages = l_Pages.size(); // // declare variables to store order details in a JSON or ZohoDeluge Map format m_Response = Map(); l_JsonProducts = List(); // // start preparing CSV file to email for export v_ReportCSV =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
it r_CreateItem = zoho.inventory.createRecord("items",v_BooksOrgID,m_CreateBooksItem,"zinventory"); info "ITEM CREATE RESPONSE FOR " + v_ItemID; info r_CreateItem.get("message"); Error(s) Encountered items with opening stock cannot be deleted, set the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
]; info "------------"; // info "Send Invoice Request:"; // info m_Params; // info v_Endpoint; // info "Send Invoice Response:"; info r_SendInvoice; } // // no need to mark as sent as sending via the above will automatically do that in ZohoBooks. } } }...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
// // create the task in CRM r_NewResp = zoho.crm.createRecord("Tasks",m_NewTask, m_Blank, "systemcrm"); // // output response of task creation from CRM info r_NewResp; Step 2: Setup workflow to escalate after 4 days: No code here necessary, this...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
= invokeurl [ url :v_Endpoint type :GET headers:m_Header connection:"my_connection" ]; //info r_Analytics; // // parse response if(r_Analytics.get("status") == "success") { m_ResponseData = ifnull(r_Analytics.get("data"),Map()); l_DataSources =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
// build up request to send m_Header = Map(); m_Header.put("ZANALYTICS-ORGID",v_ZA_OrgID); m_Params = Map(); m_Params.put("responseFormat","json"); // note how criteria column is denoted by double-quotes and a value is by single-quotes....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
How? The bit that stumped me was making a call to the Events endpoint as it would just come back with a blank response... The reason it was blank was due to my parameters; the key item to remember is that status is a mandatory field and it can either be...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
// // Send the Zoho Sign Template with the pre-filled fields to the desired recipient/ recipients r_SignResponse = zoho.sign.createUsingTemplate(v_TemplateID,m_Parameters); // info r_SignResponse; // // get request and document IDs r_SignTemplate =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
enable an option to round via API with a 10th of a penny/cent or less. After creating or updating the invoice, add in the response line something like the following: //... UPDATE INVOICE r_UpdateBooksInvoice =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
r_DealDetails = ZDK.Apps.CRM.Functions.execute("fn_Deals_RetrievePipeline", {"p_DealID": v_ThisRecordID}); // Parse the response to retrieve just the pipeline value (returned string) var v_DealPipeline = r_DealDetails._details.output; // set all tabs to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *