I have a project where I need to use a shopping cart's API to update product information from time to time.
I can download the product information, but am unable to devise a way to upload the information I need to change. The code that works for the download is
Dim xhr As Object, webServiceURL as string
webServiceURL = "http://app.ecwid.com/api/v1/9999999/products
Set xhr = CreateObject("Microsoft.XM
xhr.Open "GET", webServiceURL , False
If xhr.Status = 200 Then
MsgBox xhr.Status & ": " & xhr.StatusText
Set xhr = Nothing
The shopping cart specifies the following;
Format: JSON (both input and output)
HTTP Method: PUT, Content-type: text/json
I'm using Microsoft Access 2003, Windows 7.
I would really appreciate any assistance.