topic Re: Edit app data load script using API in App Development

Edit app data load script using API

jornk — Wed, 05 Jan 2022 13:17:17 GMT

Hi,

I'm struggling to find an API that offers functionality for editing the data load script of a Qlik app.

I have a scenario where I have a stream of template apps that are going to be copied over to multiple customer streams. In that regard I'd like to edit the datasource, through API functionality, of each app copy, so that I can load data from the corresponding customer database.

Thanks in advance! 🙂

Regards
Jørn

Re: Edit app data load script using API

rwunderlich — Thu, 06 Jan 2022 04:06:58 GMT

You can get and set the script using Doc.GetScript/SetScript

https://help.qlik.com/en-US/sense-developer/November2021/Subsystems/EngineJSONAPI/Content/service-doc-setscript.htm

There are also command line utilities that can set script.

What language are you using?

-Rob

Re: Edit app data load script using API

jornk — Thu, 06 Jan 2022 09:19:12 GMT

Great, thanks! I will look into this 🙂 I'm using .NET Core when communicating with the APIs.

Re: Edit app data load script using API

rwunderlich — Thu, 06 Jan 2022 13:02:49 GMT

For .NET it's the Qlik.Engine.App class:

https://help.qlik.com/en-US/sense-developer/November2021/Subsystems/NetSDKAPIref/Content/Qlik.Engine.App.GetScript.htm

-Rob

Re: Edit app data load script using API

Steve_Rosebrook — Tue, 09 Jul 2024 20:21:46 GMT

Hi Rob. I was curious about your statement that "There are also command line utilities that can set script". I'm working on some automation using Powershell and Qlik CLI, and am able to duplicate apps and download them as QVF files (for copying/importing into upper environments). But first I need to make changes to the load script of those duplicate apps to update the binary load statements in them, and I simply cannot figure out how to get Powershell/CLI to accomplish that. I wasn't sure if it was possible or not with those tools - so I thought I'd reach out. Any help you could give me would be appreciated. Thanks!

Re: Edit app data load script using API

chriscammers — Tue, 09 Jul 2024 21:17:42 GMT

@Steve_Rosebrook you are likely looking to use the "app script set" command in the the cli https://qlik.dev/toolkits/qlik-cli/app/app-script-set/

the example shows using a qvs file as the new script.

Re: Edit app data load script using API

Steve_Rosebrook — Wed, 10 Jul 2024 12:16:34 GMT

Thanks @chriscammers. I should have mentioned that I'm using the Windows client-managed version of Qlik - not Qlik SaaS. Does the link you shared work for client-managed? I tried that code and it's giving me an error so I wanted to check.

Re: Edit app data load script using API

chriscammers — Wed, 10 Jul 2024 13:58:56 GMT

The documentation says Qlik Cli supports client managed and saas deployments. I realize concepts like spaces would not be a thing in client managed but the only thing you can do is try it out.

Please let us know how it goes.

Re: Edit app data load script using API

Steve_Rosebrook — Wed, 10 Jul 2024 20:32:13 GMT

I am able to use CLI on our client-manager version of Qlik. However, I think the syntax/functions/cmdlets must be different between the SaaS version of CLI and the client-managed version. Here's the error message I get when trying to use the "qlik app script set" command:

Re: Edit app data load script using API

rwunderlich — Thu, 11 Jul 2024 14:22:52 GMT

There are two things named "Qlik-CLI".

1) Original "qlik-cli" https://github.com/ahaydon/Qlik-Cli-Windows a powershell module for client-managed. You can likely set the script on client managed using this one.

2) New qlik-cli https://qlik.dev/toolkits/qlik-cli/ for Qlik-SaaS and some client-managed functions.

-Rob

Re: Edit app data load script using API

Steve_Rosebrook — Fri, 12 Jul 2024 12:32:52 GMT

Thanks Rob - that's definitely a helpful distinction (I've looked at both of those sites already but haven't really seen anything in either of them that laid it out as clearly as you just did). However, I've been going through https://github.com/ahaydon/Qlik-Cli-Windows for the past several weeks, and scouring community posts, and I can't find anything that says you can use the Windows CLI version to modify load script. If anyone has done something like that, it would be great to see sample code. Right now I'm kind of stuck with only a half-way automated process . . . .