I've made an eBay API implementation in VBA (Access) several years ago.
BUT I highly recommend you to use PHP and hosted site for it. I have moved and it became A LOT MORE comfortable.
You will be able to get webhooks which is WAY mode easy.
You have to use MSXML2.XMLHTTP60.
This is working function to send a request from VBA.
Function "setDefaultRequestHeaders" just sets other default headers.
You have to set callName + XML payload for it.
Private Function sendRequest(ByVal strEbayAPIFunction As String, _ ByVal requestBody As Variant) As Variant Dim httpRequest As MSXML2.XMLHTTP60, _ ret Set httpRequest = New MSXML2.XMLHTTP60 httpRequest.Open "POST", apiURL, False httpRequest.setRequestHeader "X-EBAY-API-CALL-NAME", strEbayAPIFunction setDefaultRequestHeaders httpRequest addLogRecord requestBody, "INFORMATION: >Request data" httpRequest.send requestBody If httpRequest.status = 200 Then ret = BinaryToUnicode(httpRequest.ResponseBody) addLogRecord ret, "INFORMATION: RESPONSE data<" Else txtErrorStatus = httpRequest.status txtErrorStatusText = httpRequest.StatusText addLogRecord StrMake("Error status: %1%3Status text: %2", _ httpRequest.status, _ httpRequest.StatusText, Chr(13) & Chr(10)), _ "ERROR: RESPONSE data<" ret = Nothing End If sendRequest = ret Set httpRequest = Nothing End Function
47 People are following this question.