Not able to get content of excel file through api

Follow

New post

ssi_bwlogin

• February 17, 2017 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

0

• 

  jmoldow_box

  • February 17, 2017 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

  Comment actions Permalink
• 

  ssi_bwlogin

  • February 20, 2017 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

  Comment actions Permalink
• 

  ssi_bwlogin

  • February 20, 2017 04:20

  correction in api url

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

  0

  Comment actions Permalink
• 

  LoCortes

  • February 21, 2017 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

  Comment actions Permalink

Please sign in to leave a comment.