Appneta API to CSV Export via Javascript Bookmarks - Licensing and Monitoring Point Information
Article ID: 250723
Updated On:
Products
Issue/Introduction
Export Organization's Licensing and Monitoring Point data to CSV through Appneta API
Resolution
1. Open and login into your Appneta Portal.
2. While tab to Appneta Portal is open, Create (see below on instructions) and Open Bookmark
Example: javascript:{code from examples below goes here}:
Export Licensing Data to CSV:
javascript:function JSONToCSVConvertor(JSONData, ReportTitle, ShowLabel) {var arrData = typeof JSONData != 'object' ? JSON.parse(JSONData) : JSONData;var CSV = %27%27;CSV += ReportTitle + %27\r\n\n%27;if (ShowLabel) {var row = "";for (var index in arrData[0]) {row += index + %27,%27;}row = row.slice(0, -1);CSV += row + %27\r\n%27;}for (var i = 0; i < arrData.length; i++) {var row = "";for (var index in arrData[i]) {row += %27"%27 + arrData[i][index] + %27",%27;}row.slice(0, row.length - 1);CSV += row + %27\r\n%27;}if (CSV == %27%27) {alert("Invalid data");return;}var fileName = "LicExp_";fileName += ReportTitle.replace(/ /g, "_");var uri = %27data:text/csv;charset=utf-8,%27 + escape(CSV);var link = document.createElement("a");link.href = uri;link.style = "visibility:hidden";link.download = fileName + ".csv";document.body.appendChild(link);link.click();document.body.removeChild(link);}function getTheDate() {var timestamp = new Date(Date.now()).getTime();var todate = new Date(timestamp).getDate();var tomonth = new Date(timestamp).getMonth() + 1;var toyear = new Date(timestamp).getFullYear();var original_date = tomonth + %27_%27 + todate + %27_%27 + toyear;return original_date;}function promptForOrgId() {var orgId = prompt("(optional) Enter an Org ID", "");var oid_param = "";if (orgId != null) {oid_param = "orgId=" + orgId;}var lic_data = "";var foo = $.get("/api/v3/license?" + oid_param + "&api_key=v3&includeLegacy=true/", {}).done(function(data) {JSONToCSVConvertor(JSON.stringify(data), window.location.host + "_" + getTheDate() + "_license_export", true);});}promptForOrgId();
Export Monitoring Point Data to CSV:
javascript:function JSONToCSVConvertor(JSONData, ReportTitle, ShowLabel) { var arrData = typeof JSONData != 'object' ? JSON.parse(JSONData) : JSONData; var CSV = %27%27; CSV += ReportTitle + %27\r\n\n%27; if (ShowLabel) { var row = ""; for (var index in arrData[0]) { row += index + %27,%27; } row = row.slice(0, -1); CSV += row + %27\r\n%27; } for (var i = 0; i < arrData.length; i++) { var row = ""; for (var index in arrData[i]) { row += %27"%27 + arrData[i][index] + %27",%27; } row.slice(0, row.length - 1); CSV += row + %27\r\n%27; } if (CSV == %27%27) { alert("Invalid data"); return; } var fileName = "LicExp_"; fileName += ReportTitle.replace(/ /g, "_"); var uri = %27data:text/csv;charset=utf-8,%27 + escape(CSV); var link = document.createElement("a"); link.href = uri; link.style = "visibility:hidden"; link.download = fileName + ".csv"; document.body.appendChild(link); link.click(); document.body.removeChild(link); } function getTheDate() { var timestamp = new Date(Date.now()).getTime(); var todate = new Date(timestamp).getDate(); var tomonth = new Date(timestamp).getMonth() + 1; var toyear = new Date(timestamp).getFullYear(); var original_date = tomonth + %27_%27 + todate + %27_%27 + toyear; return original_date; } function downloadMPExport() { var orgId = prompt("(optional) Enter an Org ID", ""); var oid_param = ""; if (orgId != null) { oid_param = "&orgId=" + orgId; } var lic_data = ""; var foo = $.get("/api/v3/appliance?api_key=v3" + oid_param, {}).done(function(data) { JSONToCSVConvertor(JSON.stringify(data), window.location.host + "_" + getTheDate(), true); }); } downloadMPExport();
3. When prompted for OrgID Press OK to pull all data from Parent Organization. Specify Org ID if pulling from particular child org..
4. File should download exporting data to CSV
Additional Information
When Exporting Licensing data, expiration date is in UNIX Time. Use the below formula to convert Unix time to Date time:
=M4/86400000+DATE(1970,1,1)
Feedback
