Assuming isnull is required, the following 77 results were found.
-
" + v_GoalKey; // m_ThisGoal = m_GoalRecord.get(v_GoalKey).get(0).toMap(); //info "Goal Record Data: " + m_ThisGoal; if(!isNull(m_ThisGoal.get("Zoho_ID"))) { m_OutputRecord = Map(); m_OutputRecord.put("Record Index", v_CountTotal); for each v_Field in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
{ l_Deals = zoho.crm.getRecords("Deals", v_Page, v_PerPage, {"cvid":123456000012345678}); for each m_Deal in l_Deals { if(!isNull(m_Deal.get("id"))) { v_CountTotal = v_CountTotal + 1; if(m_Deal.get("Stage").equalsIgnoreCase("Cancelled")) { // // cancel...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
SET @StringInput = RTRIM(LTRIM(@StringInput)) WHILE LEN(@StringInput) > 0 BEGIN SET @StringValue = LEFT(@StringInput, ISNULL(NULLIF(CHARINDEX(' ', @StringInput) - 1, -1), LEN(@StringInput))) SET @StringInput = SUBSTRING(@StringInput,...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
= 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: *
-
m_ExistingImage in l_ExistingImagesData { for each m_UploadedImage in m_ExistingImage.get(v_ImageUploadFieldName) { if(!isNull(m_UploadedImage.get("id"))) { m_DeleteImg = Map(); m_DeleteImg.put("id",m_UploadedImage.get("id"));...
- 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: *
-
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: *
-
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: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF