<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic getting Token with VBA in Dropbox API Support &amp; Feedback</title>
    <link>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/getting-Token-with-VBA/m-p/485268#M24389</link>
    <description>&lt;P&gt;Hi&lt;BR /&gt;&lt;BR /&gt;is there a way to get the DropBox token programmatically through VBA (or a different language, I'll try and translate it into VBA)?&lt;BR /&gt;&lt;BR /&gt;this to have my VBA macro go on after that and download a file thorugh DropBox API for which I need the token for the "bearer" parameter&lt;BR /&gt;&lt;BR /&gt;Thanks&lt;BR /&gt;&lt;BR /&gt;Riccardo&lt;BR /&gt;Riccardo&lt;/P&gt;</description>
    <pubDate>Mon, 11 Jan 2021 19:12:39 GMT</pubDate>
    <dc:creator>Riccardo Chojwa</dc:creator>
    <dc:date>2021-01-11T19:12:39Z</dc:date>
    <item>
      <title>getting Token with VBA</title>
      <link>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/getting-Token-with-VBA/m-p/485268#M24389</link>
      <description>&lt;P&gt;Hi&lt;BR /&gt;&lt;BR /&gt;is there a way to get the DropBox token programmatically through VBA (or a different language, I'll try and translate it into VBA)?&lt;BR /&gt;&lt;BR /&gt;this to have my VBA macro go on after that and download a file thorugh DropBox API for which I need the token for the "bearer" parameter&lt;BR /&gt;&lt;BR /&gt;Thanks&lt;BR /&gt;&lt;BR /&gt;Riccardo&lt;BR /&gt;Riccardo&lt;/P&gt;</description>
      <pubDate>Mon, 11 Jan 2021 19:12:39 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/getting-Token-with-VBA/m-p/485268#M24389</guid>
      <dc:creator>Riccardo Chojwa</dc:creator>
      <dc:date>2021-01-11T19:12:39Z</dc:date>
    </item>
    <item>
      <title>Login through VBA</title>
      <link>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/getting-Token-with-VBA/m-p/485270#M24390</link>
      <description>&lt;P&gt;Hi&lt;/P&gt;&lt;P&gt;I'm trying to login to my DropBox account through the following code&lt;/P&gt;&lt;PRE&gt;Dim myURL As String
myURL = "https://www.dropbox.com/home/myFolderName"

Dim WinHttpReq As Object
Set WinHttpReq = CreateObject("Microsoft.XMLHTTP")
WinHttpReq.Open "GET", myURL, False, myUserName, myPWD
WinHttpReq.send&lt;/PRE&gt;&lt;P&gt;but I'm getting a WinHttpReq.Status of 400 instead of the expected 200&lt;BR /&gt;&lt;BR /&gt;what am I doing wrong?&lt;BR /&gt;&lt;BR /&gt;thank you&lt;BR /&gt;&lt;BR /&gt;Riccardo&lt;/P&gt;</description>
      <pubDate>Thu, 07 Jan 2021 17:42:57 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/getting-Token-with-VBA/m-p/485270#M24390</guid>
      <dc:creator>Riccardo Chojwa</dc:creator>
      <dc:date>2021-01-07T17:42:57Z</dc:date>
    </item>
    <item>
      <title>Re: getting Token with VBA</title>
      <link>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/getting-Token-with-VBA/m-p/485565#M24395</link>
      <description>&lt;P&gt;In order to get an access token (and optionally a refresh token) for an account, your app should implement the OAuth app authorization flow. You can find information on how this process works in &lt;A href="https://www.dropbox.com/lp/developers/reference/oauth-guide" target="_self"&gt;the OAuth Guide&lt;/A&gt; and &lt;A href="https://www.dropbox.com/developers/documentation/http/documentation#authorization" target="_self"&gt;authorization documentation&lt;/A&gt;.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;In your code snippet here, you seem to be attempting to access the&amp;nbsp;Dropbox web site ("&lt;A href="https://www.dropbox.com/home" target="_blank"&gt;https://www.dropbox.com/home&lt;/A&gt;...") programmatically, which is incorrect. The&amp;nbsp;Dropbox web site is only meant for use by web browsers.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;The OAuth app authorization flow works by having the app direct the user to the&amp;nbsp;Dropbox web site's app authorization page in the user's web browser, where the user chooses whether or not to authorize the app. If the user chooses to do so, the app will then get an access token (and optionally a refresh token) that it can use to make API calls.&lt;/P&gt;</description>
      <pubDate>Fri, 08 Jan 2021 15:40:50 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/getting-Token-with-VBA/m-p/485565#M24395</guid>
      <dc:creator>Greg-DB</dc:creator>
      <dc:date>2021-01-08T15:40:50Z</dc:date>
    </item>
    <item>
      <title>Re: getting Token with VBA</title>
      <link>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/getting-Token-with-VBA/m-p/485580#M24399</link>
      <description>&lt;P&gt;Hi Greg&lt;BR /&gt;&lt;BR /&gt;thank you again for your prompt and hi-tech support&lt;BR /&gt;&lt;BR /&gt;for the Token issue, I'll look into&amp;nbsp;&lt;A href="https://www.dropbox.com/lp/developers/reference/oauth-guide" target="_self" rel="noopener noreferrer"&gt;the OAuth Guide&lt;/A&gt;&lt;SPAN&gt;&amp;nbsp;and&amp;nbsp;&lt;/SPAN&gt;&lt;A href="https://www.dropbox.com/developers/documentation/http/documentation#authorization" target="_self" rel="noopener noreferrer"&gt;authorization documentation&lt;/A&gt;&lt;SPAN&gt;. and see what I can dig out of it&lt;BR /&gt;&lt;BR /&gt;for the&amp;nbsp;Dropbox web site programatic access issue, is it incorrect/not meant for and yet feasable in some way?&lt;BR /&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;Thanks&lt;BR /&gt;Riccardo&lt;/SPAN&gt;&lt;/P&gt;</description>
      <pubDate>Fri, 08 Jan 2021 15:59:29 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/getting-Token-with-VBA/m-p/485580#M24399</guid>
      <dc:creator>Riccardo Chojwa</dc:creator>
      <dc:date>2021-01-08T15:59:29Z</dc:date>
    </item>
    <item>
      <title>Re: getting Token with VBA</title>
      <link>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/getting-Token-with-VBA/m-p/485590#M24400</link>
      <description>&lt;P&gt;I'm not sure exactly what you were trying to build with that code, but no, you should not be attempting to programmatically access the&amp;nbsp;Dropbox web site like that.&lt;/P&gt;</description>
      <pubDate>Fri, 08 Jan 2021 16:23:07 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/getting-Token-with-VBA/m-p/485590#M24400</guid>
      <dc:creator>Greg-DB</dc:creator>
      <dc:date>2021-01-08T16:23:07Z</dc:date>
    </item>
  </channel>
</rss>

