cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements
Want to learn some quick and useful tips to make your day easier? Check out how Calvin uses Replay to get feedback from other teams at Dropbox here.

Dropbox API Support & Feedback

Find help with the Dropbox API from other developers.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

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

RajSharmahttps0
Explorer | Level 4

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 dropbox excell file 

can anyone tell me what is i am doing wrong.

Is there any http request available by that we can get actual data of excell which its present in dropbox.

thnaks

7 Replies 7

Greg-DB
Dropbox Staff

To get the original file data, you should use the /2/files/download endpoint:

https://www.dropbox.com/developers/documentation/http/documentation#files-download 

RajSharmahttps0
Explorer | Level 4

hi greg,

when i'll use

https://content.dropboxapi.com/2/files/download
that request then i m getting excell data in encode or in that language by that we can't able to read it .

when i'll use that url to get data of excell file then i m getting this response

PK7�K _rels/.rels���J1��}��{w�Dd���ЛH}����a7�0u}{�Z���I~��7C��f���G�Fo�Z+���{�����kW�#�VJ$cʪ��l� �n�0�\Q�X^:�`���d�d{�m]_�d������h���V�������F�w�^F9��W��-�(F/3�O�DSU�N�l/w�{N(�[���q��T����u<��r�?焮�s9�F����M��h���'h?PKf����;PK7�KdocProps/app.xml��1 �0ཿB�kl�R$�R:w��Crj��Ir��M)Խ����{�]��-�#�@ȿI���@���Tw�/V{�v,)`�J&l -���x�n֤>��i�h�<�^�_%�9bf05 �<F�]�GMAj"O��{Oi�^GC�a|�$�u��>a���n$n[8�U��$�[�����NY7�G��U�wPKٚ��=�PK7�Kf����; _rels/.relsPK7�K�Ù�� docProps/app.xmlPK7�K��s����docProps/core.xmlPK7�KO��z�%(xl/_rels/workbook.xml.relsPK7�K���p��Bxl/sharedStrings.xmlPK7�K�zz�&#mxl/worksheets/_rels/sheet1.xml.relsPK7�K-� ���pxl/worksheets/sheet1.xmlPK7�K�:��H 9 xl/styles.xmlPK7�K�W����Zxl/workbook.xmlPK7�Kٚ��=�1[Content_Types].xmlPK

 

So can u tell me how i need use that thing. i m not able to undrestandhow i need to use it. Its giving data of csv is fine but for excell its not working.

Can u tell me about this. 

 

Greg-DB
Dropbox Staff

The Dropbox API is returning the original file data, which is what you're seeing above. Exactly what/how you use that data is up to you. 

How to parse or read Excel files is outside what Dropbox API support can help with unfortunately. You may wish to refer to documentation for the Excel file format for information on how to use it.

RajSharmahttps0
Explorer | Level 4

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
Dropbox Staff

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
Explorer | Level 4

 

Screenshot from 2019-01-09 19-22-54.png

 

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
Dropbox Staff

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.

Need more support?
Who's talking

Top contributors to this post

  • User avatar
    Greg-DB Dropbox Staff
  • User avatar
    RajSharmahttps0 Explorer | Level 4
What do Dropbox user levels mean?