Deal_Details = zoho.crm.getRecordById("Deals",deal_id); Deal_Name = Deal_Details.get("Deal_Name"); Deal_Number = Deal_Details.get("Deal_Number"); //===================================================================================// searchParam = {"reference_number":Deal_Number}; related_purchase_orders = zoho.books.getRecords("purchaseorders","689149759",searchParam); info related_purchase_orders; count = 0; Total_of_all = 0.0; if(related_purchase_orders.get("purchaseorders").size() > 0) { responseXML = "<record>"; for each purchase_order in related_purchase_orders.get("purchaseorders") { purchaseorder_number = purchase_order.get("purchaseorder_number"); created_date = purchase_order.get("date"); status = purchase_order.get("status"); vendor_name = purchase_order.get("vendor_name"); total = purchase_order.get("total"); Total_of_all = Total_of_all + total; po_id = purchase_order.get("purchaseorder_id"); html = "<a href='www.google.com'>click here</a>"; //===================================================================================// responseXML = responseXML + "<row no='" + count + "'>"; responseXML = responseXML + "<FL val='PO Number'>" + purchaseorder_number + "</FL>"; responseXML = responseXML + "<FL val='Status'>" + status.proper() + "</FL>"; responseXML = responseXML + "<FL val='Vendor'>" + vendor_name.replaceAll("[\"#%&+;<=>\[\]^`(){}|~]","") + "</FL>"; responseXML = responseXML + "<FL val='Total'>$ " + total + "</FL>"; responseXML = responseXML + "<FL val='Created Date'>" + created_date + "</FL>"; // responseXML = responseXML + "<FL val='PO Link'>https://books.zoho.com/app#/purchaseorders/" + po_id + "</FL>"; responseXML = responseXML + "<FL val='PO Link' link='true' url='https://books.zoho.com/app#/purchaseorders/" + po_id + "'>Open</FL>"; responseXML = responseXML + "</row>"; count = count + 1; } responseXML = responseXML + "</record>"; } else { responseXML = ""; responseXML = responseXML + "<record><error>=><message>There are no POs found against this Deal!</message></error></record>"; } return responseXML;
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter