Connect eCatcher to PoweBI
My company uses eCatcher to monitor and connect to our 300+ customer machines. I'm trying to take the data that I see in eCatcher and get it into PowerBI. I've found information on connecting to individual devices and specific data points, but I'm just trying to get the overall picture of what my machines are doing. Thanks!
-
Can you tell us a little more about your application? What kind of data would you like to bring into Power BI? For data you see in Ecatcher like the online status of your Ewons, I recommend looking at the M2Web API.
Here's an example of a response from the "getewons" endpoint:
0 -
For starters we're just looking for the basic info that we can see in eCatcher: status, date, description, location, plus the custom fields. I hope to expand this in the future but this is just for starters.
0 -
The M2Web API can provide most of this (status, description, and custom fields).
The location shown for an Ewon is based on its public IP, so for Flexy devices you could send a script command to retrieve the Ewon's public IP, then use this with a geolocation service. There is an example of retrieving the public IP in this Ewon TechForum thread: GeoLocation or Public IP from API
At this time it's not possible to retrieve this through the API directly.
0 -
What about the dates for the statuses? When looking at https://m2web.talk2m.com/ there's a column for "Last Seen Online" and "Last Seen Offline". When looking at eCatcher, there's a column for "Date of Status". I can't find any documentation for either of these. Do they exist?
0
Please sign in to leave a comment.
Comments
4 comments