Assuming isnull is required, the following 71 results were found.
-
= Map(); m_UserType.put("type","ActiveUsers"); r_Response = zoho.crm.invokeConnector("crm.getusers",m_UserType); if(!isnull(r_Response.get("status_code"))) { if(r_Response.get("status_code")==200) { l_Users = r_Response.get("response").get("users"); for...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// that v_CrmSoID is the matched ID of the Sales Order in CRM r_CreatorForm = myForm[ID == myRecordID]; if(!isnull(r_CreatorForm.Attachments)) { for each row in r_CreatorForm.Attachments { r_AttachFile = zoho.crm.attachFile("CustomModule5004",v_CrmSoID,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= r_WorkspaceResults.get("response").get("returnvalue").get("data"); for each r_Workspace in l_Workspaces { if(!isnull(r_Workspace.get("id"))) { v_WorkspaceName = r_Workspace.get("name"); } } Get the services: // // get services r_ServiceResults =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
1, 100, m_Criteria); // // loop through each contact record for each r_Contact in l_Contacts { v_Count = v_Count + 1; if(!isnull(r_Contact.get("Email"))) { v_Email = r_Contact.get("Email"); // // find all lead records matching this email l_Leads =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Booked","Lead Confirmed"}); // // capture event m_Webhook = crmAPIRequest.toMap(); // // check if user info is provided if(!isnull(m_Webhook.get("user_info"))) { // // extract user ID v_UserID = m_Webhook.get("user_info").get("id").toLong(); } // // if...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
r_CandidateDetails = zoho.recruit.getRecordById("Candidates",p_CandidateID,"zrecruit"); //info r_CandidateDetails; if(!isNull(r_CandidateDetails.get("Which School do you go to?"))) { v_SchoolName = r_CandidateDetails.get("Which School do you go to?");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
{ l_Shipments = r_ShipmentDetails.get("responseText").get("shipments"); for each r_Shipment in l_Shipments { if(!isnull(r_Shipment.get("status"))) { v_ShipmentStatus = r_Shipment.get("status").get("statusCode"); info v_ShipmentStatus; } } } // // return...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
for each m_RecordData in l_RecordData { // // apply changes to any of the line items l_NewLineItems = List(); if(!isNull(m_RecordData.get("id"))) { for each m_LineItem in m_RecordData.get("Quoted_Items") { m_NewLineItem = Map();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
[ url :"https://www.zohoapis.eu/crm/v2/settings/fields?module=Invoices" type :GET connection:"myzohoconnector" ]; if(!isnull(r_Fields.get("fields"))) { for each r_Field in r_Fields.get("fields") { l_FieldApiNames.add(r_Field.get("api_name")); } } // get...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
type :POST parameters:m_Params.toString() connection:"crm_api_v2" ]; // // retrieve results if(!isNull(r_Coql.get("info"))) { v_MatchedCount = ifnull(r_Coql.get("info").get("count"),0); } if(!isNull(r_Coql.get("data"))) { v_MatchedAccountID =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
webhook to a map m_Payload = crmAPIRequest.toMap(); // // get webhook signature v_ShopifySignature = "SIGNATURE_FAIL"; if(!isnull(m_Payload.get("headers"))) { if(!isnull(m_Payload.get("headers").get("x-shopify-hmac-sha256"))) { v_ShopifySignature =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
r_DealDetails = zoho.crm.getRecordById("Deals",v_DealID); // // Map users/owners division to this deal if(!isnull(r_DealDetails.get("Owner"))) { l_Users = zoho.crm.getRecordById("users",r_DealDetails.get("Owner").get("id")); for each r_UserDetails in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= 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
- Language: *
-
+ v_BooksOrgID type :GET connection:"zbooks" ]; m_NominalAccounts = Map(); if(!isnull(r_ChartOfAccounts.get("chartofaccounts"))) { for each m_NomAccount in r_ChartOfAccounts.get("chartofaccounts") {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
INVOICE r_UpdateBooksInvoice = zoho.books.updateRecord("invoices",v_BooksOrgID,v_ZohoBooksID,m_InvoiceData,"zbooks"); if(!isNull(r_UpdateBooksInvoice.get("invoice"))) { if(!isNull(r_UpdateBooksInvoice.get("invoice").get("invoice_id"))) { //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
DELETE FROM @SQLTbl WHERE WHEREClause IS NULL WHILE EXISTS (SELECT 1 FROM @SQLTbl WHERE ISNULL(Execstatus ,0) = 0) BEGIN SELECT TOP 1 @tmpTblname = Tablename , @sql = SQLStatement FROM @SQLTbl WHERE ISNULL(Execstatus ,0) = 0 IF @GenerateSQLOnly = 0...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
field to allow Image as "Link" not just "Local Computer" or "Camera"): for each r_Image in m_Product.get("images") { if(!isnull(r_Image.get("src"))) { if(isnull(v_MainPhoto)) { v_MainPhoto = "
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= Download_File[Owner_Email == v_ResultEmail && File_Ref == v_ThisFileCrmID]; if(r_CreatorFile.count()>0) { if(!isnull(r_CreatorFile.File_Download)) { v_LinkToDownload = v_CreatorBaseUrl + "/file" + zoho.appuri + "Download_File_Report/" +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
m_Create); // now take the ID that was created and use the following code to populate the multi-lookup field if(!isnull(r_Create.get("id"))) { m_Link = Map(); // using record IDs cos there's nothing better m_Link.put("Test",r_Create.get("id")); // using...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
mandatory fields have been entered) for example: // // check mandatory fields have been entered l_Errors = List(); if(isnull(input.Record_Name)) { l_Errors.add("- Record Name"); } if(l_Errors.size() > 0) { alert "Please enter the following required...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *