Need to see if your shared folder is taking up space on your dropbox 👨💻? Find out how to check here.
Forum Discussion
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...
Greg-DB
Dropbox Community Moderator
Dropbox Community ModeratorTo get the original file data, you should use the /2/files/download endpoint:
https://www.dropbox.com/developers/documentation/http/documentation#files-download
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��{O i�^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
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.
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
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
About Dropbox API Support & Feedback
Find help with the Dropbox API from other developers.
