Microsoft Dynamics 365 | Integration, Dataverse...

Powershell to move word doc

(0) Share

Report

Posted on by brownfield1

464

Has anyone used powershell to move word docs from one environment to another? I don't want to use xrmtoolbox, if possible.

All responses (2)

Answers (0)

Suggested answer

DAnny3211 9,278 Moderator on at

Like (0)

Report

RE: Powershell to move word doc

hi

it is possible to use PowerShell to move Word documents from one environment to another in Dynamics 365. Here's a basic script that you can use as a starting point:

powershell:

# Set variables

$sourceUrl = "source.crm.dynamics.com"

$sourceUsername = "sourceuser@domain.com"

$sourcePassword = "sourcepassword"

$sourceDocumentLibraryName = "Documents"

$sourceDocumentName = "MyDocument.docx"

$destinationUrl = "destination.crm.dynamics.com"

$destinationUsername = "destinationuser@domain.com"

$destinationPassword = "destinationpassword"

$destinationDocumentLibraryName = "Documents"

# Get source file

$sourceContext = New-Object Microsoft.PowerShell.Commands.WebRequestSession

$sourceContext.Credentials = New-Object System.Net.NetworkCredential($sourceUsername, $sourcePassword)

$sourceFileUrl = "$sourceUrl/$sourceDocumentLibraryName/$sourceDocumentName"

$sourceFileContent = Invoke-WebRequest -Uri $sourceFileUrl -WebSession $sourceContext

$sourceFileBytes = [System.Convert]::FromBase64String($sourceFileContent.Content)

# Upload file to destination

$destinationContext = New-Object Microsoft.PowerShell.Commands.WebRequestSession

$destinationContext.Credentials = New-Object System.Net.NetworkCredential($destinationUsername, $destinationPassword)

$destinationFileUrl = "$destinationUrl/$destinationDocumentLibraryName/$sourceDocumentName"

Invoke-RestMethod -Uri $destinationFileUrl -Method Put -Body $sourceFileBytes -WebSession $destinationContext

You'll need to replace the values of the variables at the top of the script with your own environment information. The script uses the Invoke-WebRequest cmdlet to download the file from the source environment and the Invoke-RestMethod cmdlet to upload it to the destination environment.

DAniele
Leah Ju Microsoft Employee on at

Like (0)

Report

RE: Powershell to move word doc

Hi brownfield1,

Or you can try to migrate data between Microsoft Dataverse environments using the dataflows OData connector

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/dataverse-odata-dataflows-migration