Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

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)" );

3 Replies
Highlighted
Employee
Employee

Hi Rich,

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



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.
Highlighted
Contributor III
Contributor III

Thanks @Ruggero_Piccoli.

So there's no more general API call to get all reports etc out from the system so I can analyse the whole setup of NP in Qlik.. I.e. who gets what reports, through which tasks etc...?

Do i need to connect to the postgres database for this type of info? It would be a good addition to the APIs so they're not only servicing on demand capability.

Hope you're doing well and Merry Christmas!

Rich

Highlighted
Employee
Employee

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 !