Can't connect to API that uses POST (Dropbox)

NathanMoyle — Wed, 07 Jul 2021 09:02:42 GMT

Hi, I am trying to connect to the dropbox API but keep getting a 404 error. The documentation gives me this example, whcih works well in command promt:

curl -X POST https://api.dropboxapi.com/2/team_log/get_events \
    --header "Authorization: Bearer <Hidden access token>" \
    --header "Content-Type: application/json" \
    --data "{\"limit\": 50,\"category\": \"groups\"}"

I then tried making this work in power query with the following code:

let access = "Bearer <Hidden Access Token>", Source = Json.Document(Web.Contents("https://api.dropboxapi.com/2/team_log/get_events",[Query=[limit="50"],Headers=[#"Content-Type"="application/json",Authorization=access]])) in Source

I think the problem is that the API used POST but Web.Contents defaults to GET. I couldnt find any helpful information anywhere to tell me how to use POST

Re: Can't connect to API that uses POST (Dropbox)

Anonymous — Fri, 09 Jul 2021 06:34:12 GMT

Hi @NathanMoyle ,

Please review the content in the following links and hope they can help you resolve the problem.

Connecting to data source hosted on Dropbox (check message 23 from @masplin)

Power BI service and Dropbox

Import multiple files from Dropbox folder into PowerBI and Excel (via PowerQuery) at once

Best Regards

topic Can't connect to API that uses POST (Dropbox) in Developer

Can't connect to API that uses POST (Dropbox)

Re: Can't connect to API that uses POST (Dropbox)