TomW

Thanks for the information. I will see if we can use the service level targets for this. Cheers Tom

Hello I was wondering if it is possible to automatically close a call if it has been active for certain period of time? For example if an incident was raised 2 weeks ago and the company has a policy to close all active (open, new, on hold etc.) incidents that are over 2 weeks old. Would this have to be done in a workflow or is there a setting in Hornbill that does this?

Further to the issue above I have been trying to pass the user input variable when calling the "reportRun" API as follows: $Parameter = @( "<reportid>$reportID</reportid>" "<runtimeParameter><inputParameter><uuid>idDateLogged</uuid><value>2019-04-30 00:00:01</value></inputParameter></runtimeParameter>" ) When the code runs I get the error: Running report: 516 Run-HbReport : The element <uiid> was expected 1 time(s) at location '/methodCall/params/runtimeParameter/inputParameter

Thanks Steve. I'll have a go at this now.

I have been writing code to run, check and retrieve reports using the Hornbill API (via a PowerShell script), and this all works fine. However a couple reports have filters like "Requests -> Date Logged value is less than <User prompted input>". Is It possible to pass the "<User prompted input>" values when using the API, e.g. using something like the 'runtimeParameter' input parameter? If so how would I go about doing this? I've had a look at the source code for the 'goHornbillReportRunner-master' but the report runner doesn't include an option for this. Any advice

I have finally got this working after spending too much time barking up the wrong tree. The code to do this in PowerShell is fairly simple: [string]$url = $davendpoint + "reports/" + $reportID + "/" + $reportFileLink echo("URI: " + $url) Try { $wc = New-Object System.Net.WebClient $wc.Headers.Add("Authorization","ESP-APIKEY " + $apiKey) $wc.DownloadFile($url,$outputLocation) return -1 } Catch { Write-Error $_.Exception.Message #echo("hey ho pip and dandy") return $apiResponse } The $davendpoint vari

Thanks for the information and for getting back so quickly. I'll have a look at it now.

I am writing a PowerShell script to run a report using the Hornbill api and then to download the report to a specified directory. I can run the report and retrieve the name for the report e.g. "Check for Re-Openned Calls_23851.xlsx" but I do not know where I can retreieve the report from. please could you offer some advice? Cheers Tom

sorry I posted this query on the wrong forum. It should be on the service manager forum

I am writing a PowerShell script to run a report using the Hornbill api and then to download the report to a specified directory. I can run the report and retrieve the name for the report e.g. "Check for Re-Openned Calls_23851.xlsx" but I do not know where I can retreieve the report from. please could you offer some advice? Cheers Tom

Also the report only takes three seconds to run.

Thanks for your advice. The log file shows the following information: "2020/01/20 09:36:01 ---- Hornbill Report Runner V1.0.0 ---- 2020/01/20 09:36:01 Flag - Configuration File: conf.json 2020/01/20 09:36:01 [DEBUG] Loading Config File: C:\Temp/conf.json 2020/01/20 09:36:43 Running report RCV - Check for Re-Openned Calls [417]. 2020/01/20 09:37:04 [ERROR] Post https://eurapi.hornbill.com/*removed*/reporting/?method=reportRun: dial tcp *removed*:443: connectex: A connection attempt failed because the connected party did not properly respond after a period of time, or established co

I am trying to run and retrieve reports using the Hornbill Report Runner and have entered the relevant information in the conf.json file. When I run the command "goHornbillReportRunner_x86.exe -file=conf.json" I get the following response in the command prompt: "---- Hornbill Report Runner V1.0.0 ---- Flag - Configuration File: conf.json Running report RCV - Check for Re-Openned Calls [417]. [ERROR] Post https://eurapi.hornbill.com/'removed'/reporting/?method=reportRun: dial tcp 'removed': connectex: A connection attempt failed because the connected party did not properly respo

Thanks for the information Steve, it is a great help. Cheers Tom

Hello I was wondering if it is possible to access a report in Hornbill using one of the APIs in Hornbill? Thanks Tom