Link Excel Office.js with Powershell Dataverse (PSDataverse)

Question

我有一个excel实例，我被认证并能够访问Dataverse。我想能够使用凭证从我的excel实例能够运行PSDataverse脚本加载csv到Dataverse从我的计算机。这可能吗?

Connect-Dataverse "authority=https://login.microsoftonline.com/<tenant-id>/oauth2/authorize;clientid=<client-id>;clientsecret=<client-secret>;resource=https://<environment>.crm4.dynamics.com/"
Import-Csv "Account.csv" | ForEach-Object {
@{ Uri = "account", Method= "PATCH", Value = @{
name = $_.AccountName,
overridencreatedon = $_.CreationDate,
...}}} | ConvertTo-Json | Send-DataverseOperation

Answer 1

PSDataverse是一个PowerShell的扩展;其"home"页面在这里:https://bycode.dev/2022/07/13/introducing-psdataverse-powershells-new-super-power/

它不是Microsoft支持的，所以应该谨慎使用

GIT页面更有用https://github.com/rezanid/PSDataverse