Jump to content

Steve G

Hornbill Developer
  • Content Count

  • Joined

  • Last visited

  • Days Won


Steve G last won the day on December 17 2019

Steve G had the most liked content!

Community Reputation

108 Excellent

About Steve G

  • Rank
    Senior Member

Profile Information

  • Gender
  • Location
    Hull, UK

Contact Methods

  • Website URL

Recent Profile Visitors

1,922 profile views
  1. @samwoo No problem whatsoever, hope you have a great weekend too! Cheers, Steve
  2. Hi @samwoo, Glad it's working for you! The queries are not documented as they are really just for Hornbill developers to use I'm afraid, but there's no reason why you can't use those that you spot being called directly from the UI Cheers, Steve
  3. Hi @samwoo, Rather than entityBrowseRecords2, you'd be best off using a stored query and the data::queryExec API to get at that information. Open up the assets list in your browser, and open up the Network console, and look at the calls to data::queryExec, specifically those that use the getAssetsListByClass query. Every time you filter the list (by asset class and/or text filtering) you should see 2 calls to that query, one to get a count and one to get the record data. This will be more efficient than us adding relatedEntityData to entityBrowseRecords2, and allows for proper pagination of the resultset. Cheers, Steve
  4. As you may be aware, Microsoft have recently added support for Python in Power BI. So we've just released some new Python scripts that can be used as datasources in Power BI: PowerBIReport.py - this script will run a report on a specified Hornbill instance, then output the report CSV data as a Power BI consumable dataframe; PowerBIHistoricReport.py - this script will retrieve a historic report run CSV from a report on a specified Hornbill instance, then output the report data back as a Power BI consumable dataframe; PowerBIReport.py - this script will retrieve the trend data from a measure on a specified Hornbill instance, then output the trend data back as a Power BI consumable dataframe. These scripts can be found on Github, and are documented on the Hornbill Wiki. There are a number of dependencies, so please ensure you read the Wiki documentation (and pages linked on that wiki page) thorougly before attempting to implement. Thanks, Steve
  5. Hi @Martyn Houghton, I've added a new integration that will return an drive items ID etc, when it's provided the Drive and the Item Path: So, if I have drive that contains a file in a folder within root, like this file here: Where the items filepath is: Some Demo Folder/A Screen Shot 2019-06-21 at 10.47.51.jpg I can now get its unique ID for use in further workflow nodes using the new Microsoft>OneDrive>Drives>Get Drive Item Cloud Automation: So as you know the path and file that you want to share, this new operation should hopefully workaround the drive item search API limitations... I've just released this to Live, so it should be on your instance in a few minutes. Let me know how you get on with this one! Cheers, Steve
  6. What's New Cloud Automation Integrations for OneDrive - Get Drive Item. This new integration will take a Drive ID, and an Item Path, and return some useful information about the Item (including its unique ID).
  7. Thanks for the offer @Martyn Houghton, but I can replicate with my dev O365 instance. There are a couple of issues here. The first is that spaces shouldn't be encoded in the usual way within the query - they should be replaced by a + character. That's fine though, as I can handle that in the iBridge operation code. The second issue is a little more annoying - the API doesn't like full stops (or other "special" characters, it seems) in the name of the file being searched - except the one that separates the name and extension. I'm just trying to work out if there's a way to encode/change these characters for the API to play ball. I'll let you know how I get on... Cheers, Steve
  8. @Martyn Houghton Subfolder searching works fine, but I can replicate the issue with spaces in the query. Just looking at that now...
  9. @Martyn Houghton We already wrap the string in single-quotes, so you shouldn't need to add any more. Let me take a look, might be something to do with the URL encoding, 2 ticks...
  10. Unfortunately not It appears that external share links don't have a permission ID associated with them. I have tried this API to get this information back from the share URL provided by the Send a Sharing Invitaion API, but the ID field in the output is always populated with 00000000-0000-0000-0000-000000000000 when shared externally... So it's limitations in the Microsoft Graph API's that we can't (currently) workaround, rather than issues with the integrations themselves The search integration uses this API, so we're just replacing {search-text} in the below with the string provided in the Query input: GET /drives/{drive-id}/root/search(q='{search-text}') Cheers, Steve
  11. HI @Martyn Houghton, This integration uses the Create Sharing Link API, which will create a link to the provided specification, and will pass the shared link back to the Web URL node output param, as below. This URL can then be forwarded to the customer who requires it: Cheers, Steve
  12. Hi @samwoo, Rather than adding the API key into the headers, you can always add it to the payload, as so: Or if the payload is XML: Cheers, Steve
  13. HI @Gary@ADL, I've not used Qlik before, but you can use the Hornbill Data Export Tool to export data. Basically the tool will run a report on your Hornbill instance to collate the necessary data, wait for the report to complete then pull the report data CSV down to the machine that the tool is running on. You can then import the CSV data in to Qlik. Cheers, Steve
  14. Hi @Martyn Houghton, Was a 5 minute job so squeezed it in before the end of the week Cheers, Steve
  15. What's Changed Cloud Automation Integrations for Jira and Jira Cloud - Comment Issue and Update Issue integrations now return a status output parameter
  • Create New...