Not able to get content of excel file through api

Please provide the exact steps / API calls you are making, and the full error message you are receiving.

Are you using one of our SDKs? If so, which one? If not, how are you making API calls?

I am making request at : api.box.com:443//2.0/files/{FileID}/content

with Authorization

for content-type i tried : application/json, application/octet-stream, text/csv

file can be .xlsx and .xls

Error msg

for .xlsx:

at com.tibco.bx.debug.CoreDebugger.createVariable(CoreDebugger.java:960) [com.tibco.bx.debug.core_1.12.200.004.jar:na]
at com.tibco.bx.debug.CoreDebugger.listVariables(CoreDebugger.java:873) [com.tibco.bx.debug.core_1.12.200.004.jar:na]
at com.tibco.bx.debug.CoreDebugger.onEvent(CoreDebugger.java:1291) [com.tibco.bx.debug.core_1.12.200.004.jar:na]
at com.tibco.bx.monitor.ActivityMonitorCallback.monitorEventReturn(ActivityMonitorCallback.java:51) [com.tibco.bx.core_1.12.205.001.jar:na]
at com.tibco.bx.debug.DebugMonitorCallback.monitorEventReturn(DebugMonitorCallback.java:37) [com.tibco.bx.debug.core_1.12.200.004.jar:na]
at com.tibco.bx.monitor.ActivityMonitorCallback.monitorEventReturn(ActivityMonitorCallback.java:1) [com.tibco.bx.core_1.12.205.001.jar:na]
at com.tibco.pvm.infra.util.debug.IpmDebuggerKernelImpl.a(IpmDebuggerKernelImpl.java:269) [com.tibco.pvm.core.debug_3.8.205.001.jar:na]
at com.tibco.pvm.infra.util.debug.IpmDebuggerKernelImpl.a(IpmDebuggerKernelImpl.java:347) [com.tibco.pvm.core.debug_3.8.205.001.jar:na]
at com.tibco.pvm.infra.util.debug.IpmDebuggerKernelImpl.a(IpmDebuggerKernelImpl.java:320) [com.tibco.pvm.core.debug_3.8.205.001.jar:na]
at com.tibco.pvm.infra.util.debug.IpmDebuggerKernelImpl$1.a(IpmDebuggerKernelImpl.java:557) [com.tibco.pvm.core.debug_3.8.205.001.jar:na]
at com.tibco.pvm.infra.util.debug.IpmDebuggerKernelImpl$1.monitorEventReturn(IpmDebuggerKernelImpl.java:1) [com.tibco.pvm.core.debug_3.8.205.001.jar:na]
at com.tibco.pvm.infra.api.impl.util.director.IpmEventDirectorBase.monitorReturn(IpmEventDirectorBase.java:449) [com.tibco.pvm.core.infra_3.8.205.001.jar:na]
at com.tibco.pvm.infra.support.work.impl.WorkItemAbstract.afterExecute(WorkItemAbstract.java:102) [com.tibco.pvm.core.infra_3.8.205.001.jar:na]
at com.tibco.pvm.im.rt.xm.util.work.ImxSTWorkRunnable.doWorkBlock(ImxSTWorkRunnable.java:179) [com.tibco.pvm.im.rt.xm_3.8.205.002.jar:na]
at com.tibco.pvm.infra.services.engine.impl.STWorkRunnable.run(STWorkRunnable.java:50) [com.tibco.pvm.core.infra_3.8.205.001.jar:na]
at com.tibco.pvm.im.rt.xm.util.work.ImxSTWorkRunnable.run(ImxSTWorkRunnable.java:62) [com.tibco.pvm.im.rt.xm_3.8.205.002.jar:na]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [na:1.7.0_85]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.7.0_85]
at java.lang.Thread.run(Unknown Source) [na:1.7.0_85]
Caused by: org.genxdm.exceptions.GenXDMException: com.ctc.wstx.exc.WstxIOException: Invalid white space character (0x3) in text to output
at org.genxdm.processor.output.ContentHandlerOnXmlStreamWriter.text(ContentHandlerOnXmlStreamWriter.java:202) ~[org.genxdm.processor.io_1.1.0.jar:na]
at com.tibco.genxdm.bridge.xinode.XiModel.deepCopyText(XiModel.java:189) ~[com.tibco.genxdm.bridge.xinode_1.1.301.001.jar:na]
at com.tibco.genxdm.bridge.xinode.XiModel.deepCopyNode(XiModel.java:153) ~[com.tibco.genxdm.bridge.xinode_1.1.301.001.jar:na]
at com.tibco.genxdm.bridge.xinode.XiModel.deepCopyChildren(XiModel.java:117) ~[com.tibco.genxdm.bridge.xinode_1.1.301.001.jar:na]
at com.tibco.genxdm.bridge.xinode.XiModel.deepCopyNode(XiModel.java:148) ~[com.tibco.genxdm.bridge.xinode_1.1.301.001.jar:na]
at com.tibco.genxdm.bridge.xinode.XiModel.deepCopyChildren(XiModel.java:117) ~[com.tibco.genxdm.bridge.xinode_1.1.301.001.jar:na]
at com.tibco.genxdm.bridge.xinode.XiModel.deepCopyNode(XiModel.java:148) ~[com.tibco.genxdm.bridge.xinode_1.1.301.001.jar:na]
at com.tibco.genxdm.bridge.xinode.XiModel.deepCopyChildren(XiModel.java:117) ~[com.tibco.genxdm.bridge.xinode_1.1.301.001.jar:na]
at com.tibco.genxdm.bridge.xinode.XiModel.deepCopyNode(XiModel.java:148) ~[com.tibco.genxdm.bridge.xinode_1.1.301.001.jar:na]
at com.tibco.genxdm.bridge.xinode.XiModel.stream(XiModel.java:1030) ~[com.tibco.genxdm.bridge.xinode_1.1.301.001.jar:na]
at com.tibco.genxdm.bridge.xinode.XiModel.stream(XiModel.java:1) ~[com.tibco.genxdm.bridge.xinode_1.1.301.001.jar:na]
at org.genxdm.processor.io.DefaultSerializer.write(DefaultSerializer.java:73) ~[org.genxdm.processor.io_1.1.0.jar:na]
at org.genxdm.processor.io.ValidatingDocumentHandler.write(ValidatingDocumentHandler.java:39) ~[org.genxdm.processor.io_1.1.0.jar:na]
at com.tibco.pvm.infra.dataexch.xml.genxdm.serializers.persist.util.IpmxGenxSerializerImpl.serializeNode(IpmxGenxSerializerImpl.java:256) ~[com.tibco.pvm.dataexch.xml.genxdm_3.8.200.001.jar:na]
at com.tibco.pvm.infra.dataexch.xml.genxdm.IpmxGenxProcessDataEnvImpl.serializeNode(IpmxGenxProcessDataEnvImpl.java:142) ~[com.tibco.pvm.dataexch.xml.genxdm_3.8.200.001.jar:na]
at com.tibco.bx.debug.CoreDebugger.createVariable(CoreDebugger.java:952) [com.tibco.bx.debug.core_1.12.200.004.jar:na]
... 18 common frames omitted

for .xls:

at com.tibco.bx.debug.CoreDebugger.createVariable(CoreDebugger.java:960) [com.tibco.bx.debug.core_1.12.200.004.jar:na]
at com.tibco.bx.debug.CoreDebugger.listVariables(CoreDebugger.java:873) [com.tibco.bx.debug.core_1.12.200.004.jar:na]
at com.tibco.bx.debug.CoreDebugger.onEvent(CoreDebugger.java:1291) [com.tibco.bx.debug.core_1.12.200.004.jar:na]
at com.tibco.bx.monitor.ActivityMonitorCallback.monitorEventReturn(ActivityMonitorCallback.java:51) [com.tibco.bx.core_1.12.205.001.jar:na]
at com.tibco.bx.debug.DebugMonitorCallback.monitorEventReturn(DebugMonitorCallback.java:37) [com.tibco.bx.debug.core_1.12.200.004.jar:na]
at com.tibco.bx.monitor.ActivityMonitorCallback.monitorEventReturn(ActivityMonitorCallback.java:1) [com.tibco.bx.core_1.12.205.001.jar:na]
at com.tibco.pvm.infra.util.debug.IpmDebuggerKernelImpl.a(IpmDebuggerKernelImpl.java:269) [com.tibco.pvm.core.debug_3.8.205.001.jar:na]
at com.tibco.pvm.infra.util.debug.IpmDebuggerKernelImpl.a(IpmDebuggerKernelImpl.java:347) [com.tibco.pvm.core.debug_3.8.205.001.jar:na]
at com.tibco.pvm.infra.util.debug.IpmDebuggerKernelImpl.a(IpmDebuggerKernelImpl.java:320) [com.tibco.pvm.core.debug_3.8.205.001.jar:na]
at com.tibco.pvm.infra.util.debug.IpmDebuggerKernelImpl$1.a(IpmDebuggerKernelImpl.java:557) [com.tibco.pvm.core.debug_3.8.205.001.jar:na]
at com.tibco.pvm.infra.util.debug.IpmDebuggerKernelImpl$1.monitorEventReturn(IpmDebuggerKernelImpl.java:1) [com.tibco.pvm.core.debug_3.8.205.001.jar:na]
at com.tibco.pvm.infra.api.impl.util.director.IpmEventDirectorBase.monitorReturn(IpmEventDirectorBase.java:449) [com.tibco.pvm.core.infra_3.8.205.001.jar:na]
at com.tibco.pvm.infra.support.work.impl.WorkItemAbstract.afterExecute(WorkItemAbstract.java:102) [com.tibco.pvm.core.infra_3.8.205.001.jar:na]
at com.tibco.pvm.im.rt.xm.util.work.ImxSTWorkRunnable.doWorkBlock(ImxSTWorkRunnable.java:179) [com.tibco.pvm.im.rt.xm_3.8.205.002.jar:na]
at com.tibco.pvm.infra.services.engine.impl.STWorkRunnable.run(STWorkRunnable.java:50) [com.tibco.pvm.core.infra_3.8.205.001.jar:na]
at com.tibco.pvm.im.rt.xm.util.work.ImxSTWorkRunnable.run(ImxSTWorkRunnable.java:62) [com.tibco.pvm.im.rt.xm_3.8.205.002.jar:na]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [na:1.7.0_85]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.7.0_85]
at java.lang.Thread.run(Unknown Source) [na:1.7.0_85]
Caused by: org.genxdm.exceptions.GenXDMException: com.ctc.wstx.exc.WstxIOException: Invalid white space character (0x11) in text to output
at org.genxdm.processor.output.ContentHandlerOnXmlStreamWriter.text(ContentHandlerOnXmlStreamWriter.java:202) ~[org.genxdm.processor.io_1.1.0.jar:na]
at com.tibco.genxdm.bridge.xinode.XiModel.deepCopyText(XiModel.java:189) ~[com.tibco.genxdm.bridge.xinode_1.1.301.001.jar:na]
at com.tibco.genxdm.bridge.xinode.XiModel.deepCopyNode(XiModel.java:153) ~[com.tibco.genxdm.bridge.xinode_1.1.301.001.jar:na]
at com.tibco.genxdm.bridge.xinode.XiModel.deepCopyChildren(XiModel.java:117) ~[com.tibco.genxdm.bridge.xinode_1.1.301.001.jar:na]
at com.tibco.genxdm.bridge.xinode.XiModel.deepCopyNode(XiModel.java:148) ~[com.tibco.genxdm.bridge.xinode_1.1.301.001.jar:na]
at com.tibco.genxdm.bridge.xinode.XiModel.deepCopyChildren(XiModel.java:117) ~[com.tibco.genxdm.bridge.xinode_1.1.301.001.jar:na]
at com.tibco.genxdm.bridge.xinode.XiModel.deepCopyNode(XiModel.java:148) ~[com.tibco.genxdm.bridge.xinode_1.1.301.001.jar:na]
at com.tibco.genxdm.bridge.xinode.XiModel.deepCopyChildren(XiModel.java:117) ~[com.tibco.genxdm.bridge.xinode_1.1.301.001.jar:na]
at com.tibco.genxdm.bridge.xinode.XiModel.deepCopyNode(XiModel.java:148) ~[com.tibco.genxdm.bridge.xinode_1.1.301.001.jar:na]
at com.tibco.genxdm.bridge.xinode.XiModel.stream(XiModel.java:1030) ~[com.tibco.genxdm.bridge.xinode_1.1.301.001.jar:na]
at com.tibco.genxdm.bridge.xinode.XiModel.stream(XiModel.java:1) ~[com.tibco.genxdm.bridge.xinode_1.1.301.001.jar:na]
at org.genxdm.processor.io.DefaultSerializer.write(DefaultSerializer.java:73) ~[org.genxdm.processor.io_1.1.0.jar:na]
at org.genxdm.processor.io.ValidatingDocumentHandler.write(ValidatingDocumentHandler.java:39) ~[org.genxdm.processor.io_1.1.0.jar:na]
at com.tibco.pvm.infra.dataexch.xml.genxdm.serializers.persist.util.IpmxGenxSerializerImpl.serializeNode(IpmxGenxSerializerImpl.java:256) ~[com.tibco.pvm.dataexch.xml.genxdm_3.8.200.001.jar:na]
at com.tibco.pvm.infra.dataexch.xml.genxdm.IpmxGenxProcessDataEnvImpl.serializeNode(IpmxGenxProcessDataEnvImpl.java:142) ~[com.tibco.pvm.dataexch.xml.genxdm_3.8.200.001.jar:na]
at com.tibco.bx.debug.CoreDebugger.createVariable(CoreDebugger.java:952) [com.tibco.bx.debug.core_1.12.200.004.jar:na]
... 18 common frames omitted

correction in api url

https://api.box.com/2.0/files/{FileID}/content

 Hello ,

why do you need the content-type?

I have done a test using a Rest Client and the content returns a 302 code and a redirection to a URL at dl.boxcloud.com. Then, that URL downloads directly the document as it is (I have tested and it is downloaded as an xlsx).

Thanks