Holdem Manager 2 API

[lonelycube]

try

select * from hands where IsTourney=true

[Pilequinha]

Is it possible to list other players? Like for instance list of players on my dbase with respective VPIP?

[Pilequinha]

Should not the following querie return all hands i have played in a torney in the Btn?

select * from hands where IsTourney=True and PositionType="Button"

[lonelycube]

I assume it should work but does not.

You can use ButtonOffset=0 instead I think

[nbenitus]

Hi!

I am not sure what I am doing wrong.

On page 3 of the pdf, the following text is displayed:

API Testing Tool
The test API client facilitates development of 3rd party tools by providing a convenient interface to
run queries which are returned in both a datagrid as well as raw JSON. You can download this
API here

However, the link seems broken as the file downloaded is invalid.

Am I doing something wrong here?

Thanks in advance!

[lonelycube]

They didn't release it but the mentioned report in this thread is a good substitute.

[lonelycube]

If I query for

StatThreeBetHeroRaiseFromBB
StatThreeBetHeroRaiseFromSB
StatThreeBetHeroRaiseFromBTN
StatThreeBetHeroRaiseFromCO
StatThreeBetHeroRaiseFromMP

they all return the value of StatThreeBetHeroRaiseFromMP

i.e. http://localhost:8001/Query?q=select...20from%20stats

[nbenitus]

Thanks lonelycube

I was wondering:

1. Would it be possible to get, for example, a list of players who have a btn steal % of 50 and more?

2. If not, would it be possible to get the btn steal % for player X? So far, all the stats I seem to be able to get for is StatPlayerNameAndSite

I tried this, but without success:

http://localhost:8001/Query?q=select StatTotalHands,StatVPIP,StatPFR,StatThreeBet,StatW entToShowdown, StatPlayerNameAndSite, StatWonShowdown,StatPostflopAggression,StatPostflo pAggressionPercentage where StatPlayerNameAndSite=X

(I am sorry, my SQL knowledge is very rusty)

[lonelycube]

I think you cannot do 1) as you have to select a player in HM2. So you always query against that player and not the whole "database".

[nbenitus]

Thanks again