This is currently what I have now but I seem to be unable to authenticate my credentials properly leading to a detail not found response
This is what I have now but the response i get now is detail not found. I seem to be unable to authenticate my credentials.
Dim myReq As WinHttpRequest
Set myReq = New WinHttpRequest
myReq.Open “POST”, “http://kc.kobotoolbox.org/api/v1/data/8029.csv”, False
myReq.SetRequestHeader “Authorization”, "Basic " + Base64Encode(“username” + “:” + “password”)
On Friday, March 20, 2015 at 12:30:03 PM UTC+8, Terence Lim wrote:
I’m not very good with HTTP knowledge and I am unsure of how to use the APIs on vba. I am trying to retrieve submitted data for a specific form(curl -X GET https://kc.kobotoolbox.org/api/v1/data/22845) and populate the retrieved data into rows on excel.
Any help would be greatly appreciated