map a key
email = zoho.encryption.urlEncode("email ");
workspaceName = zoho.encryption.urlEncode("Book");
viewName = zoho.encryption.urlEncode("Stock_Sum");
paramsMap = Map();
paramsMap.put("ZOHO_ACTION","EXPORT");
paramsMap.put("ZOHO_OUTPUT_FORMAT","JSON");
paramsMap.put("ZOHO_ERROR_FORMAT","JSON");
paramsMap.put("ZOHO_API_VERSION","1.0");
hearmap = Map();
hearmap.put("Content-Type","application/json");
AnalyticsData = invokeurl
[
url :"https://analyticsapi.zoho.in/api/" + email + "/" + workspaceName + "/" + viewName
type :GET
parameters:paramsMap
headers:hearmap
connection:"ana"
];
data = AnalyticsData.get("response").getJSON("result");
data = data.get("rows");
//info data;
//ele.removeElement(ele.right(18));
aa = list();
for each ele in data
{
companyDetails = Map();
companyDetails.put("id",ele);
info companyDetails;
}
i am getting result like. how to map "SUM(Quantity)" & " ID"
i need this format
{"id":"68668000000033704","SUM(Quantity)":"-15832"},
but i am getting in other format
{"id":["-15832","68668000000033704"]}
{"id":["150","68668000024388216"]}