Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Suggest an Idea

Announcements
This page is no longer in use. To suggest an idea, please visit Browse and Suggest.

NPRinting api using existing report with multiple connections

vanwerven
Contributor II
Contributor II

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. 

 

Please find a full previous discussions at : 

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

and  

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/REST-API-OnDemandRequest-Retrieve-charts-fr... 

Tags (1)
1 Comment
Andrew_Kruger
Employee
Employee

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

Status changed to: Closed - Declined