topic Calling Automation from Sense App using Selections in Qlik Automate

Calling Automation from Sense App using Selections

andreas_schoedlbauer — Wed, 27 Oct 2021 14:26:56 GMT

Hi all

given the following use case:

In a Qlik Sense Saas App users can select invoices and send these invoices to an ERP system to update status information. We use an automation calling the ERP system via API to post the selected invoices.

In the automation we use the "Get Straight Table Data" from the qlik cloud services but I do not know how to load only the selected 3 rows and not the whole table.

Any idea, how we can achieve that?

Thanks a lot, Andy

Re: Calling Automation from Sense App using Selections

PietMichielRappelet — Fri, 29 Oct 2021 09:31:07 GMT

Hi Andy

I believe this article will help you further:

It is important to understand that automation and the UI component do not share the same user session.

This results in the fact that an automation cannot get the 'active selection' from the UI and you need to do the selection you want by using the blocks 'select field value', 'select field value by query' or 'apply bookmark'.

Kind regards,

Re: Calling Automation from Sense App using Selections

andreas_schoedlbauer — Fri, 29 Oct 2021 09:42:08 GMT

Hi Piet

thanks a lot for that. There is another solution described here: https://community.qlik.com/t5/Qlik-Sense-Documents/Using-Qlik-Application-Automation-to-create-and-distribute-Excel/ta-p/1847184

But your way seems to be much easier.

Kind regards, Andi

Re: Calling Automation from Sense App using Selections

AdnanRafiq — Fri, 22 Apr 2022 22:06:43 GMT

Hi Andy,

did you try this solution or just found it? This solution is not working for me on Report generation.