Is there a way to send output from PowerShell directly into a SharePoint ONLINE library?

Question

question

ajrockwellga asked Apr 29, '22 RaytheonXie-MSFT commented May 10, '22

Is there a way to send output from PowerShell directly into a SharePoint ONLINE library?

I have seen dozens of questions like this and every one of them is answered with how to UPLOAD a file to SharePoint Online from within PowerShell. That is NOT the same thing and is not the question that I am asking.

I am trying to develop a script that will generate a simple csv and store it in a SharePoint Online library. Eventually I want to move this to utilize Azure Automation and schedule this activity.
Thus the output file from the PowerShell script cannot be stored locally, it must be generated directly into SharePoint Online.

Can this be accomplished with PowerShell?

office-sharepoint-online windows-server-powershell

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 1 · 2022-05-02T03:18:22.733Z

RaytheonXie-MSFT answered May 2, '22 RaytheonXie-MSFT commented May 10, '22

Hi @ajrockwellga ,
Per my research, there is no such function to Generate files directly in SharePoint. I feel regretful to inform you that it turns out to be a by-design one.

And I noticed that some end users have also proposed the same request, it is highly recommended that you can vote this ticket. Many features of our current products are designed and upgraded based on customers’ feedback. With requirements like this increase, the problem may well be released in the future. Thanks for your understanding.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

· 2

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

RaytheonXie-MSFT · May 09 at 07:29 AM

Hi @ajrockwellga ,
Would you tell me whether your issue has been resolved or have any update?
I am looking forward to your reply.

Have a nice day!

Thanks,
Raytheon Xie

0 ·

RaytheonXie-MSFT · May 10 at 09:38 AM

Hi @ajrockwellga ,
I am checking to see how things are going there on this issue.

0 ·

Answer 2 · 2022-05-09T14:12:44.453Z

RichMatheisen-8856 answered May 9, '22

Would one of the .Net WebClient classes method work? Something like this, maybe? webclient-uploadstring

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

question