Uploading Data (not a file) to a Box file

Completed

Follow

New post

Gary Culshaw

• January 27, 2023 00:34

We have a dataset in Power BI that we want to upload to a file in Box. It is able to be done if we first store the data into a file, so then the file can be uploaded to Box.

eg:

df.to_csv(out_file_name)

new_file = client.folder(Box_Folder_ID).upload(out_file_name)

What if we don't want to save it to a temporary file. We just want to directly put the dataset data into a file in Box? Is that possible.?

 

 

 

 

 

0

• 

  France

  • January 27, 2023 17:41

  Hi Gary, 

  Welcome to the Box Community, I'm happy to help!

  This would be something our Product Support team would like to look into and may require specific account information. 

  I've gone ahead and created a ticket for you so that an agent can work directly with you on looking into this. 

  Kindly check your email for details and updates.

  Best regards, 

  0

  Comment actions Permalink
• 

  Gary Culshaw

  • January 30, 2023 17:50

  I have the answer!

   

      csv_string = df.to_csv(index=False)
      stream = StringIO()
      stream.write(csv_string)
      stream.seek(0)
      new_file = client.folder(Box_Folder_ID).upload_stream(stream,Name_of_Box_File)

   

  0

  Comment actions Permalink

Please sign in to leave a comment.