Not able to get content of excel file through api

新規投稿

2017年02月17日 04:09

Hi,

I am using box to upload a file and download it from there using download file api. However, it was working fine till i was using only .csv. Now we increased our scope and uploading .xlsx file also, but api is failing to read the excel file erroring out. Can you please provide solution for this

4件のコメント

jmoldow_box

2017年02月17日 09:09
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?
0

コメントアクションパーマリンク
ssi_bwlogin

2017年02月20日 01:50
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
0

コメントアクションパーマリンク
ssi_bwlogin

2017年02月20日 04:20
correction in api url
https://api.box.com/2.0/files/{FileID}/content
0

コメントアクションパーマリンク
LoCortes

2017年02月21日 08:42
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
0

コメントアクションパーマリンク

サインインしてコメントを残してください。