Skip to main content

Connect eCatcher to PoweBI

Comments

4 comments

  • Hugh Whitefur

    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
  • esporta-ab

    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
  • Hugh Whitefur

    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
  • esporta-ab

    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.