Automate table export to data format - REST API and Powershell
Hello, I would like to automate the export of a table to a qlik view via powershell script, qlik sense enterprise windows. I'd like to use the Qlik API, but I can't get my user to connect. I'm writing to you in response to the following ticket: https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-Call-Session-API-with-Postman-Pow... Can you advise me on how to set up the virtual proxy? Or I've created a connection with API REST How do I then make the call via the powershell script? Thank you in advance for your help
Do you want to export from Qlikview or Qlik Sense? It's a little unclear from your request. I don't know about Qlikview, but if Qlik Sense is your product then you need to go through the engine API to export data to Excel. You can use the Qlik Sense .NET SDK for interacting with the engine from PowerShell. It's available from NuGet here:
I use Qlik Sense. I want to use a script to automate the process of selecting a table and exporting it in data format.
My powershell is not compatible with .NET dll
I wanted to use requests to the REST API, before that I have to use POST requests to the API ticket but I can't write the script I hope to be clearer to express my difficulty.
You can't use the REST APIs for this. Extraction of data is done through the Engine API in Qlik Sense, and this API is based on JSON-RPC through websockets. This is the endpoint for doing that type of export:
It's certainly possible to use the .NET SDK from PowerShell. I'm not the best person to guide you there though, but here's an example of a thread on the topic:
