
TomW
Hornbill Users-
Content Count
48 -
Joined
-
Last visited
-
Days Won
1
TomW last won the day on November 27 2018
TomW had the most liked content!
Community Reputation
3 NeutralAbout TomW
-
Rank
Advanced Member
Recent Profile Visitors
The recent visitors block is disabled and is not being shown to other users.
-
Is it possible to auto-close a request after a certain time
TomW replied to TomW's topic in Service Manager
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
-
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
-
How do I retrieve a report using the API
TomW replied to TomW's topic in Integration Connectors, API & Webhooks
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 -
How do I retrieve a report using the API
TomW replied to TomW's topic in Integration Connectors, API & Webhooks
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
-
How do I retrieve a report using the API?
TomW replied to TomW's topic in Integration Connectors, API & Webhooks
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
-
Is it possible to retrieve a report using the Hornbill API
TomW replied to TomW's topic in Service Manager
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