HM3 - Is there API access like in HM2
Results 1 to 10 of 10
  1. #1
    Junior Member
    Join Date
    Dec 2019
    Posts
    2

    Default HM3 - Is there API access like in HM2

    I need to export statistics from my report for consolidation in a spreadsheet with some partners. I saw that this was possible using the API in the HM2 version. Is there API access at local host as It happened in the HM2 API example bellow?
    http://localhost:8001/Query?q=select...s%20limit%2055

  2. #2
    You're out! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    20,898

    Default

    It is not available yet. What are you trying to create that you are not able to on the reports?
    Regards udbrky (Chris)

  3. #3
    Junior Member
    Join Date
    Dec 2019
    Posts
    2

    Default

    I am part of a team, every month I have to get some data and manually type in a spreadsheet for conference by my boss. I would like to automate this and share the solution with my teammates who also have the same work. Any beta versions of the API on HM3 that I can test?

  4. #4
    *** HM3! *** fozzy71's Avatar
    Join Date
    Jun 2005
    Location
    HM Support
    Posts
    32,793

    Default

    You were using the HM2 'HMQL Report', to accomplish this process? This feature request has been documented in detail and provided to the developers for future consideration.

    HMT-2209: HMQL Report (similar to HM2)
    If you want to be notified if/when it is added please send an email via the 'Contact Support' link and include "Notify Me When HMT-2209 Is Resolved" in the subject line and body of the email.

  5. #5
    Junior Member
    Join Date
    Mar 2021
    Posts
    3

    Default

    Hi, new to HM3 but was wanting to export data and do some analysis. Is there an api/sdk for HM3? I'd like to start by applying filters and exporting reports

  6. #6
    *** HM3! *** fozzy71's Avatar
    Join Date
    Jun 2005
    Location
    HM Support
    Posts
    32,793

    Default

    The API is not available yet. You can however right-click save filtered reports to *.csv files. You can also use the https://sqlitebrowser.org/ app for querying the database similar to how PGAdmin worked for HM2 databases.

  7. #7
    Junior Member
    Join Date
    Mar 2021
    Posts
    3

    Default

    Quote Originally Posted by fozzy71 View Post
    The API is not available yet. You can however right-click save filtered reports to *.csv files. You can also use the https://sqlitebrowser.org/ app for querying the database similar to how PGAdmin worked for HM2 databases.
    Thanks fozzy. I'll take a look at the db. Is there any documentation on the schema? Also, when I apply a filter in holdem manager, is it showing me the actual field name as it would appear in the db schema?

  8. #8
    Junior Member
    Join Date
    Mar 2021
    Posts
    3

    Default

    Quote Originally Posted by fozzy71 View Post
    The API is not available yet. You can however right-click save filtered reports to *.csv files. You can also use the https://sqlitebrowser.org/ app for querying the database similar to how PGAdmin worked for HM2 databases.
    Thanks fozzy. What's the location of the db file? Also, when I apply filters in holdem manager is it showing me the fields as they would appear in the db?

  9. #9
    You're out! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    20,898

    Default

    Quote Originally Posted by tornadoesam View Post
    Thanks fozzy. What's the location of the db file? Also, when I apply filters in holdem manager is it showing me the fields as they would appear in the db?
    You can choose where to store them. Click File - Open Database or New Database and it should show the location.
    Regards udbrky (Chris)

  10. #10
    *** HM3! *** fozzy71's Avatar
    Join Date
    Jun 2005
    Location
    HM Support
    Posts
    32,793

    Default

    Quote Originally Posted by tornadoesam View Post
    Thanks fozzy. I'll take a look at the db. Is there any documentation on the schema? Also, when I apply a filter in holdem manager, is it showing me the actual field name as it would appear in the db schema?
    No, unfortunately we do not have any public documentation on the database schema that I am aware of. I am not a programmer so I haven't used the DB Browser for much other than integrity checks and compacting the databases after a purge but I do not think the filters in HM3 are going to match up with any of the database field names.

Similar Threads

  1. like seeing stats like this?
    By olimar943 in forum Share your HM2 HUD Configurations
    Replies: 4
    Last Post: 09-13-2013, 11:19 PM
  2. Replies: 5
    Last Post: 06-02-2012, 09:24 AM
  3. Ild like my own hud stats appear like my opponents ones
    By mouskito in forum Manager General
    Replies: 3
    Last Post: 04-03-2010, 12:07 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •