<?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 Using API from Excel VBA in Dropbox API Support &amp; Feedback</title>
    <link>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/Using-API-from-Excel-VBA/m-p/143699#M4591</link>
    <description>&lt;P&gt;Hello,&lt;/P&gt;
&lt;P&gt;I'm trying to figure out how the API exactly works to download files from Dropbox from Excel VBA (2010, 2013).&lt;BR /&gt;The main issue for now is how to get past the authorization part.&lt;/P&gt;
&lt;P&gt;I'v setup the app in de dev-corner.&lt;BR /&gt;Status: Development&lt;BR /&gt;Allow implicit grant: Disallow&lt;/P&gt;
&lt;P&gt;My https-request to Dropbox is:&lt;BR /&gt;"&lt;A href="https://www.dropbox.com/1/oauth2/authorize?response_type=code&amp;amp;client_id=%5Bapp-key%5D&amp;amp;redirect_uri=http://localhost" rel="nofollow noreferrer" target="_blank"&gt;https://www.dropbox.com/1/oauth2/authorize?response_type=code&amp;amp;client_id=[app-key]&amp;amp;redirect_uri=http://localhost&lt;/A&gt;" (which I open using "WinHttpReq.Open "GET", myURL, False" (where myURL is the URL to Dropbox).&lt;/P&gt;
&lt;P&gt;The return-value consists mainly of question-marks. That also happens if I don't specify a redirect_uri. (Btw, I'm matching up the redirect_uri in the dev-panel and the code).&lt;/P&gt;
&lt;P&gt;I expected/hoped to receive the response with the access token, but apparently I'm doing something wrong.&lt;/P&gt;
&lt;P&gt;Can anyone help me out?&lt;/P&gt;
&lt;P&gt;Thanks,&lt;BR /&gt;Gejakem&lt;/P&gt;</description>
    <pubDate>Wed, 29 May 2019 09:38:54 GMT</pubDate>
    <dc:creator>Gert-Jan K.</dc:creator>
    <dc:date>2019-05-29T09:38:54Z</dc:date>
    <item>
      <title>Using API from Excel VBA</title>
      <link>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/Using-API-from-Excel-VBA/m-p/143699#M4591</link>
      <description>&lt;P&gt;Hello,&lt;/P&gt;
&lt;P&gt;I'm trying to figure out how the API exactly works to download files from Dropbox from Excel VBA (2010, 2013).&lt;BR /&gt;The main issue for now is how to get past the authorization part.&lt;/P&gt;
&lt;P&gt;I'v setup the app in de dev-corner.&lt;BR /&gt;Status: Development&lt;BR /&gt;Allow implicit grant: Disallow&lt;/P&gt;
&lt;P&gt;My https-request to Dropbox is:&lt;BR /&gt;"&lt;A href="https://www.dropbox.com/1/oauth2/authorize?response_type=code&amp;amp;client_id=%5Bapp-key%5D&amp;amp;redirect_uri=http://localhost" rel="nofollow noreferrer" target="_blank"&gt;https://www.dropbox.com/1/oauth2/authorize?response_type=code&amp;amp;client_id=[app-key]&amp;amp;redirect_uri=http://localhost&lt;/A&gt;" (which I open using "WinHttpReq.Open "GET", myURL, False" (where myURL is the URL to Dropbox).&lt;/P&gt;
&lt;P&gt;The return-value consists mainly of question-marks. That also happens if I don't specify a redirect_uri. (Btw, I'm matching up the redirect_uri in the dev-panel and the code).&lt;/P&gt;
&lt;P&gt;I expected/hoped to receive the response with the access token, but apparently I'm doing something wrong.&lt;/P&gt;
&lt;P&gt;Can anyone help me out?&lt;/P&gt;
&lt;P&gt;Thanks,&lt;BR /&gt;Gejakem&lt;/P&gt;</description>
      <pubDate>Wed, 29 May 2019 09:38:54 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/Using-API-from-Excel-VBA/m-p/143699#M4591</guid>
      <dc:creator>Gert-Jan K.</dc:creator>
      <dc:date>2019-05-29T09:38:54Z</dc:date>
    </item>
    <item>
      <title>Re: Using API from Excel VBA</title>
      <link>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/Using-API-from-Excel-VBA/m-p/143700#M4592</link>
      <description>&lt;P&gt;The &lt;A href="https://www.dropbox.com/developers/core/docs#oa2-authorize" target="_blank" rel="nofollow noreferrer"&gt;/oauth2/authorize&lt;/A&gt;&amp;nbsp;URL is not an API endpoint, but rather a page on the&amp;nbsp;Dropbox web site, where the user can choose whether or not to authorize your app to their&amp;nbsp;Dropbox account. You should be directing the user to it in a browser, and not programmatically requesting it.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;The following pages have more information about implementing the OAuth 2 app authorization flow:&lt;/P&gt;
&lt;P&gt;&lt;A href="https://www.dropbox.com/developers/reference/oauth-guide" target="_blank" rel="nofollow noreferrer"&gt;https://www.dropbox.com/developers/reference/oauth-guide&lt;/A&gt;&lt;BR /&gt;&lt;A href="https://blogs.dropbox.com/developers/2013/07/using-oauth-2-0-with-the-core-api/" target="_blank" rel="nofollow noreferrer"&gt;https://blogs.dropbox.com/developers/2013/07/using-oauth-2-0-with-the-core-api/&lt;/A&gt;&lt;/P&gt;</description>
      <pubDate>Wed, 04 Nov 2015 06:30:02 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/Using-API-from-Excel-VBA/m-p/143700#M4592</guid>
      <dc:creator>Greg-DB</dc:creator>
      <dc:date>2015-11-04T06:30:02Z</dc:date>
    </item>
    <item>
      <title>Re: Using API from Excel VBA</title>
      <link>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/Using-API-from-Excel-VBA/m-p/143701#M4593</link>
      <description>&lt;P&gt;Update.&lt;BR /&gt;When I read the results using "ResponseText" in stead of "ResponseBody" I do get a readable response.&lt;/P&gt;
&lt;P&gt;Looks like (first part):&lt;/P&gt;
&lt;PRE&gt;&amp;lt;!DOCTYPE html&amp;gt;&lt;BR /&gt;&amp;lt;html lang="en" xmlns:fb="http://ogp.me/ns/fb#" xml:lang="en" class=" xmlns="http://www.w3.org/1999/xhtml"&amp;gt;&lt;BR /&gt;&amp;lt;head&amp;gt;&lt;BR /&gt;&amp;lt;script nonce="bkK440PlJxi6kqbQgYbz"&amp;gt;&lt;BR /&gt;&lt;BR /&gt;window._goch_ = {};&lt;BR /&gt;&lt;BR /&gt;window.addEventListener('click', function(event)&lt;BR /&gt;&amp;nbsp;{&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; 'use str&lt;/PRE&gt;</description>
      <pubDate>Wed, 04 Nov 2015 06:30:53 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/Using-API-from-Excel-VBA/m-p/143701#M4593</guid>
      <dc:creator>Gert-Jan K.</dc:creator>
      <dc:date>2015-11-04T06:30:53Z</dc:date>
    </item>
    <item>
      <title>Re: Using API from Excel VBA</title>
      <link>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/Using-API-from-Excel-VBA/m-p/143702#M4594</link>
      <description>&lt;P&gt;My request is not about an app requesting access to the user's Dropbox-account, but rather the other way around.&lt;BR /&gt;Users that will be using my Excel-file will need access to a folder in MY Dropbox-account.&lt;/P&gt;
&lt;P&gt;From there they will be granted access to a specific folder and the Excel-file will read file-listings and file-contents from Dropbox.&lt;/P&gt;
&lt;P&gt;It's a bit like sharing a Dropbox-folder with someone.&lt;BR /&gt;I already used the provided link (from sharing a folder), but that returns a complete HTML-page with a lot of clutter I don't need.&lt;BR /&gt;I only need a file-listing first and then in a second step I will need to download one of those files.&lt;/P&gt;</description>
      <pubDate>Wed, 04 Nov 2015 06:59:52 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/Using-API-from-Excel-VBA/m-p/143702#M4594</guid>
      <dc:creator>Gert-Jan K.</dc:creator>
      <dc:date>2015-11-04T06:59:52Z</dc:date>
    </item>
    <item>
      <title>Re: Using API from Excel VBA</title>
      <link>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/Using-API-from-Excel-VBA/m-p/143703#M4595</link>
      <description>&lt;P&gt;In that case, if your app will only be connecting to your own account, you don't need to implement the OAuth app authorization flow at all.&lt;/P&gt;
&lt;P&gt;For reference, the API was designed with the intention that each user would link their own Dropbox account, in order to interact with their own files. However, it is technically possible to connect to just one account. The SDKs don't offer explicit support for it and we don't recommend doing so, for various technical and security reasons.&lt;/P&gt;
&lt;P&gt;However if you did want to go this route, instead of kicking off the authorization flow, you would manually use an existing access token for your account and app. (Just be careful not to revoke it, e.g. via &lt;A href="https://www.dropbox.com/account/security" rel="nofollow noreferrer"&gt;https://www.dropbox.com/account/security&lt;/A&gt; .) For example, you can generate&amp;nbsp;an access token for your account via your app's page on the &lt;A href="https://www.dropbox.com/developers/apps" target="_blank" rel="nofollow noreferrer"&gt;App Console&lt;/A&gt;.&lt;/P&gt;
&lt;P&gt;If you have a shared link that you want to get information about programmatically you can use &lt;A href="https://www.dropbox.com/developers/core/docs#metadata-link" target="_blank" rel="nofollow noreferrer"&gt;/metadata/link&lt;/A&gt;.&lt;/P&gt;</description>
      <pubDate>Wed, 04 Nov 2015 07:10:09 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/Using-API-from-Excel-VBA/m-p/143703#M4595</guid>
      <dc:creator>Greg-DB</dc:creator>
      <dc:date>2015-11-04T07:10:09Z</dc:date>
    </item>
    <item>
      <title>Re: Using API from Excel VBA</title>
      <link>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/Using-API-from-Excel-VBA/m-p/143704#M4596</link>
      <description>&lt;P&gt;Gregory,&lt;/P&gt;
&lt;P&gt;Thanx for your quick and helpful answers.&lt;BR /&gt;This route (metadata/link) seems like a good one (reading through the docs).&lt;BR /&gt;When POSTing this:&lt;/P&gt;
&lt;PRE&gt;https://api.dropbox.com/1/metadata/link?link=https://www.dropbox.com/sh/[scramble1]/[scramble2]?dl=0&amp;amp;client_id=[app-key]&amp;amp;client_secret=[app-secret]&lt;/PRE&gt;
&lt;P&gt;the return value is&lt;/P&gt;
&lt;PRE&gt;{"error": "access_denied:unsupported_app_type"}&lt;/PRE&gt;
&lt;P&gt;The error-code is 403 and the status-text is "Forbidden".&lt;/P&gt;
&lt;P&gt;What does this mean? I'm not able to find the meaning of this on Internet or the Droppbox-docs.&lt;/P&gt;</description>
      <pubDate>Wed, 04 Nov 2015 07:48:20 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/Using-API-from-Excel-VBA/m-p/143704#M4596</guid>
      <dc:creator>Gert-Jan K.</dc:creator>
      <dc:date>2015-11-04T07:48:20Z</dc:date>
    </item>
    <item>
      <title>Re: Using API from Excel VBA</title>
      <link>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/Using-API-from-Excel-VBA/m-p/143705#M4597</link>
      <description>&lt;P&gt;That endpoint is only supported for apps with&amp;nbsp;the full&amp;nbsp;Dropbox &lt;A href="https://www.dropbox.com/developers/reference/devguide#app-permissions" target="_blank" rel="nofollow noreferrer"&gt;permission&lt;/A&gt;, so you'll get this error if you call using an app with a different permission, per the &lt;A href="https://www.dropbox.com/developers-v1/core/docs#metadata-link" target="_blank" rel="nofollow noreferrer"&gt;documentation&lt;/A&gt;:&lt;/P&gt;
&lt;P&gt;&amp;gt; This API endpoint requires Full Dropbox &lt;A href="https://www.dropbox.com/developers-v1/reference/devguide#app-permissions" rel="nofollow noreferrer"&gt;permission&lt;/A&gt;.&lt;/P&gt;
&lt;P&gt;If you want to use that endpoint you can &lt;A href="https://www.dropbox.com/developers/apps/create" target="_blank" rel="nofollow noreferrer"&gt;register an app&lt;/A&gt; for the full&amp;nbsp;Dropbox permission.&lt;/P&gt;</description>
      <pubDate>Wed, 04 Nov 2015 07:50:57 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/Using-API-from-Excel-VBA/m-p/143705#M4597</guid>
      <dc:creator>Greg-DB</dc:creator>
      <dc:date>2015-11-04T07:50:57Z</dc:date>
    </item>
    <item>
      <title>Re: Using API from Excel VBA</title>
      <link>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/Using-API-from-Excel-VBA/m-p/143706#M4598</link>
      <description>&lt;P&gt;Yes, that did the trick!&lt;BR /&gt;Thanx, Greg, you're the best &lt;img class="lia-deferred-image lia-image-emoji" src="https://www.dropboxforum.com/html/@FBF7D2AB59A0D6E861EBF6A36F93B7E2/emoticons/1f642.png" alt=":slightly_smiling_face:" title=":slightly_smiling_face:" /&gt;&lt;/P&gt;</description>
      <pubDate>Wed, 04 Nov 2015 07:58:19 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/Using-API-from-Excel-VBA/m-p/143706#M4598</guid>
      <dc:creator>Gert-Jan K.</dc:creator>
      <dc:date>2015-11-04T07:58:19Z</dc:date>
    </item>
    <item>
      <title>Re: Using API from Excel VBA</title>
      <link>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/Using-API-from-Excel-VBA/m-p/143707#M4599</link>
      <description>&lt;P&gt;@gejakem can you please share your code?&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;I want to create a VBA app which generates a list of all the files in my Dropbox Account in Excel so I&amp;nbsp;can compare using Excel to files i have on various hard drives to then start deleting the physical copies already backed up to Dropbox.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Help? &lt;img class="lia-deferred-image lia-image-emoji" src="https://www.dropboxforum.com/html/@FBF7D2AB59A0D6E861EBF6A36F93B7E2/emoticons/1f642.png" alt=":slightly_smiling_face:" title=":slightly_smiling_face:" /&gt;&lt;/P&gt;</description>
      <pubDate>Sun, 27 Dec 2015 18:56:03 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/Using-API-from-Excel-VBA/m-p/143707#M4599</guid>
      <dc:creator>Rammiz O.</dc:creator>
      <dc:date>2015-12-27T18:56:03Z</dc:date>
    </item>
    <item>
      <title>Re: Using API from Excel VBA</title>
      <link>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/Using-API-from-Excel-VBA/m-p/143708#M4600</link>
      <description>&lt;P&gt;Hey Rammiz,&lt;BR /&gt;&lt;BR /&gt;I moved away from using Dropbox for my purpose.&lt;BR /&gt;Now, from excel, I'm making a call to a PHP-webserver that returns the values to the Excel-file I need (provided by a MySQL database).&lt;/P&gt;
&lt;P&gt;So, there's no final/usable code I can provide you with. Sorry.&lt;/P&gt;</description>
      <pubDate>Sun, 27 Dec 2015 20:06:01 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/Using-API-from-Excel-VBA/m-p/143708#M4600</guid>
      <dc:creator>Gert-Jan K.</dc:creator>
      <dc:date>2015-12-27T20:06:01Z</dc:date>
    </item>
  </channel>
</rss>

