To Be Placed

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rah111
    Junior Member
    • May 2009
    • 11

    #1

    To Be Placed

    When I make a listMarketCatalogue call on a specific AUS horse event for a WIN market I get back something like the following:

    {"jsonrpc":"2.0","result":[{"marketId":"2.101345771","marketName":"R1 1800m Pace M","totalMatched":0.0}],"id":1}

    From that I can discern from the value of "marketName" that it is Race 1.

    When I make the same call but with marketTypeCodes = "PLACE", I get:

    {"jsonrpc":"2.0","result":[{"marketId":"2.101345772","marketName":"To Be Placed","totalMatched":0.0}],"id":1}

    How do I tell what race number a place market relates to?
  • bnl
    Junior Member
    • Nov 2012
    • 108

    #2
    I think you cannot .
    I dump the info to a database, where I then look up stuff.
    The relation between a win-market and its place-market
    is given by

    Code:
    select MP.* from AMARKETS MW, AMARKETS MP 
    where MW.EVENTID = MP.EVENTID 
    and MW.STARTTS = MP.STARTTS 
    and MW.MARKETID = :WINMARKETID 
    and MP.MARKETTYPE = 'PLACE' 
    and MW.MARKETTYPE = 'WIN'
    and MP.STATUS = 'OPEN'
    that is they have the same eventid, starttime
    and one is PLACE and the other is WIN.
    At race time then have status OPEN as well.

    As you can see from the JSON-replies, the marketids are close;
    the PLACE is 1 over the WIN.
    But I am not sure this can be always trusted.
    If there is 3-place and 4-place it might be different

    /Björn

    Comment

    • rah111
      Junior Member
      • May 2009
      • 11

      #3
      Race number woes

      Thanks Bjorn.

      I'll do something similar.

      It's not well designed is it? Wouldn't have hurt, nor have been very difficult I would have thought, to return the race number. Even for WIN calls it is not explicit and is only inferred from part of the returned "marketName" string and relies on the consistency of that string.

      Regards,

      Russell.

      Comment

      • bnl
        Junior Member
        • Nov 2012
        • 108

        #4
        Originally posted by rah111 View Post
        It's not well designed is it? Wouldn't have hurt, nor have been very difficult I would have thought, to return the race number. .

        Yes, a race number would be nice.
        It would tie all the markets on a particular race together.

        /Björn

        Comment

        Working...
        X