Child Item

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

RajSharmahttps0

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

Find more posts tagged with

API

Abuse

Comments

Greg-DB

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

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��&#25;�@��Tw&#20;�/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 9xl/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.

RajSharmahttps0

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

RajSharmahttps0

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

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.