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

Question

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

Greg-DB · Answer

I&nbsp;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.

Greg-DB · Answer

To get the original file data, you should use the&nbsp;/2/files/download endpoint:
https://www.dropbox.com/developers/documentation/http/documentation#files-download&nbsp;

RajSharmahttps0 · Answer

hi greg,when i'll usehttps://content.dropboxapi.com/2/files/downloadthat 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 responsePK&#3;&#4;&#20;&#8;&#8;&#8;&#1;7�K&#11;_rels/.rels���J&#3;1&#16;��}��{w�&#21;Dd���ЛH}����a7�0&#25;u}{�&#8;Z��&#7;�I~��7C��&#18;f���G�Fo�Z+���&#24;{��&#14;��&#27;�kW�#�VJ$&#15;cʪ��l� �n&#1;�&#27;0�\Q�X^:�`�&#28;��d�d{�m]_&#3;�d������h���V�������F�w�^&#2;F9��W��-�(F/3�&#17;O�DSU�&#26;N�l/w�{N&#8;(�[���q��T����u&lt;��r�?&#19;焮�s9�&#8;F����M��h���'h?PK&#7;&#8;f����;&#2;PK&#3;&#4;&#20;&#8;&#8;&#8;&#1;7�K&#16;docProps/app.xml��1&#11;�0&#16;&#5;ཿB�kl�R$�R:w��Crj��Ir&#21;��M)Խ����{�]��-&#16;�#�@ȿI��&#25;�@���Tw&#20;�/&#22;V&#3;{�v,)`�J&#3;&amp;&#15;l &#24;-&#28;��&#30;�x�n֤&gt;��i�h�&lt;�^�_%�9bf05 �&lt;F�]�&#127;GM&#1;A&#25;j"O��{O&#31;i�^GC&#22;�a|�$�u��&gt;a&#26;���n$n[8�U��&#7;$�[���&#1;��NY7�G��&#127;U�wPK&#7;&#8;ٚ��=&#1;�&#4;PK&#1;&#2;&#20;&#20;&#8;&#8;&#8;&#1;7�Kf����;&#2;&#11;_rels/.relsPK&#1;&#2;&#20;&#20;&#8;&#8;&#8;&#1;7�K�Ù��&#11;&#1;&#16;&#25;&#1;docProps/app.xmlPK&#1;&#2;&#20;&#20;&#8;&#8;&#8;&#1;7�K��s���&#1;&#17;�&#1;docProps/core.xmlPK&#1;&#2;&#20;&#20;&#8;&#8;&#8;&#1;7�KO��z�%&#2;&#26;(&#3;xl/_rels/workbook.xml.relsPK&#1;&#2;&#20;&#20;&#8;&#8;&#8;&#1;7�K���p��&#1;&#20;B&#4;xl/sharedStrings.xmlPK&#1;&#2;&#20;&#20;&#8;&#8;&#8;&#1;7�K�zz&#3;�&amp;&#1;#m&#5;xl/worksheets/_rels/sheet1.xml.relsPK&#1;&#2;&#20;&#20;&#8;&#8;&#8;&#1;7�K-� ��&#4;�&#16;&#24;p&#6;xl/worksheets/sheet1.xmlPK&#1;&#2;&#20;&#20;&#8;&#8;&#8;&#1;7�K�:�&#15;�&#2;H&#21; 9&#11;xl/styles.xmlPK&#1;&#2;&#20;&#20;&#8;&#8;&#8;&#1;7�K�W���&#1;�&#2;&#15;Z&#14;xl/workbook.xmlPK&#1;&#2;&#20;&#20;&#8;&#8;&#8;&#1;7�Kٚ��=&#1;�&#4;&#19;1&#16;[Content_Types].xmlPK&#5;&#6;&nbsp;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.&nbsp;&nbsp;

Greg-DB · Answer

The&nbsp;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.&nbsp;
How to parse or read Excel files is outside what&nbsp;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 · Answer

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&nbsp;
post=&gt;https://content.dropboxapi.com/2/files/download
Authorization:Bearer&nbsp;&lt;REDACTED&gt;Dropbox-API-Arg:{"path":"/FileName.xlsx"}
&nbsp;
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

Forum Discussion

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

7 Replies

About Dropbox API Support & Feedback

Related Content

Automatically Open Excel Doc in MS Excel in Dropbox

Dropbox pulling incomplete excel documents

Request to complete Dropbox setup

Excel File Displaying Chinese Characters.

We've shared an Excel file with other users, but they can't edit it in Excel

Recent Discussions

file_requests.create isn't appearing as an option in app permissions

AuthError "files.content.read" does not match scopes of token

LoadingView

Is there any way to tell from the content of an api request which of my Dropbox Apps being used?

Can't create new folder at root level of Dropbox using API