How to batch update "Proxy Address" value of 60+ NPrinting Connections?

[mwallman]

Hi there,

We have a situation in our US project where the "Proxy address" value of 60+ NPrinting Connections need updating to a new address.

E.g.

Old: QlikSenseDashboards.company.com

New: QlikSenseReports.company.com

We need to apply the new value to multiple Connections in NPrinting.

Is there a way to batch update all of them at once?

[Frank_S]

@mwallman 
I'm checking with R&D if they are updating our API library in the May 2021 release for this API call.
This batch functionality is not currently available in the NP gui at the moment.

[Lech_Miszkiewicz]

Tech Preview of May is available so you should be able to use it for testing of this API endpoint which seems to be available from May 2021:

https://betahelp.qlik.com/en-US/nprinting/May2021/APIs/NP+API/index.html?page=20#Connections

https://betahelp.qlik.com/en-US/nprinting/May2021/APIs/NP+API/index.html?page=20

Cheers

[Lech_Miszkiewicz]

or..... you may try not supported option by tapping into Postgresql using tools like pgAdmin and running query like below:

[This is not supported option by Qlik and you may damage your repository, so if you choose to do this you are doing it at your own risk!!! Before doing anything like this make sure you take backup and also switch off all but QlikNPrintingRepoService. I have tested this on my test environmnet and it worked as expected however I am not sure if there are any other tables which may need to be updated]

UPDATE
public.data_connection
SET
connection_string = REPLACE(connection_string,'https://QlikSenseDashboards.company.com/','https://QlikSenseReports.company.com/')
WHERE
connection_string like '%lQlikSenseDashboards.company.com%'

[Frank_S]

@mwallman 

As @Lech_Miszkiewicz mentioned, I have confirmed that the May 2021 NP public release is confirmed to have a new API that will be available to update a single connection however see comments from R&D

"The API for updating single connections will be available in May 2021 release - there will be no batch API but cycling thru connections should not be hard to automate."