NPrinting report API - Can I get a full list of reports rather than only those enabled and on demand
Need someone to guide me re the report API. The documentation says this API "Gets the list of enabled and On-Demand enabled reports". This suggests that it will bring and/or sets of records so we should return those that are enabled but not On-Demand enabled.
My testing shows that it only returns On-Demand enabled reports, not those that are enabled but not On-Demand enabled which I'm trying to retrieve? Any ideas on how the below can be modified to do this?
RestReportsMasterTable: SQL SELECT "__KEY_data", (SELECT "outputFormats", "created", "lastUpdate", "description", "entityId", "id", "title", "type", "__FK_items" FROM "items" FK "__FK_items") FROM JSON (wrap off) "data" PK "__KEY_data" WITH CONNECTION( URL "https://$(vNPServerName):4993/api/v1/reports?limit=$(vLimit)", HTTPHEADER "cookie" "$(vCookie)" );
Yes, the API call returns the list of only the API and On-Demand enabled reports, not all enabled reports. Only the reports with the check box "Enable On-Demand and API report generation" flagged.
Best Regards, Ruggero --------------------------------------------- When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
Hi Richard- yes for now an ODBC connection to postgres would be the only way to do this. Its essentially what the web console does when it displays a list of reports to an admin on the reports tab. There are a few samples of 'governance dashboards' in nprinting that use odbc/postgres to pull the information and display in a qlik app. if you feel like sharing what you develop , so much the better for the community !