Displaying iSheet table in dashboard

27237

I'd like to display an iSheet view in a dashboard on my home page. I was speaking with someone who said that the only way to do this is via custom code, but he did not elaborate.

My questions are:

1. Is there any way to do this directly through the HighQ dashboard edit feature (I think not, but figured I would ask)

2. If customization is necessary, would this involve creating an iframe in the dashboard, and pointing it to an external application that reads the isheet data and builds its own table to display? Seems like a lot of work to display something that is already in the HighQ system. If not, how would this be implemented?

Thanks

  • One of our users asked me to do this today and I told them I didn't think it was possible, so interested to know how to do this too!

  • Hi Chuck, You're correct that there is no out of the box way to do this at the moment. However, you can iframe the actual iSheet page URL into your home or wiki page with an offset to display the data in your page, if you're happy to accept the limitations of an iframe. Alternatively, we have a JavaScript solution that can securely display a responsive iSheet table without the need for an external service if that's helpful? More info here: www.engineer.legal/.../tables-for-highq Feel free to send me a message if I can help further. Dan
  • Chuck,

    A few thoughts.

    First, regarding community etiquette. Unless I am wrong, it appears that when you posted your question you triggered a notification to go out immediately via email to ALL community users?

    That means the system sent an email to likely over 1,000 users. Typically, this setting is kept at the default "Respect" value so that only users who are interested will be notified when they login next or receive a digest email.

    Sadly, the answer to your first question is no. Although this feature has been requested for about a decade, HighQ has for reasons that are beyond me chosen not to implement such an obviously needed (and often requested) feature. I know one or two third party vendors offer such a feature (of course, at additional cost) through the marketplace. Personally, I think this feature should be included by default with Collaborate, which is expensive enough to begin with.

    In terms of how to do this, there are lots of variations. Typically, that would involve writing some custom javascript and embedding that onto the page (not as an iframe). The javascript would access the iSheet data via the XML feed, as there is no additional authentication required, although the XML feed also has limitations. I do not believe you can use the REST API to access the data due to security concerns. There should be some other posts in the client community about how to do this.

    There is likely a way to use a separate application to grab the data via the REST API and then expose that in an iframe. The problem with that is with seamless authentication so that the person who is logged in only has access to what they should have access to via the iframe.

  • My apologies for pushing, but you might also want to check out the table add-on component in the Thomson Reuters Marketplace (available here: https://highq.in/iljmukz97z).

  • Dan Pryor has a fantastic tool called EngineerTable https://www.engineer.legal/solutions/tables-for-highq does come with an expense but covers all security concerns and many use case opportunities.

  • Chuck Rothman in addition to the suggestions already made, one other option is to reach out to your client/account manager who might be able to hook you up with a TR professional services team to help you build what you're after. Again, there would be a cost associated with this.

  • It turned out this was easier than I thought. We used the iSheet XML Feed to read the iSheet data via jquery, used jQueyr.parseXML to parse it, and just created a jquery function to build and display the table.

    Still would have been easier if it was built into the UI, but not as hard as I thought.

    Thanks to everyone who replied.

  • Thomson Reuters Thomson Reuters staff member

    Chuck Rothman I thought you (and others who use the XML feed for this kind of thing) might want to be aware of a limitation of ExportXML, if you're not already. ExportXML pulls only data that satisfies the user's last search of that isheet, potentially resulting in incomplete data. Thankfully, Andrew Quinn very kindly ":"blog","siteID":714,"contextID":8527}">provided a workaround, and a discussion on limitations, risks and alternatives, that you might be interested in.