/////////////// Inserting Record into Middle Table /////// importList = List(); for each id in uniqueIDs { if(!isNull(id)) { rowMap = Map(); rowMap.put("Unique String",id); rowMap.put("Invoice ID",invoiceID); importList.add(rowMap); } } //////////////////////////////////////////////////////////////// viewName2 = "Invoices Centre Table"; paramsMap = Map(); paramsMap.put("ZOHO_ACTION","IMPORT"); paramsMap.put("ZOHO_OUTPUT_FORMAT","JSON"); paramsMap.put("ZOHO_ERROR_FORMAT","JSON"); paramsMap.put("ZOHO_API_VERSION","1.0"); //========================================= //ACTION SPECIFIC PARAMS paramsMap.put("ZOHO_IMPORT_DATA",importList); paramsMap.put("ZOHO_IMPORT_FILETYPE","JSON"); paramsMap.put("ZOHO_IMPORT_TYPE","UPDATEADD"); paramsMap.put("ZOHO_AUTO_IDENTIFY","TRUE"); paramsMap.put("ZOHO_ON_IMPORT_ERROR","SKIPROW"); paramsMap.put("ZOHO_CREATE_TABLE","false"); paramsMap.put("ZOHO_MATCHING_COLUMNS","Unique String"); // ========================================== importInvoicedItems = invokeurl [ url :"https://analytics.zoho.com//api/" + encodeUrl(email) + "/" + encodeUrl(workspaceName) + "/" + encodeUrl(viewName2) + "" type :POST parameters:paramsMap connection:"zoho_apps_connection" ]; info "Adding to Middle Table: " + importInvoicedItems;
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