converting form API1 to API 2 on Power Query

Hi Mike, it looks like you were using the API v1 /files endpoint to download the file content. In API v2, the replacement is /files/download.

The standard way of using that endpoint is via a POST with 'Authorization' and 'Dropbox-API-Arg' headers, as shown in the example in the documentation in the "Request and response formats" section.

If you need to be able to just make a GET to it instead though, that is also supported by using the URL parameters documented 

So, using the example you posted, that would look like:

https://content.dropboxapi.com/2/files/download?authorization=Bearer%20ACCESS_TOKEN_HERE&arg=%7B%22path%22%3A%22%2FDataModel%2FSourceFiles%2FDates.xlsx%22%7D

Replace ACCESS_TOKEN_HERE with your access token.

By the way, I redacted it from your post, but since you initially posted your access token, for the sake of security, you should disable that access token. You can do so by revoking access to the app entirely, if the access token is for your account on the account security page. Or, you can disable just this access token using the API. You would need to then get a new access token and plug that in to your app instead.

By the way, if you need more time to migrate your app to API v2, we can offer an extension for access to API v1. To request that, please open an API ticket with the relevant app key(s).

That was a bit stupid of me. So do I just delete the app by going to conencted app and then remove the linked app? Then recreate it?

Thanks

Mike

got it thanks