Create New Synapse Link Profile

[benwebster-Janusintl]

Is there some way, any way at all to create a new Azure Synapse Link using the functions from this module?

$hashtable = @{
name = "glblsttest2"
datalakefolder = "glblsttest2"
}
New-CrmRecord -conn $connection -EntityLogicalName 'synapselinkprofile' -Fields $hashtable

As a simple test example, I try to create a new CRM record using the above commands, but results in the below error. Am I completely off the trail here, or is there some way to provide the datalakefolder property in a format that the command will accept?

************ FaultException1 - Create : synapselinkprofile |=> Invalid value type for attribute: datalakefolder of
entity: synapselinkprofile, Expected Type: lookup, Actual Type: System.String
Invalid value type for attribute: datalakefolder of entity: synapselinkprofile, Expected Type: lookup, Actual Type:
System.String => Invalid value type for attribute: datalakefolder of entity: synapselinkprofile, Expected Type:
lookup, Actual Type: System.String[TerminalFailure] Failed to Execute Command - Create :
RequestID=074f9fcc-e71b-45af-a22d-5c1489427d33 : synapselinkprofile duration=00:00:01.2819665 ExceptionMessage =
Invalid value type for attribute: datalakefolder of entity: synapselinkprofile, Expected Type: lookup, Actual Type:
System.String
Invalid value type for attribute: datalakefolder of entity: synapselinkprofile, Expected Type: lookup, Actual Type:
System.String => Invalid value type for attribute: datalakefolder of entity: synapselinkprofile, Expected Type:
lookup, Actual Type: System.String
At C:\Users\ben.webster\OneDrive - Janus International
Group\Documents\WindowsPowerShell\Modules\Microsoft.Xrm.Data.Powershell\2.8.21\Microsoft.Xrm.Data.Powershell.psm1:440
char:9
+ throw LastCrmConnectorException($conn)
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : OperationStopped: (************ Fa...: System.String:String) [], RuntimeException
+ FullyQualifiedErrorId : ************ FaultException1 - Create : synapselinkprofile |=> Invalid value type for a
ttribute: datalakefolder of entity: synapselinkprofile, Expected Type: lookup, Actual Type: System.String
Invalid value type for attribute: datalakefolder of entity: synapselinkprofile, Expected Type: lookup, Actual Type
: System.String => Invalid value type for attribute: datalakefolder of entity: synapselinkprofile, Expected Type:
lookup, Actual Type: System.String[TerminalFailure] Failed to Execute Command - Create : RequestID=074f9fcc-e71b-4
5af-a22d-5c1489427d33 : synapselinkprofile duration=00:00:01.2819665 ExceptionMessage = Invalid value type for att
ribute: datalakefolder of entity: synapselinkprofile, Expected Type: lookup, Actual Type: System.String
Invalid value type for attribute: datalakefolder of entity: synapselinkprofile, Expected Type: lookup, Actual Type
: System.String => Invalid value type for attribute: datalakefolder of entity: synapselinkprofile, Expected Type:
lookup, Actual Type: System.String

[seanmcne]

It might be possible, this isn't something I have tried myself but to help with the issue it looks like it's probably just a datatype mismatch where you'll need to use lookup datatype instead of a string: "datalakefolder of entity: synapselinkprofile, Expected Type: lookup, Actual Type: System.String". NOTE: I'm not sure if this is something can be done without doing the operation through PPAC as it appears to require a lot of various records configured that may refer back to other configuration outside of dataverse - but if you have the information you need you can give it a try but you will want to make sure you are using lookups to other entities instead of string GUID's.

To construct a lookup to the datalakefolder entity you can try this:
$strGuid = 'a3ec4d3e-8257-41ff-a8ad-dc547378f6e1'
$entityReference = New-CrmEntityReference -EntityLogicalName "datalakefolder" -id $strGuid)

References:

• https://learn.microsoft.com/en-us/power-apps/developer/data-platform/reference/entities/synapselinkprofile
• https://learn.microsoft.com/en-us/power-apps/developer/data-platform/reference/entities/datalakefolder
• Example of creating a lookup: https://github.com/seanmcne/Microsoft.Xrm.Data.PowerShell.Samples/blob/712e552197bced0e4c1649adcaf69ce4693062c6/EntityOperations/IncidentClose.ps1#L7