Create or update Json file in Sharepoint Online Document library | Add-PnPFile : Cannot bind parameter 'Stream'. Cannot convert the value of type "System.String" to type "System.IO.Stream".

Question

Hello,

I am trying to fetch data and update data from a JSON file stored in SPO using a azure runbook. So far I am able to fetch data and use it in the powershell script/runbook but I am unable to create a new json file or update it.

Fetching data:-

]2

I am unable to create a new json file or any file in document library

Answer 1

Hi @Hitender Singh ,

What's the type of parameter $a? Is it a string? If so you need to convert it to Stream type to make it work. Below is my demo code for you:

$a='[  
    {  
        "test": "A",  
        "id": 1  
    },  
    {  
        "test": "B",  
        "id": 2  
    },  
    {  
        "test": "C",  
        "id": 3  
    }  
]'  
$stream = [IO.MemoryStream]::new([Text.Encoding]::UTF8.GetBytes($a))  
Add-pnpfile -Folder "Shared Documents" -FileName "test.json" -Stream $stream  -Values @{Modified="1/5/2021"}  

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
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.