Authentication parameters missing error

knikolov356

Hello,

I am getting an "Authentication parameters missing" error when trying to connect using VBA. When connecting with .NET all is good. Connection used to work just fine with V1 of the API. Can you please help me get past this error?

Code looks similar to this with the exception of the login info:

Set jsonProvider = CreateObject("MSXML2.ServerXMLHTTP")

apiUrl = "https://od-api.oxforddictionaries.com:443/api/v2/entries/en/arrow"

jsonProvider.Open "GET", apiUrl, False
jsonProvider.setRequestHeader "Accept", "application/json"
jsonProvider.setRequestHeader "app_id", "1122334455"
jsonProvider.setRequestHeader "app_key", "fd7f987f9sdf7sd9f98g7s98df79sd8d"

jsonProvider.send '("")
resultText = jsonProvider.responseText

resultText is "Authentication parameters missing"

Sincerely,

Kiril

mooping9383

I don't know I want to do some VBS too but it kinda hard

TaisFukushima

Hello @mooping9383 and @knikolov356

I am sorry for not responding this earlier.

I could see that in the code you shared you are using "en" as the source language. Maybe you could set the English variation, like "en-us" or "en-gb". In the Entries endpoint, you need to specify the language variation of the source language; when using only "en" the API automatically redirect "en-gb". Maybe, that is the reason you are getting this response.

Please, let me know if it helped.

mooping9383

Oh I kind of understand now you're missing your app id

mooping9383

@dewnnn1150 What do you mean?

sammuelsum

@knikolov356 Did you solve the problem? Can anyone help?

My code is about the same as yours. The response is "Authentication failed". But I don't think I enter the wrong id or key. If I use "entries" instead of "thesaurus" then OK. Is that I must use "entries"?

Dim httpReq As New MSXML2.ServerXMLHTTP
httpReq.Open "GET", "https://od-api.oxforddictionaries.com/api/v2/thesaurus/en/ace?strictMatch=false", False
httpReq.setRequestHeader "Accept", "application/json"
httpReq.setRequestHeader "app_id", "****"
httpReq.setRequestHeader "app_key", "*****************"
httpReq.send
Dim response As String
response = httpReq.responseText
MsgBox response

TaisFukushima

Hello @sammuelsum

If you are registered in a Prototype plan you won't have access to Thesaurus endpoint. Whenever you try to make a call to other endpoints which aren't Entries and Lemmas endpoints (endpoints available to Prototype plan) you will receive an error message/service error message.

I hope it helps!