Need to see if your shared folder is taking up space on your dropbox 👨‍💻? Find out how to check here.

Forum Discussion

RajSharmahttps0's avatar
RajSharmahttps0
Explorer | Level 4
8 years ago

I m not able to get of dropbox excel using http request

i want to get data of excel from http request  https://content.dropboxapi.com/2/files/get_preview i m getting data in html.But in that is not giving proper data which is present ectually present in...
API
RajSharmahttps0's avatar
RajSharmahttps0
Explorer | Level 4
8 years ago

hi,

what ever u said its fine.

but when i m using dropbox api request for getting a excel data from my dropbox account what ever file is present in my account, i want to read that thing using dropbox api request for that i m using this request 

post=>https://content.dropboxapi.com/2/files/download

Authorization:Bearer <REDACTED>
Dropbox-API-Arg:{"path":"/FileName.xlsx"}

 

Then i getting this response which i have sent you earlier.

i want to know that how i can get orignal data of excel file which is present in my dropbox account using dropbox api.

Can you tell me.

thanks

Greg-DB's avatar
Greg-DB
Icon for Dropbox Community Moderator rankDropbox Community Moderator
8 years ago

The response body you get from a successful /2/files/download API call is the actual file data for that file as synced on Dropbox. You're currently printing out the raw data, which won't be very helpful, since the Excel format is not a plain text format. Exactly what you should actually do with it is up to you and will depend on your use case. E.g., save it to the local filesystem instead.

By the way, I redacted it from your post, but for the sake of security, you should disable that access token that you posted publicly. You can do so by revoking access to the app entirely, if the access token is for your account, here:

https://www.dropbox.com/account/connected_apps

Or, you can disable just this access token using the API:

https://dropbox.github.io/dropbox-api-v2-explorer/#auth_token/revoke

  • RajSharmahttps0's avatar
    RajSharmahttps0
    Explorer | Level 4
    7 years ago

     

     

    Hi Greg,

    Thanks for replying i am still not able to download a XLSX file from dropbox using HTTP request as i mention earlier.

    I am still facing the same issue, can you pass my request to some technical support kind of person where they can show to any path regarding download a XLSX file from dropbox.

    There is some encrypted data came while i sending a http request like that in image which i have share to you.

    Can you tell me how i can decrypt that data into readable from, or can u ask some technical support people once please.

    thanks 

    Raj sharma

    • Greg-DB's avatar
      Greg-DB
      Icon for Dropbox Community Moderator rankDropbox Community Moderator
      7 years ago

      I can help with technical support questions for the API here.

      Your screenshot shows a successful API call, and the response is the data for the xlsx file that is stored on Dropbox. Postman is just printing out that data, but to actually use it, you'll probably want to save that data to your local filesystem. From there, you can open it in Excel, etc.

      Please refer to the documentation for Postman (or whatever other HTTPS client you're using) for information on how to use it to save the data to the local filesystem, etc.

About Dropbox API Support & Feedback

Node avatar for Dropbox API Support & Feedback
Find help with the Dropbox API from other developers.

The Dropbox Community team is active from Monday to Friday. We try to respond to you as soon as we can, usually within 2 hours.

If you need more help you can view your support options (expected response time for an email or ticket is 24 hours), or contact us on X, Facebook or Instagram.

For more info on available support options for your Dropbox plan, see this article.

If you found the answer to your question in this Community thread, please 'like' the post to say thanks and to let us know it was useful!