I am trying to access the smartsheet API. They have a sample code provided in curl to access it.
To access your Sheet list, construct an HTTPS request using your favorite programming or scripting language. Here is an example using the curl from a linux command line:
curl https://api.smartsheet.com/1.0/sheets \
-H "Authorization: Bearer 0da6cf0d-848c-4266-9b47-cd32a6151b1f" \
-H "Assume-User: john.doe%40smartsheet.com"
This is a rather large subject but at it's most simple you could try this...
Dim wHeader As WebHeaderCollection = New WebHeaderCollection() wHeader.Clear() wHeader.Add("Authorization: Bearer 0da6cf0d-848c-4266-9b47-cd32a6151b1f") wHeader.Add("Assume-User: john.doe%40smartsheet.com") Dim sUrl As String = "https://api.smartsheet.com/1.0/sheets" Dim wRequest As HttpWebRequest = DirectCast(System.Net.HttpWebRequest.Create(sUrl), HttpWebRequest) 'wRequest.ContentType = "application/json" ' I don't know what your content type is wRequest.Headers = wHeader wRequest.Method = "GET" Dim wResponse As HttpWebResponse = DirectCast(wRequest.GetResponse(), HttpWebResponse) Dim sResponse As String = "" Using srRead As New StreamReader(wResponse.GetResponseStream()) sResponse = srRead.ReadToEnd() End Using
I'm unfamiliar with the smartsheet API but you can use this as a start point.
If you are using a Proxy you will need to add...
Dim wProxy As IWebProxy = WebRequest.GetSystemWebProxy() wProxy.Credentials = System.Net.CredentialCache.DefaultCredentials
and specify the proxy when you make the request...
wRequest.Proxy = wProxy