Get TO SCORE and FIRST SCORER odds

[Gian]

Hi everybody,
I would like to know if is possible to get "To Score" e "First scorer" odds from the Exchange API?

Thanks in advance

[jabe]

It is. For any particular football match, you need to look for the related marketBooks with marketType = TO_SCORE or FIRST_GOAL_SCORER. These won't be available on all games.

[Gian]

I'm trying with your suggestion but still doesn't work, is this the right query?

{"filter": {"eventIds": ["29212604"], "marketTypeCodes":["TO_SCORE"]}, "maxResults": "1000", "marketProjection": ["EVENT"], "marketName": ["Match Odds"]}

[jabe]

My utter apologies - it's the listMarketCatalogues you want first, not the marketBooks. The following is a working call from my program:

{"jsonrpc": "2.0", "method": "SportsAPING/v1.0/listMarketCatalogue", "params": {"filter":{"eventIds": [29223356],"marketTypeCodes": ["MATCH_ODDS","CORRECT_SCORE"]},"maxResults": "2","marketProjection":["RUNNER_DESCRIPTION","MARKET_START_TIME", "COMPETITION"]},"id": 1}

I suspect the marketName parameter is unnecessary, but I got the call to work without and with it.

HOWEVER....

I wrote my program with a tab to test API calls so that I don't have to code them into the program. I've tried using yours and swapping parameters from mine above to see what works. By using "marketTypeCodes": [] I was able to return all marketCatalogues for eventId 29212604. I will list the output below

TO_SCORE and FIRST_GOAL_SCORER are not markets for that event.

If your call returns this:
{"jsonrpc":"2.0","result":[]}
it means that no marketCatalogue fitted your parameters.


Here are all the marketCatalogues for your event, if you wish to inspect them

In

"filter":{"eventIds": ["29223356"], "marketTypeCodes":[]}, "maxResults": "1000", "marketProjection": ["RUNNER_DESCRIPTION","MARKET_START_TIME", "COMPETITION"],"marketName": ["Match Odds"]}

Out

{"jsonrpc":"2.0","result":[{"marketId":"1.157283209","marketName":"Draw no Bet","marketStartTime":"2019-04-08T18:30:00.000Z","totalMatched":12.9,"runners":[{"selectionId":12502566,"runnerName":"UAI Urquiza","handicap":0.0,"sortPriority":1},{"select ionId":7546748,"runnerName":"Estudiantes de Caseros","handicap":0.0,"sortPriority":2}],"competition":{"id":"11633637","name":"Argentinia n Primera B Metropolitana"}},{"marketId":"1.157283210","market Name":"Estudiantes de Caseros +1","marketStartTime":"2019-04-08T18:30:00.000Z","totalMatched":25.96,"runners":[{"selectionId":7560414,"runnerName":"Estudiante s de Caseros +1","handicap":0.0,"sortPriority":1},{"selectionId ":15960076,"runnerName":"UAI Urquiza -1","handicap":0.0,"sortPriority":2},{"selectionId" :151478,"runnerName":"Draw","handicap":0.0,"sortPr iority":3}],"competition":{"id":"11633637","name":"Argentinia n Primera B Metropolitana"}},{"marketId":"1.157283207","market Name":"Half Time","marketStartTime":"2019-04-08T18:30:00.000Z","totalMatched":127.44,"runners":[{"selectionId":12502566,"runnerName":"UAI Urquiza","handicap":0.0,"sortPriority":1},{"select ionId":7546748,"runnerName":"Estudiantes de Caseros","handicap":0.0,"sortPriority":2},{"select ionId":58805,"runnerName":"The Draw","handicap":0.0,"sortPriority":3}],"competition":{"id":"11633637","name":"Argentinia n Primera B Metropolitana"}},{"marketId":"1.157283208","market Name":"Over/Under 7.5 Goals","marketStartTime":"2019-04-08T18:30:00.000Z","totalMatched":0.3,"runners":[{"selectionId":1485572,"runnerName":"Under 7.5 Goals","handicap":0.0,"sortPriority":1},{"selectio nId":1485573,"runnerName":"Over 7.5 Goals","handicap":0.0,"sortPriority":2}],"competition":{"id":"11633637","name":"Argentinia n Primera B Metropolitana"}},{"marketId":"1.157283205","market Name":"UAI Urquiza +1","marketStartTime":"2019-04-08T18:30:00.000Z","totalMatched":19.83,"runners":[{"selectionId":15960075,"runnerName":"UAI Urquiza +1","handicap":0.0,"sortPriority":1},{"selectionId ":7560415,"runnerName":"Estudiantes de Caseros -1","handicap":0.0,"sortPriority":2},{"selectionId" :151478,"runnerName":"Draw","handicap":0.0,"sortPr iority":3}],"competition":{"id":"11633637","name":"Argentinia n Primera B Metropolitana"}},{"marketId":"1.157283206","market Name":"Over/Under 0.5 Goals","marketStartTime":"2019-04-08T18:30:00.000Z","totalMatched":376.08,"runners":[{"selectionId":5851482,"runnerName":"Under 0.5 Goals","handicap":0.0,"sortPriority":1},{"selectio nId":5851483,"runnerName":"Over 0.5 Goals","handicap":0.0,"sortPriority":2}],"competition":{"id":"11633637","name":"Argentinia n Primera B Metropolitana"}},{"marketId":"1.157283203","market Name":"Next Goal","marketStartTime":"2019-04-08T18:30:00.000Z","totalMatched":0.0,"runners":[{"selectionId":12502566,"runnerName":"UAI Urquiza","handicap":0.0,"sortPriority":1},{"select ionId":7546748,"runnerName":"Estudiantes de Caseros","handicap":0.0,"sortPriority":2},{"select ionId":69852,"runnerName":"No Goal","handicap":0.0,"sortPriority":3}],"competition":{"id":"11633637","name":"Argentinia n Primera B Metropolitana"}},{"marketId":"1.157283204","market Name":"Double Chance","marketStartTime":"2019-04-08T18:30:00.000Z","totalMatched":20.41,"runners":[{"selectionId":6384646,"runnerName":"Home or Draw","handicap":0.0,"sortPriority":1},{"selection Id":6384647,"runnerName":"Draw or Away","handicap":0.0,"sortPriority":2},{"selection Id":6384648,"runnerName":"Home or Away","handicap":0.0,"sortPriority":3}],"competition":{"id":"11633637","name":"Argentinia n Primera B Metropolitana"}},{"marketId":"1.157283201","market Name":"First Half Goals 1.5","marketStartTime":"2019-04-08T18:30:00.000Z","totalMatched":345.84,"runners":[{"selectionId":1221385,"runnerName":"Under 1.5 Goals","handicap":0.0,"sortPriority":1},{"selectio nId":1221386,"runnerName":"Over 1.5 Goals","handicap":0.0,"sortPriority":2}],"competition":{"id":"11633637","name":"Argentinia n Primera B Metropolitana"}},{"marketId":"1.157283202","market Name":"Half Time/Full Time","marketStartTime":"2019-04-08T18:30:00.000Z","totalMatched":227.92,"runners":[{"selectionId":15960079,"runnerName":"UAI Urquiza/UAI Urquiza","handicap":0.0,"sortPriority":1},{"select ionId":15960077,"runnerName":"UAI Urquiza/Draw","handicap":0.0,"sortPriority":2},{"selection Id":10344197,"runnerName":"UAI Urquiza/Estudiantes ","handicap":0.0,"sortPriority":3},{"selectionId": 15960073,"runnerName":"Draw/UAI Urquiza","handicap":0.0,"sortPriority":4},{"select ionId":3710152,"runnerName":"Draw/Draw","handicap":0.0,"sortPriority":5},{"selection Id":7546750,"runnerName":"Draw/Estudiantes ","handicap":0.0,"sortPriority":6},{"selectionId": 10344196,"runnerName":"Estudiantes /UAI Urquiza","handicap":0.0,"sortPriority":7},{"select ionId":7546751,"runnerName":"Estudiantes /Draw","handicap":0.0,"sortPriority":8},{"selection Id":7546754,"runnerName":"Estudiantes /Estudiantes ","handicap":0.0,"sortPriority":9}],"competition":{"id":"11633637","name":"Argentinia n Primera B Metropolitana"}},{"marketId":"1.157283198","market Name":"Both teams to Score?","marketStartTime":"2019-04-08T18:30:00.000Z","totalMatched":49.02,"runners":[{"selectionId":30246,"runnerName":"Yes","handicap" :0.0,"sortPriority":1},{"selectionId":110503,"runn erName":"No","handicap":0.0,"sortPriority":2}],"competition":{"id":"11633637","name":"Argentinia n Primera B Metropolitana"}},{"marketId":"1.157283164","market Name":"Asian Handicap","marketStartTime":"2019-04-08T18:30:00.000Z","totalMatched":779.49,"runners":[{"selectionId":12502566,"runnerName":"UAI Urquiza","handicap":-4.0,"sortPriority":1},{"selectionId":7546748,"runn erName":"Estudiantes de Caseros","handicap":4.0,"sortPriority":2},{"select ionId":12502566,"runnerName":"UAI Urquiza","handicap":-3.75,"sortPriority":3},{"selectionId":7546748,"run nerName":"Estudiantes de Caseros","handicap":3.75,"sortPriority":4},{"selec tionId":12502566,"runnerName":"UAI Urquiza","handicap":-3.5,"sortPriority":5},{"selectionId":7546748,"runn erName":"Estudiantes de Caseros","handicap":3.5,"sortPriority":6},{"select ionId":12502566,"runnerName":"UAI Urquiza","handicap":-3.25,"sortPriority":7},{"selectionId":7546748,"run nerName":"Estudiantes de Caseros","handicap":3.25,"sortPriority":8},{"selec tionId":12502566,"runnerName":"UAI Urquiza","handicap":-3.0,"sortPriority":9},{"selectionId":7546748,"runn erName":"Estudiantes de Caseros","handicap":3.0,"sortPriority":10},{"selec tionId":12502566,"runnerName":"UAI Urquiza","handicap":-2.75,"sortPriority":11},{"selectionId":7546748,"ru nnerName":"Estudiantes de Caseros","handicap":2.75,"sortPriority":12},{"sele ctionId":12502566,"runnerName":"UAI Urquiza","handicap":-2.5,"sortPriority":13},{"selectionId":7546748,"run nerName":"Estudiantes de Caseros","handicap":2.5,"sortPriority":14},{"selec tionId":12502566,"runnerName":"UAI Urquiza","handicap":-2.25,"sortPriority":15},{"selectionId":7546748,"ru nnerName":"Estudiantes de Caseros","handicap":2.25,"sortPriority":16},{"sele ctionId":12502566,"runnerName":"UAI Urquiza","handicap":-2.0,"sortPriority":17},{"selectionId":7546748,"run nerName":"Estudiantes de Caseros","handicap":2.0,"sortPriority":18},{"selec tionId":12502566,"runnerName":"UAI Urquiza","handicap":-1.75,"sortPriority":19},{"selectionId":7546748,"ru nnerName":"Estudiantes de Caseros","handicap":1.75,"sortPriority":20},{"sele ctionId":12502566,"runnerName":"UAI Urquiza","handicap":-1.5,"sortPriority":21},{"selectionId":7546748,"run nerName":"Estudiantes de Caseros","handicap":1.5,"sortPriority":22},{"selec tionId":12502566,"runnerName":"UAI Urquiza","handicap":-1.25,"sortPriority":23},{"selectionId":7546748,"ru nnerName":"Estudiantes de Caseros","handicap":1.25,"sortPriority":24},{"sele ctionId":12502566,"runnerName":"UAI Urquiza","handicap":-1.0,"sortPriority":25},{"selectionId":7546748,"run nerName":"Estudiantes de Caseros","handicap":1.0,"sortPriority":26},{"selec tionId":12502566,"runnerName":"UAI Urquiza","handicap":-0.75,"sortPriority":27},{"selectionId":7546748,"ru nnerName":"Estudiantes de Caseros","handicap":0.75,"sortPriority":28},{"sele ctionId":12502566,"runnerName":"UAI Urquiza","handicap":-0.5,"sortPriority":29},{"selectionId":7546748,"run nerName":"Estudiantes de Caseros","handicap":0.5,"sortPriority":30},{"selec tionId":12502566,"runnerName":"UAI Urquiza","handicap":-0.25,"sortPriority":31},{"selectionId":7546748,"ru nnerName":"Estudiantes de Caseros","handicap":0.25,"sortPriority":32},{"sele ctionId":12502566,"runnerName":"UAI Urquiza","handicap":0.0,"sortPriority":33},{"selec tionId":7546748,"runnerName":"Estudiantes de Caseros","handicap":0.0,"sortPriority":34},{"selec tionId":12502566,"runnerName":"UAI Urquiza","handicap":0.25,"sortPriority":35},{"sele ctionId":7546748,"runnerName":"Estudiantes de Caseros","handicap":-0.25,"sortPriority":36},{"selectionId":12502566,"r unnerName":"UAI Urquiza","handicap":0.5,"sortPriority":37},{"selec tionId":7546748,"runnerName":"Estudiantes de Caseros","handicap":-0.5,"sortPriority":38},{"selectionId":12502566,"ru nnerName":"UAI Urquiza","handicap":0.75,"sortPriority":39},{"sele ctionId":7546748,"runnerName":"Estudiantes de Caseros","handicap":-0.75,"sortPriority":40},{"selectionId":12502566,"r unnerName":"UAI Urquiza","handicap":1.0,"sortPriority":41},{"selec tionId":7546748,"runnerName":"Estudiantes de Caseros","handicap":-1.0,"sortPriority":42},{"selectionId":12502566,"ru nnerName":"UAI Urquiza","handicap":1.25,"sortPriority":43},{"sele ctionId":7546748,"runnerName":"Estudiantes de Caseros","handicap":-1.25,"sortPriority":44},{"selectionId":12502566,"r unnerName":"UAI Urquiza","handicap":1.5,"sortPriority":45},{"selec tionId":7546748,"runnerName":"Estudiantes de Caseros","handicap":-1.5,"sortPriority":46},{"selectionId":12502566,"ru nnerName":"UAI Urquiza","handicap":1.75,"sortPriority":47},{"sele ctionId":7546748,"runnerName":"Estudiantes de Caseros","handicap":-1.75,"sortPriority":48},{"selectionId":12502566,"r unnerName":"UAI Urquiza","handicap":2.0,"sortPriority":49},{"selec tionId":7546748,"runnerName":"Estudiantes de Caseros","handicap":-2.0,"sortPriority":50},{"selectionId":12502566,"ru nnerName":"UAI Urquiza","handicap":2.25,"sortPriority":51},{"sele ctionId":7546748,"runnerName":"Estudiantes de Caseros","handicap":-2.25,"sortPriority":52},{"selectionId":12502566,"r unnerName":"UAI Urquiza","handicap":2.5,"sortPriority":53},{"selec tionId":7546748,"runnerName":"Estudiantes de Caseros","handicap":-2.5,"sortPriority":54},{"selectionId":12502566,"ru nnerName":"UAI Urquiza","handicap":2.75,"sortPriority":55},{"sele ctionId":7546748,"runnerName":"Estudiantes de Caseros","handicap":-2.75,"sortPriority":56},{"selectionId":12502566,"r unnerName":"UAI Urquiza","handicap":3.0,"sortPriority":57},{"selec tionId":7546748,"runnerName":"Estudiantes de Caseros","handicap":-3.0,"sortPriority":58},{"selectionId":12502566,"ru nnerName":"UAI Urquiza","handicap":3.25,"sortPriority":59},{"sele ctionId":7546748,"runnerName":"Estudiantes de Caseros","handicap":-3.25,"sortPriority":60},{"selectionId":12502566,"r unnerName":"UAI Urquiza","handicap":3.5,"sortPriority":61},{"selec tionId":7546748,"runnerName":"Estudiantes de Caseros","handicap":-3.5,"sortPriority":62},{"selectionId":12502566,"ru nnerName":"UAI Urquiza","handicap":3.75,"sortPriority":63},{"sele ctionId":7546748,"runnerName":"Estudiantes de Caseros","handicap":-3.75,"sortPriority":64},{"selectionId":12502566,"r unnerName":"UAI Urquiza","handicap":4.0,"sortPriority":65},{"selec tionId":7546748,"runnerName":"Estudiantes de Caseros","handicap":-4.0,"sortPriority":66}],"competition":{"id":"11633637","name":"Argentinia n Primera B Metropolitana"}},{"marketId":"1.157283199","market Name":"Half Time Score","marketStartTime":"2019-04-08T18:30:00.000Z","totalMatched":226.2,"runners":[{"selectionId":1,"runnerName":"0 - 0","handicap":0.0,"sortPriority":1},{"selectionId" :3,"runnerName":"1 - 1","handicap":0.0,"sortPriority":2},{"selectionId" :7,"runnerName":"2 - 2","handicap":0.0,"sortPriority":3},{"selectionId" :2,"runnerName":"1 - 0","handicap":0.0,"sortPriority":4},{"selectionId" :5,"runnerName":"2 - 0","handicap":0.0,"sortPriority":5},{"selectionId" :6,"runnerName":"2 - 1","handicap":0.0,"sortPriority":6},{"selectionId" :4,"runnerName":"0 - 1","handicap":0.0,"sortPriority":7},{"selectionId" :9,"runnerName":"0 - 2","handicap":0.0,"sortPriority":8},{"selectionId" :8,"runnerName":"1 - 2","handicap":0.0,"sortPriority":9},{"selectionId" :4506345,"runnerName":"Any Unquoted ","handicap":0.0,"sortPriority":10}],"competition":{"id":"11633637","name":"Argentinia n Primera B Metropolitana"}},{"marketId":"1.157283200","market Name":"First Half Goals 0.5","marketStartTime":"2019-04-08T18:30:00.000Z","totalMatched":453.66,"runners":[{"selectionId":5851482,"runnerName":"Under 0.5 Goals","handicap":0.0,"sortPriority":1},{"selectio nId":5851483,"runnerName":"Over 0.5 Goals","handicap":0.0,"sortPriority":2}],"competition":{"id":"11633637","name":"Argentinia n Primera B Metropolitana"}},{"marketId":"1.157283162","market Name":"Over/Under 5.5 Goals","marketStartTime":"2019-04-08T18:30:00.000Z","totalMatched":43.46,"runners":[{"selectionId":1485567,"runnerName":"Under 5.5 Goals","handicap":0.0,"sortPriority":1},{"selectio nId":1485568,"runnerName":"Over 5.5 Goals","handicap":0.0,"sortPriority":2}],"competition":{"id":"11633637","name":"Argentinia n Primera B Metropolitana"}},{"marketId":"1.157283163","market Name":"Over/Under 6.5 Goals","marketStartTime":"2019-04-08T18:30:00.000Z","totalMatched":30.66,"runners":[{"selectionId":2542448,"runnerName":"Under 6.5 Goals","handicap":0.0,"sortPriority":1},{"selectio nId":2542449,"runnerName":"Over 6.5 Goals","handicap":0.0,"sortPriority":2}],"competition":{"id":"11633637","name":"Argentinia n Primera B Metropolitana"}},{"marketId":"1.157283160","market Name":"Over/Under 3.5 Goals","marketStartTime":"2019-04-08T18:30:00.000Z","totalMatched":10.02,"runners":[{"selectionId":1222344,"runnerName":"Under 3.5 Goals","handicap":0.0,"sortPriority":1},{"selectio nId":1222345,"runnerName":"Over 3.5 Goals","handicap":0.0,"sortPriority":2}],"competition":{"id":"11633637","name":"Argentinia n Primera B Metropolitana"}},{"marketId":"1.157283161","market Name":"Over/Under 4.5 Goals","marketStartTime":"2019-04-08T18:30:00.000Z","totalMatched":79.6,"runners":[{"selectionId":1222347,"runnerName":"Under 4.5 Goals","handicap":0.0,"sortPriority":1},{"selectio nId":1222346,"runnerName":"Over 4.5 Goals","handicap":0.0,"sortPriority":2}],"competition":{"id":"11633637","name":"Argentinia n Primera B Metropolitana"}},{"marketId":"1.157283158","market Name":"Over/Under 1.5 Goals","marketStartTime":"2019-04-08T18:30:00.000Z","totalMatched":3320.89,"runners" :[{"selectionId":1221385,"runnerName":"Under 1.5 Goals","handicap":0.0,"sortPriority":1},{"selectio nId":1221386,"runnerName":"Over 1.5 Goals","handicap":0.0,"sortPriority":2}],"competition":{"id":"11633637","name":"Argentinia n Primera B Metropolitana"}},{"marketId":"1.157283159","market Name":"Over/Under 2.5 Goals","marketStartTime":"2019-04-08T18:30:00.000Z","totalMatched":2491.07,"runners" :[{"selectionId":47972,"runnerName":"Under 2.5 Goals","handicap":0.0,"sortPriority":1},{"selectio nId":47973,"runnerName":"Over 2.5 Goals","handicap":0.0,"sortPriority":2}],"competition":{"id":"11633637","name":"Argentinia n Primera B Metropolitana"}},{"marketId":"1.157283156","market Name":"Match Odds","marketStartTime":"2019-04-08T18:30:00.000Z","totalMatched":925.29,"runners":[{"selectionId":12502566,"runnerName":"UAI Urquiza","handicap":0.0,"sortPriority":1},{"select ionId":7546748,"runnerName":"Estudiantes de Caseros","handicap":0.0,"sortPriority":2},{"select ionId":58805,"runnerName":"The Draw","handicap":0.0,"sortPriority":3}],"competition":{"id":"11633637","name":"Argentinia n Primera B Metropolitana"}},{"marketId":"1.157283157","market Name":"Correct Score","marketStartTime":"2019-04-08T18:30:00.000Z","totalMatched":50.52,"runners":[{"selectionId
*** SOME REMOVED HERE DUE TO MESSAGE SIZE***
},{"selectionId":9063255,"runnerName":"Any Other Away Win","handicap":0.0,"sortPriority":18},{"selection Id":9063256,"runnerName":"Any Other Draw","handicap":0.0,"sortPriority":19}],"competition":{"id":"11633637","name":"Argentinia n Primera B Metropolitana"}},{"marketId":"1.157283213","market Name":"Goal Lines","marketStartTime":"2019-04-08T18:30:00.000Z","totalMatched":260.76,"runners":[{"selectionId":7044483,
*** SOME REMOVED HERE DUE TO MESSAGE SIZE***
}],"competition":{"id":"11633637","name":"Argentinia n Primera B Metropolitana"}},{"marketId":"1.157283211","market Name":"Over/Under 8.5 Goals","marketStartTime":"2019-04-08T18:30:00.000Z","totalMatched":0.0,"runners":[{"selectionId":2407528,"runnerName":"Under 8.5 Goals","handicap":0.0,"sortPriority":1},{"selectio nId":2407529,"runnerName":"Over 8.5 Goals","handicap":0.0,"sortPriority":2}],"competition":{"id":"11633637","name":"Argentinia n Primera B Metropolitana"}},{"marketId":"1.157283212","market Name":"First Half Goals 2.5","marketStartTime":"2019-04-08T18:30:00.000Z","totalMatched":0.0,"runners":[{"selectionId":47972,"runnerName":"Under 2.5 Goals","handicap":0.0,"sortPriority":1},{"selectio nId":47973,"runnerName":"Over 2.5 Goals","handicap":0.0,"sortPriority":2}],"competition":{"id":"11633637","name":"Argentinia n Primera B Metropolitana"}}]}

[Gian]

thanks for your help! Really appreciate, I'm trying to get the scorer names by using this python call but the array result is empy:

market_catalogue_filter = betfairlightweight.filters.market_filter(event_ids =['14843951'],market_type_codes=["MATCH_ODDS","CORRECT_SCORE"])
market_catalogues = trading.betting.list_market_catalogue(filter=marke t_catalogue_filter,max_results='1000',market_proje ction=["RUNNER_DESCRIPTION","MARKET_START_TIME","COMP ETIT ION"])

any ideas?

[jabe]

EventId 14843951 doesn't exist today. There is no entry for it with listEvents or listMarketCatalogue. Your program will have to deal with data missing.

You'll need to change the marketTypeCodes to the ones that you wanted. I'll pick another match and work out what your API call should look like...

Right, this one does the trick. You might need to change the marketProjection parameters. This if for the Manchester United v Barcelona game on Wednesday evening.

"filter":{"eventIds": ["29184566"], "marketTypeCodes":["TO_SCORE","FIRST_GOAL_SCORER"]}, "maxResults": "1000", "marketProjection": ["RUNNER_DESCRIPTION","MARKET_START_TIME", "COMPETITION"]}

Most games do not have the TO_SCORE and FIRST_GOAL_SCORER markets.