Need to see if your shared folder is taking up space on your dropbox 👨‍💻? Find out how to check here.

Forum Discussion

RajSharmahttps0's avatar
RajSharmahttps0
Explorer | Level 4
8 years ago

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

  • RajSharmahttps0's avatar
    RajSharmahttps0
    Explorer | Level 4
    8 years ago

    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's avatar
    Greg-DB
    Icon for Dropbox Community Moderator rankDropbox Community Moderator
    8 years ago

    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's avatar
    RajSharmahttps0
    Explorer | Level 4
    8 years ago

    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's avatar
    Greg-DB
    Icon for Dropbox Community Moderator rankDropbox Community Moderator
    8 years ago

    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's avatar
    RajSharmahttps0
    Explorer | Level 4
    7 years ago

     

     

    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's avatar
    Greg-DB
    Icon for Dropbox Community Moderator rankDropbox Community Moderator
    7 years ago

    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.

About Dropbox API Support & Feedback

Node avatar for Dropbox API Support & Feedback
Find help with the Dropbox API from other developers.

The Dropbox Community team is active from Monday to Friday. We try to respond to you as soon as we can, usually within 2 hours.

If you need more help you can view your support options (expected response time for an email or ticket is 24 hours), or contact us on X, Facebook or Instagram.

For more info on available support options for your Dropbox plan, see this article.

If you found the answer to your question in this Community thread, please 'like' the post to say thanks and to let us know it was useful!