NPRinting api using existing report with multiple connections
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.