I'm new to working with PI and was wondering if there was a way to pull specific data points from PI and display them in a Google Spreadsheet? Basically, I'm looking for similar functionality to DataLink for Excel.
Thanks in advance!
Google exposes their spreadsheet APIs as well:
Thus between the two it should be possible to access your PI data via the PI Web API and then inject it into your Google Spreadsheet and simulate the functionality of PI DataLink
One follow up with this,
been playing with it a bit more recently (really like using the Web API with Angular JS, which Marco wrote a nice starter on here and on github!)
with google sheets
you can only use this kind of "port" of DataLink, on a PI Web API that has been set up from a Publicly Available server. The function they use to make URL calls are made from the server side,
so you can't try it on http://localhost/piwebapi or http://internalserver01.companydomain/piwebapi/ unfortunately.
I think this also rules out being able to pass windows credentials implicitly/with kerberos, and would only allow for basic authentication (or none/anonymous)
bit of a bummer
but if you're using google sheets, you probably keep everything else like PI in the publicly available cloud as well, so maybe still an option for some folks!
..if anyone has a / can make a test PI Web API server on a publicly reachable domain, and wouldn't mind allowing access to play with PI Web API from google sheets, that would be great!
I had a similar thought! I have just barely started playing with writing a custom implementation of DataLink for Google Sheets, which makes use of the PI Web API
having a sort of DataLink-port for Google Sheets would be a cool, cloud based implementation of the PI server access!
Thanks for the suggestions. I'm a developer on the DataLink team. There are no plans right now for a DataLink-port to Google Sheets, but it is something we would explore if there was sufficient demand. I am assuming you are using the API described here: Extending Google Sheets | Apps Script | Google Developers . You are taking the right approach using the PI Web API for your app. If we were to build a DataLink-port for Google Sheets, we would also use the PI Web API for data access. We have done some research/prototyping on a DataLink Office Add-in for Excel Online (Office365), but there is no approved plans for that product right now.
We would build a DataLink-port for either Office365 Excel or Google Sheets if we had evidence of sufficient demand from customers. While people are migrating online over time, we don't know the pace of adoption over using Desktop Excel. It would be helpful if you could give an estimate of how many of your OSIsoft customers use Office365 Excel and/or Google Sheets. Do you see an uptick in usage of either? At our SF Users Conference last April, I made a list of 12 customers that are starting to use Office365.
I'd like to gather an informal list here if you and others would like to reply. Here is a link to a poll where people indicate which online platform they use (if any at all)? Which Online Platform does your company use?
At the moment, it's more or less a side project because there isn't any demand for it from our customer (unfortunately, they haven't gone Google and I don't think have any plans to). Haha so honestly an Office 365 port for Web Excel would be a much more understandable route to go. For playing around though, getting started in Google Sheets Add-ins was super easy (and I personally use Google Docs, almost exclusively).
Our customer has been starting to push Sharepoint usage which lends itself more to Web based Excel and Word. But I honestly hardly see anyone making significant use of the web versions compared to desktop.
I think it would be tough to get the same efficiency as DataLink for desktop Excel with Google Sheets, so it would probably only work best with some smaller, less intense reports; I had in mind just using some simple 'current status' views in Google Sheets with some PI values.
Scott, any update on Office365 integration? It's been a year, and adoption rates may be higher now.
We would be interested in a web version of DataLink with Excel Online. Any word on if this is coming down the pipe soon or not?
Retrieving data ...