Qlik Application Automation:Verify load script in Qlik Sense app from new GitHub pull request

AfeefaTk · Aug 4, 2022 4:36:57 AM

This article gives an overview of verifying the load script of the Qlik Sense app from new Github pull request using Qlik Application Automation. It explains a basic example of a template configured in Qlik Application Automation for this scenario

You can make use of the template which is already available in the template picker

You can find it by navigating to Add new -> New automation -> Search templates and search for 'Verify load script in Qlik Sense app from new GitHub pull request' in the search bar and click on the Use template option in order to use it in the automation

Environment

Before you begin, you'll need the following:

Qlik Sense app in a shared space
GitHub repository with a copy of the shared app's load script as a text file

Steps:

The following steps describe how to build the demo automation. You can also find an exported version of this automation attached to this article as "Verify-Qlik-Sense-app-load-script-from-new-GitHub-pull-request.json".

Configure new automation to be webhook triggered on every new pull request in the GitHub repo.
Add a condition block to check whether the new pull request was opened and stop automation if the pull request was not opened. You can change the condition to use other actions from the pull request (like 'synchronize'). Or use the 'Add condition' option for multiple actions.
Get the load script from the file using the 'Get File Content' block. In this example, there's only one file so the first file from the List Pull Request Files block is used. If you have multiple files, use the Lookup Item In List block to find a specific file.
Create a new (temporary) app and set the load script from the pull request as this app's load script. When retrieving files from GitHub, they're base64 encoded by default. Use the Base64 Decode formula from the formula picker to decode the file's content before setting the load script.
Reload & delete the temporary app and evaluate the reload's outcome:
1. If the reload is successful, alert your team via slack with a success message and use Add Pull Request Review block to comment on the pull request that the load script test has succeeded
2. If the reload fails, alert your team via slack with a failure message and use Add Pull Request Review block to request changes on the pull request

A JSON file containing the above automation is attached to this article.

Please follow the steps provided in How to import automation from a JSON file article to import the automation

Related Content

mattgow · ‎2023-01-11

If I understand correctly, I should

Configure the start block with my github repo/account information
Ensure there is a valid github connector working
Run the automation once in order to have the webhook configured on the GitHub side?

As far as I can tell, the webhook isn't getting created in GitHub. Certainly no pull requests are triggering the automation and I can't see an webhooks listed in the configuration of the repository in github.

Any debugging tips you could help me with?

mattgow · ‎2023-01-11

I can manually create a webhook on the repo via GitHub and then set up the Qlik side with a generic webhook start block... but it would be cool if I could figure out what I'm doing wrong with the official GitHub webhook start block.

I am able to use the "list my repositories" block to confirm that the repo in question is available to me... so clearly some things work.

mattgow · ‎2023-01-11

Worked it out. I was putting the wrong "owner". The account being used to connect to Github is an owner of the repositories in question but when configuring the connector "owner" means the owner in the path to the repository i.e. github.com/<owner>/repository

Fixed.

Qlik Application Automation:Verify load script in Qlik Sense app from new GitHub pull request