Not able to get content of excel file through api
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
-
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 omittedfor .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
サインインしてコメントを残してください。
コメント
4件のコメント