Jump to content


Hornbill Users
  • Content Count

  • Joined

  • Last visited

Community Reputation

1 Neutral

About BillP

  • Rank

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Hi @Steve G I'm happy to confirm that your alternative works. So we now have an end-to-end mechanism for extracting a specific class of problems from Hornbill and delivering them - with their associated artifacts - to a powershell automation. Now to automate resolving of the ticket! Thank you, and your colleagues for your assistance. Regards Bill
  2. @VictorCan you clarify that, please? https://eurapi.hornbill.com/myorg/dav/reports/109/Documotive Requests_5008.csv succeeds but https://eurapi.hornbill.com/myorg/dav/cafs_raw/fs_entity/8d0703328b4819440d1676c463783216de5b3605.data fails (401) in both cases the calling code is based on the referenced article above, and is (in the second case): $url = $baseEndpoint + "/dav" + $attachmentDetails.h_contentlocation Try { $wc = New-Object System.Net.WebClient $key = $HornbillAPIKey # $key = "abcdef1234567890abcdef1234567
  3. I did a little investigation and I tried an invalid API key, which gave a 403 (Forbidden) error, whereas my real API key gave a 401 (Unauthorized) error, from which I deduce that the API KEY is being checked, i.e. passing the Authentication (identity is valid) but is failing Authorization (identity is not allowed to do the thing). The 401 accords with https://tools.ietf.org/html/rfc7235#page-6 (when credentials are supplied) though I'm not sure that the 403 is right for the other case. I may be being over-picky.
  4. Thanks, @SamS That's got me further, and I now get a 401 error. I'm using the same API key as I use a few lines earlier when pulling down the report, so I'm guessing that permissions or roles might need to be added for the account?
  5. I am writing a powershell script to automate one particular ticket type that can be raised by our users. I've been able to create a report that lists all open tickets of the relevant type, and I'm able to retrieve the report using the techniques described at However, each ticket includes an attachment that needs to be passed to the automation. I can use smGetAttachments to retrieve information about the attachment, but I'm stuck how to retrieve the attachment itself from powershell. smGetAttachments returns fields like the below: h_pk_id : 16271 h_request_id :
  6. Following on from this, I'm able to download my own reports, which include references to attachments, such as: h_pk_id : 16271 h_request_id : SR00040620 h_contentlocation : /cafs_raw/fs_entity/8d0703328b4819440d1676c463783216de5b3605.data h_filename : xxxxxxxx mail merge- yyyyyy letters.doc h_size : 1566208 h_timestamp : 2020-08-06 10:38:27Z h_visibility : trustedGuest Presumably I can now take the h_contentlocation field and concatenate this to my instance URL plus some intermediate folder to download the actual attachm
  • Create New...