I was chatting with @AlexOmetis earlier today and wanted to update this thread. On or about May 13th 2022 (beginning with qlik-cli v 2.11.1 / https://github.com/qlik-oss/qlik-cli/releases/tag/v2.11.1 ), the SaaS platform (and qlik-cli) added support for interacting with files on the platform.
Examples of usage:
Removing all data files in a specified space
$space_id = '63594739252c1b8cf49ca5fc' # Define my space id
$connections = qlik raw get v1/data-connections --query spaceId=$space_id,limit=100 | ConvertFrom-Json # Get all data connections for the specified space
foreach($connection in $connections) {
if($connection.qName -eq 'DataFiles') {
# If the data connection name in the specified space = "DataFiles" then store this data connection id
$space_data_file_connection_id = $connection.id
}
}
# Get all files stored in DataFiles for the specified space
$space_files = qlik data-file ls --connectionId $space_data_file_connection_id | ConvertFrom-Json
$space_data_files = @()
foreach($space_file in $space_files) {
$space_data_files += $space_file.id
}
foreach($space_data_file in $space_data_files) {
qlik data-file rm $space_data_file
}
Uploading a file (which does not already exist):
$myFilePath = 'C:\etc\Data\CSV.csv' # Where is the file
$myFile = $myFilePath -replace '.*\\' # Store just the file name (e.g. CSV.csv)
$spaceId = '5e42f2cc0ea40d0001214b3a' # Define my space id
$dataFiles = @()
$connections = qlik raw get v1/data-connections --query spaceId=$spaceId,limit=100 | ConvertFrom-Json # Get all data connections for the specified space
foreach($connection in $connections) {
if($connection.qName -eq 'DataFiles') {
# If the data connection name in the specified space = "DataFiles" then store this data connection id
$spaceDataFileConnectionId = $connection.id
}
}
# Upload a specified file to the DataFiles connection in the specified space
qlik data-file create --name $myFile --file $myFilePath --connectionId $spaceDataFileConnectionId
Updating a file:
$myFilePath = 'C:\etc\Data\CSV.csv' # Where is the file
$myFile = $myFilePath -replace '.*\\' # Store just the file name (e.g. CSV.csv)
$spaceId = '5e42f2cc0ea40d0001214b3a' # Define my space id
$dataFiles = @()
$connections = qlik raw get v1/data-connections --query spaceId=$spaceId,limit=100 | ConvertFrom-Json # Get all data connections for the specified space
foreach($connection in $connections) {
if($connection.qName -eq 'DataFiles') {
# If the data connection name in the specified space = "DataFiles" then store this data connection id
$spaceDataFileConnectionId = $connection.id
}
}
# Get all files stored in DataFiles for the specified space
$spaceFiles = qlik data-file ls --connectionId $spaceDataFileConnectionId | ConvertFrom-Json
foreach($spaceFile in $spaceFiles) {
IF($spaceFile.name -eq $myFile) {
# Store the id of the file
$dataFileId = $spaceFile.id
}
}
# Replace the existing file with a file from disk
qlik data-file update $dataFileId --file $myFilePath --connectionId $spaceDataFileConnectionId
