NPRinting api using existing report with multiple connections

vanwerven — Thu, 13 Apr 2023 16:17:32 GMT

Within the community I've asked for a solution on extracting filtered info from an existing Nprinting report . The Nprinting report to be used contains multiple charts from multiple ( Qlikview/qvw ) sources. The report does work correctly within the Nprinting module to be send as an unfiltered report to recipients .
My aim is to extract customer info for a specific customer : 'Overdue invoices' and 'Total amount sales/purchases' chart for the same customer.   (The info for overdue invoices was obtained from an other/different qlikview report than the "sales" qlikview report).
Retrieving both these charts from NPrinting by REST , will correctly apply my customer-filter to the first connector, but will NOT apply this to the second NPrinting chart info ; Info for all customers will be extracted unfiltered. My filter to be used for both charts are the same. (value passed through 'selections')
We can extract filtered info (filtered field is "CUSTOMER_ID" and Value = '1234'. ) but this will only be applied to the first connection string we could add within the OnDemand Value for "connectionId". The second NPrinting chart (that has other Source / ConnectionId) was passed unfiltered through my request.
{
    "type": "report",
    "config": {
        "reportId": "123-465",
        "outputFormat": "pdf"
    },
    "filters": {
        "initialBookmark": "",
        "additionalFilters ": []
    },
    "connectionId": "654-321",
    "selections": [
        {
            "fieldName": "CUSTOMER_ID",
            "selectedCount": 1,
            "selectedValues": [
                "1234"
            ],
            "isNumeric": false
        }
    ]
}

So my request is rather simple:

I was looking on a new REST API request to retrieve some 'already designed' Nprinting reports where the NPrinting report has multiple Qlikview sources/connections . The outcome should be filtered as at this moment this is only possible within one connection.

My work around is to design a rather huge new Qlikview qvw containing all info from all the different sources Nprinting uses.

Please find a full previous discussions at :

https://community.qlik.com/t5/crmsupport/casepage/issue-id/00050913/issue-guid/5003z00002ZiUoi/issue-provider/salesforce

and

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/REST-API-OnDemandRequest-Retrieve-charts-from-NPrinting-report/m-p/1966702#M36750

Re: NPRinting api using existing report with multiple connections - Status changed to: Closed - Declined

Andrew_Kruger — Mon, 19 Dec 2022 16:33:31 GMT

Thank you for the post - moving on-demand to multi-app is not on the roadmap.

idea Re: NPRinting api using existing report with multiple connections - Status changed to: Closed - Declined in Suggest an Idea

NPRinting api using existing report with multiple connections

Re: NPRinting api using existing report with multiple connections - Status changed to: Closed - Declined