cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Known issues updated. Learn more

March contest: Post your Paper workflow to win a Dropbox t-shirt and tote bag!

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

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

Dropboxer

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

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

Reply
Loading...

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

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. 

 

Reply
Loading...

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

Dropboxer

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.

Reply
Loading...

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

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

Reply
Loading...

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

Dropboxer

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

Reply
Loading...

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

 

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

Reply
Loading...
Highlighted

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

Dropboxer

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.

Reply
Loading...
API Support

Have a question? Our Dropbox Community is here to help you find an answer!
You won’t have to wait too long for a reply, but why not learn more about the Community while you’re here.

Not the right discussion for you? Find out what else our Community has to say about API Support.

Or, search our Help Center for even more.