Question

Looker Actions - Hipchat

  • 5 January 2018
  • 1 reply
  • 40 views

Userlevel 1

Looker Actions - Hipchat


Looker is launching a Hipchat action, allowing customers to send a message to a Hipchat room referencing data within Looker. Messages will be sent by a LookerBot user (that will need to be added to Hipchat). Customers will then be able to send messages in any Hipchat room that the LookerBot has access to referencing Looker on a one-off or scheduled basis.


Enable the Hipchat Action


Note: Your Looker instance must be on Looker 5.6.




  1. To enable the action in Looker, go to your Admin panel and the Actions Tab under the Platform header [your-instance.looker.com/admin/actions]. (Admin > Platform > Actions)




  2. Select “Enable” on the Hipchat Action.




  3. In your Hipchat User administration console, create a Lookerbot user and then generate an API key for the LookerBot user [e.g. https://hipchat.com/account/api]. (Hipchat -> Create User -> Create API Key). The scopes should include Send Message, Send Notification, and View Group.




  4. Copy your Hipchat LookerBot API key and paste into the Looker Actions Page.




Send data to Hipchat


Great, now you’ve setup your Action so that Looker can communicate with the Hipchat API!


Create and Send or Schedule a Report




  1. In Looker, view a Look or explore data to see the data you want to reference in Hipchat.




  2. Then start to send the data now or schedule the data to be sent later or periodically.




  3. In the Send or Schedule window’s Destination field, select “Hipchat”.




  4. In the Room field, select the room to send the message.




  5. Click Send.

    Your new message will be sent to Hipchat!




1 reply

Userlevel 7
Badge

Don’t mean to be a pain since its not fully released but hopefully this is helpful:


The drop down of the rooms available to send seems to be limited to about 50 and there is no way to type/pick a room that’s not in the list.


The only use case I can imagine for spitting out the csv of fields and values is if you are only showing a single value.

Reply