edit script load editor with .net SDK

[hvdbunte]

Hi,

We started using the .net SDK in combination with the Qlik-Cli for Windows version for deploying apps to multiple streams.
For every stream we would like to change some variables in the Data load editor. Is that possible with the SDK? I found some options for changing the script with the engine JSON api but not with the SDK.

We have these 3 variables that we use to connect databases, we would like to change for every stream:

let CustomerName = 'CustomerA'
let DWH_CustomerName = 'DWH_CustomerA'
let Source_CustomerName = 'Source_CustomerA'

Would it be possible to search and replace these variable values in the load script?

Kind Regards

[Øystein_Kolsrud]

That method was deprecated in v15.4.0:

DEPRECATED: Deprecated extension method used for location configuration. Use non-extension versions instead.

 And the argument "proxyUsesSsl" was deprecated even earlier in 15.2.1;

DEPRECATED: Deprecated parameter proxyUsesSsl in proxy connection configurations. Use property CustomUserHeaders to define Origin header.

 https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/ReleaseNote...

[LDR]

Hi @Marc 

First at all thanks for your answer but, if I would like to get each table and columns that are part of the data model, how should I implement the method "GetTablesAndKeys()"? In the Qlik Help webpage I see that:

public GetTablesAndKeysResult GetTablesAndKeys([QixName("qWindowSize")] Size windowSize, [QixName("qNullSize")] Size nullSize, [QixName("qCellHeight")] int cellHeight, [QixName("qSyntheticMode")] bool syntheticMode, [QixName("qIncludeSysVars")] bool includeSysVars, [QixName("qIncludeProfiling")] bool includeProfiling = false)

But I don't understand why I need to specify any Windows size because I only want to extract this data and store it in text or csv format.

In summary, my intention is to get tables and fields on one hand, then get objects, variables, etc. and see which fields are in use, and which ones not, etc.

Comming back to my original question. I followed your instructions and it worked:

add-type -path "D:\Qlik Powershell\newtonsoft.json.6.0.1\lib\net45\Newtonsoft.Json.dll"

add-type -path "D:\Qlik Powershell\qliksense.netsdk.16.9.0\lib\net452\Qlik.Engine.dll"

add-type -path "D:\Qlik Powershell\qliksense.netsdk.16.9.0\lib\net452\Qlik.Sense.JsonRpc.dll"

add-type -path "D:\Qlik Powershell\qliksense.netsdk.16.9.0\lib\net452\Qlik.Sense.Client.dll"

$SenseServerURL = "https://QlikSense"

$QlikCredentials = Get-Credential

$ProxyUsesSSL = $true

$TrustAllCerts = $true

#Create the Location Object

$Location = [Qlik.Engine.Location]::FromUri($SenseServerURL)

#Establish a Authenticated Session to the Location.

$Location.AsNtlmUserViaProxy($QlikCeredentials,$TrustAllCerts)

$AppID = "2a0e9402-3d0f-4e94-9889-438b298b43d4"

$AppIdentifiersByID = [Qlik.Engine.LocationExtensions]::AppWithId($Location,$AppID)

$Session = $null

$NoData = $true

$QEApp = [Qlik.Engine.LocationExtensions]::App($Location,$AppIdentifiersByID,$Session,$NoData)

#Once we have the App we can Get the Load Script

$AppScript = $QEApp.GetScript()

$AppScript|Out-file D:\$($AppID)_Script.txt

Thanks a lot

[Øystein_Kolsrud]

The method "GetTablesAndKeys" is primarily uses by the data model viewer and I think that window size parameter is an artifact of that, though I don't know the details of the history to that.

But it looks like this thread has diverged somewhat from the original question of the thread so if you still have questions around data extraction, then I suggest you file a new question for that.