topic Re: QlikView API FinishedTime property in Integration, Extension & APIs

QlikView API FinishedTime property

BuTbka — Mon, 20 Feb 2023 11:10:03 GMT

Hi!
There is a bug in API.
QlikView API FinishedTime property is actually "Last execution" property on Task Detail tab in QMC and it is equal "Execution Started" on Task History tab.
It's very useful in the API to be able to get the start time, finish time, and duration.
Can you implement this?

Re: QlikView API FinishedTime property

Dave_Channon — Mon, 27 Feb 2023 08:56:10 GMT

Hi @BuTbka

For a bug, the best route is to open a support case at: https://community.qlik.com/t5/Support/ct-p/qlikSupport?launchChat=1

For the additional API fields, I recommend creating a topic (first check to see if the idea already exists) on our ideation board at https://community.qlik.com/t5/Ideation/ct-p/qlik-product-insight - this is watched by our Product Managers for each product.

Re: QlikView API FinishedTime property

NadiaB — Tue, 28 Feb 2023 21:47:30 GMT

Hi @BuTbka

Is there any particular reason of attempting to get this through API? The Governance Dashboard can show that information

https://help.qlik.com/en-US/governance-dashboard/Content/QV_GovDashboard/Getting-Started-with-the-Governance-Dashboard.htm

Hope it helps!

Re: QlikView API FinishedTime property

BuTbka — Wed, 01 Mar 2023 15:53:05 GMT

Hi @NadiaB
Thanks for reply.
We use qlikview in integration with other systems. And that is why GD cannot be used.
GD we also use, but in other cases.
I wrote some workaround for that on PS

$startTime = [datetime]::ParseExact($task.Extended.FinishedTime, "dd.MM.yyyy H:mm:ss", $provider) $task.Extended.LastLogMessages -match '(?<=Task Execute Duration\=)(?<Hours>\d+)\:(?<Minutes>\d+)\:(?<Seconds>\d+)' > $null $finishTime = $startTime.AddHours($matches.Hours).AddMinutes($matches.Minutes).AddSeconds($matches.Seconds).ToString("dd.MM.yyyy HH:mm:ss")