RESTful API call from Excel VBA

Question

I'm attempting to access the online API of http://api.football-data.org/index using Excel VBA to eventually populate an excel sheet with a click of a button. Currently I have:

Sub apiTest()
  Dim oRequest As Object
  Set oRequest = CreateObject("WinHttp.WinHttpRequest.5.1")
  oRequest.Open "GET", "http://api.football-data.org/v1/competitions/354/fixtures/?matchday=22", False
  oRequest.SetRequestHeader "X-Auth-Token", "replace this with my api token"
  oRequest.Send
  MsgBox oRequest.ResponseText
End Sub

According to the site, all I need to do is to add the X-Auth-Token field to the header and it should work. However, when I try to run this the response body says "The resource you are looking for is restricted". Am I using WinHTTPRequest improperly?

Yohan Chung · Accepted Answer · 2017-01-30 02:58:55Z

1

I have checked its documentation. The error (403 Restricted Resource) is to do with the followings:

the resource is only available to authenticated clients
the resource is only available to donating clients
the resource is not available in the API version you are using

Also, X-Response-Control seems to be included as request header (See the doc).

answered Jan 30, 2017 at 2:58

Yohan Chung

5391 gold badge8 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Scott Over a year ago

The request I was using must be restricted to donating clients then. Weird, since he claims his site is 'free' and that request is used as an example in the code samples section. Thanks a bunch

Yohan Chung Over a year ago

I found there is sample url which works regardless of authentication, which is api.football-data.org/v1/competitions/424/fixtures?matchday=7 You can try develop with this url first before you get authentication through paying or donating.

Collectives™ on Stack Overflow

RESTful API call from Excel VBA

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related