/////////////// 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;