Get-AzSynapsePipeline does not work without name parameter which is not mandatory

[ssisjoost]

Description

Get-AzSynapsePipeline -WorkspaceName "xyz-we-a-saw-dp" always gives an error

Get-AzSynapsePipeline : The requested operation requires an element of type 'String', but the target element has type 'Object'.
At line:7 char:1

• Get-AzSynapsePipeline -WorkspaceName $WorkspaceName #.ToString()

•   + CategoryInfo          : CloseError: (:) [Get-AzSynapsePipeline], InvalidOperationException
  
  

unless you also provide the NOT mandatory name parameter:
Get-AzSynapsePipeline -WorkspaceName "xyz-we-a-saw-dp" -Name "PL_Master"

Which is useless if you need ALL pipelines.

Tried also older versions of the module and both Powershell 5 and Powershell core

Issue script & Debug output

Get-AzSynapsePipeline -WorkspaceName "xyz-we-a-saw-dp"
DEBUG: 18:04:27 - GetAzureSynapsePipeline begin processing with ParameterSet 'GetByName'.
DEBUG: 18:04:27 - using account id 'mysecret@email.com'...
DEBUG: 18:04:27 - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'aaaaaaaa-bbbb-cccc-dddddddddddd', Scopes:'https://dev.azuresynapse.net/.default', AuthorityHost:'https://login.microsoftonline.com/', UserId
:'mysecret@email.com'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId: 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Found 3 cache accounts and 0 broker accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Returning 3 accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] MSAL MSAL.Desktop with assembly version '4.30.1.0'. CorrelationId(bd542563-dd1d-4594-89fa-2bf209b69a09)
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === AcquireTokenSilent Parameters ===
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] LoginHint provided: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Account provided: True
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] ForceRefresh: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] 
=== Request Data ===
Authority Provided? - True
Scopes - https://dev.azuresynapse.net/.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - bd542563-dd1d-4594-89fa-2bf209b69a09

DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition (SilentRequest) started:
	
	Authority Host: login.microsoftonline.com
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Access token is not expired. Returning the found cache entry. [Current time (01/03/2023 17:04:27) - Expiration Time (01/03/2023 18:21:46 +00:00) - Extended Expirati
on Time (01/03/2023 18:21:46 +00:00)]
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Returning access token found in cache. RefreshOn exists ? False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Fetched access token from host login.microsoftonline.com. 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 01/03/2023 18:21:46 +00:00 and Scopes https://dev.azuresynapse.net/u
ser_impersonation https://dev.azuresynapse.net/.default
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId:  ExpiresOn: 2023-01-03T18:21:46.0000000+00:00
DEBUG: 18:04:27 - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'aaaaaaaa-bbbb-cccc-dddddddddddd', Scopes:'https://dev.azuresynapse.net/.default', AuthorityHost:'https://login.microsoftonline.com/', UserId
:'mysecret@email.com'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId: 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Found 3 cache accounts and 0 broker accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Returning 3 accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] MSAL MSAL.Desktop with assembly version '4.30.1.0'. CorrelationId(0dc1847f-af2d-47fd-831f-6436a6d4a583)
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === AcquireTokenSilent Parameters ===
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] LoginHint provided: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Account provided: True
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] ForceRefresh: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] 
=== Request Data ===
Authority Provided? - True
Scopes - https://dev.azuresynapse.net/.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - 0dc1847f-af2d-47fd-831f-6436a6d4a583

DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition (SilentRequest) started:
	
	Authority Host: login.microsoftonline.com
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Access token is not expired. Returning the found cache entry. [Current time (01/03/2023 17:04:27) - Expiration Time (01/03/2023 18:21:46 +00:00) - Extended Expirati
on Time (01/03/2023 18:21:46 +00:00)]
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Returning access token found in cache. RefreshOn exists ? False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Fetched access token from host login.microsoftonline.com. 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 01/03/2023 18:21:46 +00:00 and Scopes https://dev.azuresynapse.net/u
ser_impersonation https://dev.azuresynapse.net/.default
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId:  ExpiresOn: 2023-01-03T18:21:46.0000000+00:00
DEBUG: 18:04:27 - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'aaaaaaaa-bbbb-cccc-dddddddddddd', Scopes:'https://dev.azuresynapse.net/.default', AuthorityHost:'https://login.microsoftonline.com/', UserId
:'mysecret@email.com'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId: 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Found 3 cache accounts and 0 broker accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Returning 3 accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] MSAL MSAL.Desktop with assembly version '4.30.1.0'. CorrelationId(b945e3ee-ec9b-422d-ae43-f2877b96e365)
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === AcquireTokenSilent Parameters ===
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] LoginHint provided: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Account provided: True
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] ForceRefresh: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] 
=== Request Data ===
Authority Provided? - True
Scopes - https://dev.azuresynapse.net/.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - b945e3ee-ec9b-422d-ae43-f2877b96e365

DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition (SilentRequest) started:
	
	Authority Host: login.microsoftonline.com
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Access token is not expired. Returning the found cache entry. [Current time (01/03/2023 17:04:27) - Expiration Time (01/03/2023 18:21:46 +00:00) - Extended Expirati
on Time (01/03/2023 18:21:46 +00:00)]
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Returning access token found in cache. RefreshOn exists ? False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Fetched access token from host login.microsoftonline.com. 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 01/03/2023 18:21:46 +00:00 and Scopes https://dev.azuresynapse.net/u
ser_impersonation https://dev.azuresynapse.net/.default
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId:  ExpiresOn: 2023-01-03T18:21:46.0000000+00:00
DEBUG: 18:04:27 - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'aaaaaaaa-bbbb-cccc-dddddddddddd', Scopes:'https://dev.azuresynapse.net/.default', AuthorityHost:'https://login.microsoftonline.com/', UserId
:'mysecret@email.com'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId: 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Found 3 cache accounts and 0 broker accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Returning 3 accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] MSAL MSAL.Desktop with assembly version '4.30.1.0'. CorrelationId(3f2e2983-cd3d-450f-8d93-46939d9ca289)
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === AcquireTokenSilent Parameters ===
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] LoginHint provided: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Account provided: True
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] ForceRefresh: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] 
=== Request Data ===
Authority Provided? - True
Scopes - https://dev.azuresynapse.net/.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - 3f2e2983-cd3d-450f-8d93-46939d9ca289

DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition (SilentRequest) started:
	
	Authority Host: login.microsoftonline.com
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Access token is not expired. Returning the found cache entry. [Current time (01/03/2023 17:04:27) - Expiration Time (01/03/2023 18:21:46 +00:00) - Extended Expirati
on Time (01/03/2023 18:21:46 +00:00)]
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Returning access token found in cache. RefreshOn exists ? False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Fetched access token from host login.microsoftonline.com. 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 01/03/2023 18:21:46 +00:00 and Scopes https://dev.azuresynapse.net/u
ser_impersonation https://dev.azuresynapse.net/.default
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId:  ExpiresOn: 2023-01-03T18:21:46.0000000+00:00
DEBUG: 18:04:27 - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'aaaaaaaa-bbbb-cccc-dddddddddddd', Scopes:'https://dev.azuresynapse.net/.default', AuthorityHost:'https://login.microsoftonline.com/', UserId
:'mysecret@email.com'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId: 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Found 3 cache accounts and 0 broker accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Returning 3 accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] MSAL MSAL.Desktop with assembly version '4.30.1.0'. CorrelationId(3e5e2328-0584-4575-893d-5d7c28471509)
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === AcquireTokenSilent Parameters ===
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] LoginHint provided: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Account provided: True
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] ForceRefresh: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] 
=== Request Data ===
Authority Provided? - True
Scopes - https://dev.azuresynapse.net/.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - 3e5e2328-0584-4575-893d-5d7c28471509

DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition (SilentRequest) started:
	
	Authority Host: login.microsoftonline.com
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Access token is not expired. Returning the found cache entry. [Current time (01/03/2023 17:04:27) - Expiration Time (01/03/2023 18:21:46 +00:00) - Extended Expirati
on Time (01/03/2023 18:21:46 +00:00)]
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Returning access token found in cache. RefreshOn exists ? False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Fetched access token from host login.microsoftonline.com. 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 01/03/2023 18:21:46 +00:00 and Scopes https://dev.azuresynapse.net/u
ser_impersonation https://dev.azuresynapse.net/.default
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId:  ExpiresOn: 2023-01-03T18:21:46.0000000+00:00
DEBUG: 18:04:27 - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'aaaaaaaa-bbbb-cccc-dddddddddddd', Scopes:'https://dev.azuresynapse.net/.default', AuthorityHost:'https://login.microsoftonline.com/', UserId
:'mysecret@email.com'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId: 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Found 3 cache accounts and 0 broker accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Returning 3 accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] MSAL MSAL.Desktop with assembly version '4.30.1.0'. CorrelationId(a65b6927-8bdd-428f-b532-554330f15a26)
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === AcquireTokenSilent Parameters ===
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] LoginHint provided: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Account provided: True
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] ForceRefresh: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] 
=== Request Data ===
Authority Provided? - True
Scopes - https://dev.azuresynapse.net/.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - a65b6927-8bdd-428f-b532-554330f15a26

DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition (SilentRequest) started:
	
	Authority Host: login.microsoftonline.com
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Access token is not expired. Returning the found cache entry. [Current time (01/03/2023 17:04:27) - Expiration Time (01/03/2023 18:21:46 +00:00) - Extended Expirati
on Time (01/03/2023 18:21:46 +00:00)]
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Returning access token found in cache. RefreshOn exists ? False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Fetched access token from host login.microsoftonline.com. 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 01/03/2023 18:21:46 +00:00 and Scopes https://dev.azuresynapse.net/u
ser_impersonation https://dev.azuresynapse.net/.default
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId:  ExpiresOn: 2023-01-03T18:21:46.0000000+00:00
DEBUG: 18:04:27 - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'aaaaaaaa-bbbb-cccc-dddddddddddd', Scopes:'https://dev.azuresynapse.net/.default', AuthorityHost:'https://login.microsoftonline.com/', UserId
:'mysecret@email.com'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId: 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Found 3 cache accounts and 0 broker accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Returning 3 accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] MSAL MSAL.Desktop with assembly version '4.30.1.0'. CorrelationId(a07c879f-9c98-49b3-875e-454584c5e11d)
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === AcquireTokenSilent Parameters ===
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] LoginHint provided: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Account provided: True
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] ForceRefresh: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] 
=== Request Data ===
Authority Provided? - True
Scopes - https://dev.azuresynapse.net/.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - a07c879f-9c98-49b3-875e-454584c5e11d

DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition (SilentRequest) started:
	
	Authority Host: login.microsoftonline.com
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Access token is not expired. Returning the found cache entry. [Current time (01/03/2023 17:04:27) - Expiration Time (01/03/2023 18:21:46 +00:00) - Extended Expirati
on Time (01/03/2023 18:21:46 +00:00)]
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Returning access token found in cache. RefreshOn exists ? False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Fetched access token from host login.microsoftonline.com. 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 01/03/2023 18:21:46 +00:00 and Scopes https://dev.azuresynapse.net/u
ser_impersonation https://dev.azuresynapse.net/.default
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId:  ExpiresOn: 2023-01-03T18:21:46.0000000+00:00
DEBUG: 18:04:27 - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'aaaaaaaa-bbbb-cccc-dddddddddddd', Scopes:'https://dev.azuresynapse.net/.default', AuthorityHost:'https://login.microsoftonline.com/', UserId
:'mysecret@email.com'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId: 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Found 3 cache accounts and 0 broker accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Returning 3 accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] MSAL MSAL.Desktop with assembly version '4.30.1.0'. CorrelationId(a37abf97-d412-488e-9650-90c7a47e5367)
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === AcquireTokenSilent Parameters ===
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] LoginHint provided: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Account provided: True
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] ForceRefresh: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] 
=== Request Data ===
Authority Provided? - True
Scopes - https://dev.azuresynapse.net/.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - a37abf97-d412-488e-9650-90c7a47e5367

DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition (SilentRequest) started:
	
	Authority Host: login.microsoftonline.com
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Access token is not expired. Returning the found cache entry. [Current time (01/03/2023 17:04:27) - Expiration Time (01/03/2023 18:21:46 +00:00) - Extended Expirati
on Time (01/03/2023 18:21:46 +00:00)]
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Returning access token found in cache. RefreshOn exists ? False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Fetched access token from host login.microsoftonline.com. 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 01/03/2023 18:21:46 +00:00 and Scopes https://dev.azuresynapse.net/u
ser_impersonation https://dev.azuresynapse.net/.default
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId:  ExpiresOn: 2023-01-03T18:21:46.0000000+00:00
DEBUG: 18:04:27 - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'aaaaaaaa-bbbb-cccc-dddddddddddd', Scopes:'https://dev.azuresynapse.net/.default', AuthorityHost:'https://login.microsoftonline.com/', UserId
:'mysecret@email.com'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId: 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Found 3 cache accounts and 0 broker accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Returning 3 accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] MSAL MSAL.Desktop with assembly version '4.30.1.0'. CorrelationId(15e7b7cb-f3bc-4aad-bdbc-a34359db4722)
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === AcquireTokenSilent Parameters ===
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] LoginHint provided: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Account provided: True
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] ForceRefresh: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] 
=== Request Data ===
Authority Provided? - True
Scopes - https://dev.azuresynapse.net/.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - 15e7b7cb-f3bc-4aad-bdbc-a34359db4722

DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition (SilentRequest) started:
	
	Authority Host: login.microsoftonline.com
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Access token is not expired. Returning the found cache entry. [Current time (01/03/2023 17:04:27) - Expiration Time (01/03/2023 18:21:46 +00:00) - Extended Expirati
on Time (01/03/2023 18:21:46 +00:00)]
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Returning access token found in cache. RefreshOn exists ? False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Fetched access token from host login.microsoftonline.com. 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 01/03/2023 18:21:46 +00:00 and Scopes https://dev.azuresynapse.net/u
ser_impersonation https://dev.azuresynapse.net/.default
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId:  ExpiresOn: 2023-01-03T18:21:46.0000000+00:00
DEBUG: 18:04:27 - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'aaaaaaaa-bbbb-cccc-dddddddddddd', Scopes:'https://dev.azuresynapse.net/.default', AuthorityHost:'https://login.microsoftonline.com/', UserId
:'mysecret@email.com'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId: 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Found 3 cache accounts and 0 broker accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Returning 3 accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] MSAL MSAL.Desktop with assembly version '4.30.1.0'. CorrelationId(a34643ee-101b-4e9c-91b5-ad1684adae45)
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === AcquireTokenSilent Parameters ===
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] LoginHint provided: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Account provided: True
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] ForceRefresh: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] 
=== Request Data ===
Authority Provided? - True
Scopes - https://dev.azuresynapse.net/.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - a34643ee-101b-4e9c-91b5-ad1684adae45

DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition (SilentRequest) started:
	
	Authority Host: login.microsoftonline.com
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Access token is not expired. Returning the found cache entry. [Current time (01/03/2023 17:04:27) - Expiration Time (01/03/2023 18:21:46 +00:00) - Extended Expirati
on Time (01/03/2023 18:21:46 +00:00)]
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Returning access token found in cache. RefreshOn exists ? False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Fetched access token from host login.microsoftonline.com. 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 01/03/2023 18:21:46 +00:00 and Scopes https://dev.azuresynapse.net/u
ser_impersonation https://dev.azuresynapse.net/.default
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId:  ExpiresOn: 2023-01-03T18:21:46.0000000+00:00
DEBUG: 18:04:27 - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'aaaaaaaa-bbbb-cccc-dddddddddddd', Scopes:'https://dev.azuresynapse.net/.default', AuthorityHost:'https://login.microsoftonline.com/', UserId
:'mysecret@email.com'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId: 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Found 3 cache accounts and 0 broker accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Returning 3 accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] MSAL MSAL.Desktop with assembly version '4.30.1.0'. CorrelationId(a262e493-a079-4446-9562-a9b729143d71)
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === AcquireTokenSilent Parameters ===
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] LoginHint provided: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Account provided: True
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] ForceRefresh: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] 
=== Request Data ===
Authority Provided? - True
Scopes - https://dev.azuresynapse.net/.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - a262e493-a079-4446-9562-a9b729143d71

DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition (SilentRequest) started:
	
	Authority Host: login.microsoftonline.com
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Access token is not expired. Returning the found cache entry. [Current time (01/03/2023 17:04:27) - Expiration Time (01/03/2023 18:21:46 +00:00) - Extended Expirati
on Time (01/03/2023 18:21:46 +00:00)]
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Returning access token found in cache. RefreshOn exists ? False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Fetched access token from host login.microsoftonline.com. 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 01/03/2023 18:21:46 +00:00 and Scopes https://dev.azuresynapse.net/u
ser_impersonation https://dev.azuresynapse.net/.default
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId:  ExpiresOn: 2023-01-03T18:21:46.0000000+00:00
DEBUG: 18:04:27 - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'aaaaaaaa-bbbb-cccc-dddddddddddd', Scopes:'https://dev.azuresynapse.net/.default', AuthorityHost:'https://login.microsoftonline.com/', UserId
:'mysecret@email.com'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId: 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Found 3 cache accounts and 0 broker accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Returning 3 accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] MSAL MSAL.Desktop with assembly version '4.30.1.0'. CorrelationId(9ea662d0-f5ab-4d00-8f66-d160f09a6460)
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === AcquireTokenSilent Parameters ===
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] LoginHint provided: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Account provided: True
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] ForceRefresh: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] 
=== Request Data ===
Authority Provided? - True
Scopes - https://dev.azuresynapse.net/.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - 9ea662d0-f5ab-4d00-8f66-d160f09a6460

DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition (SilentRequest) started:
	
	Authority Host: login.microsoftonline.com
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Access token is not expired. Returning the found cache entry. [Current time (01/03/2023 17:04:27) - Expiration Time (01/03/2023 18:21:46 +00:00) - Extended Expirati
on Time (01/03/2023 18:21:46 +00:00)]
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Returning access token found in cache. RefreshOn exists ? False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Fetched access token from host login.microsoftonline.com. 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 01/03/2023 18:21:46 +00:00 and Scopes https://dev.azuresynapse.net/u
ser_impersonation https://dev.azuresynapse.net/.default
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId:  ExpiresOn: 2023-01-03T18:21:46.0000000+00:00
DEBUG: 18:04:27 - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'aaaaaaaa-bbbb-cccc-dddddddddddd', Scopes:'https://dev.azuresynapse.net/.default', AuthorityHost:'https://login.microsoftonline.com/', UserId
:'mysecret@email.com'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId: 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Found 3 cache accounts and 0 broker accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Returning 3 accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] MSAL MSAL.Desktop with assembly version '4.30.1.0'. CorrelationId(c38cee2d-d8b6-47c3-9a5e-f3255fbbc345)
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === AcquireTokenSilent Parameters ===
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] LoginHint provided: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Account provided: True
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] ForceRefresh: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] 
=== Request Data ===
Authority Provided? - True
Scopes - https://dev.azuresynapse.net/.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - c38cee2d-d8b6-47c3-9a5e-f3255fbbc345

DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition (SilentRequest) started:
	
	Authority Host: login.microsoftonline.com
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Access token is not expired. Returning the found cache entry. [Current time (01/03/2023 17:04:27) - Expiration Time (01/03/2023 18:21:46 +00:00) - Extended Expirati
on Time (01/03/2023 18:21:46 +00:00)]
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Returning access token found in cache. RefreshOn exists ? False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Fetched access token from host login.microsoftonline.com. 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 01/03/2023 18:21:46 +00:00 and Scopes https://dev.azuresynapse.net/u
ser_impersonation https://dev.azuresynapse.net/.default
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId:  ExpiresOn: 2023-01-03T18:21:46.0000000+00:00
DEBUG: 18:04:27 - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'aaaaaaaa-bbbb-cccc-dddddddddddd', Scopes:'https://dev.azuresynapse.net/.default', AuthorityHost:'https://login.microsoftonline.com/', UserId
:'mysecret@email.com'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId: 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Found 3 cache accounts and 0 broker accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Returning 3 accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] MSAL MSAL.Desktop with assembly version '4.30.1.0'. CorrelationId(aa4a1867-f21c-408f-a0fb-26da1886106e)
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === AcquireTokenSilent Parameters ===
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] LoginHint provided: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Account provided: True
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] ForceRefresh: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] 
=== Request Data ===
Authority Provided? - True
Scopes - https://dev.azuresynapse.net/.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - aa4a1867-f21c-408f-a0fb-26da1886106e

DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition (SilentRequest) started:
	
	Authority Host: login.microsoftonline.com
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Access token is not expired. Returning the found cache entry. [Current time (01/03/2023 17:04:27) - Expiration Time (01/03/2023 18:21:46 +00:00) - Extended Expirati
on Time (01/03/2023 18:21:46 +00:00)]
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Returning access token found in cache. RefreshOn exists ? False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Fetched access token from host login.microsoftonline.com. 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 01/03/2023 18:21:46 +00:00 and Scopes https://dev.azuresynapse.net/u
ser_impersonation https://dev.azuresynapse.net/.default
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId:  ExpiresOn: 2023-01-03T18:21:46.0000000+00:00
DEBUG: 18:04:27 - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'aaaaaaaa-bbbb-cccc-dddddddddddd', Scopes:'https://dev.azuresynapse.net/.default', AuthorityHost:'https://login.microsoftonline.com/', UserId
:'mysecret@email.com'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId: 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Found 3 cache accounts and 0 broker accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Returning 3 accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] MSAL MSAL.Desktop with assembly version '4.30.1.0'. CorrelationId(0bb8b729-9acb-4a41-b822-cb226518c960)
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === AcquireTokenSilent Parameters ===
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] LoginHint provided: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Account provided: True
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] ForceRefresh: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] 
=== Request Data ===
Authority Provided? - True
Scopes - https://dev.azuresynapse.net/.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - 0bb8b729-9acb-4a41-b822-cb226518c960

DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition (SilentRequest) started:
	
	Authority Host: login.microsoftonline.com
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Access token is not expired. Returning the found cache entry. [Current time (01/03/2023 17:04:27) - Expiration Time (01/03/2023 18:21:46 +00:00) - Extended Expirati
on Time (01/03/2023 18:21:46 +00:00)]
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Returning access token found in cache. RefreshOn exists ? False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Fetched access token from host login.microsoftonline.com. 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 01/03/2023 18:21:46 +00:00 and Scopes https://dev.azuresynapse.net/u
ser_impersonation https://dev.azuresynapse.net/.default
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId:  ExpiresOn: 2023-01-03T18:21:46.0000000+00:00
DEBUG: Request [3faf3af5-5a25-4da5-8164-a48bb2c800bf] GET https://xyz-we-a-saw-dp.dev.azuresynapse.net/pipelines?api-version=REDACTED
Accept:REDACTED
x-ms-client-request-id:REDACTED
x-ms-return-client-request-id:REDACTED
User-Agent:REDACTED
Authorization:REDACTED
client assembly: Azure.Analytics.Synapse.Artifacts
DEBUG: Response [3faf3af5-5a25-4da5-8164-a48bb2c800bf] 200 OK (00.2s)
Strict-Transport-Security:REDACTED
x-ms-request-id:REDACTED
x-ms-client-request-id:REDACTED
Date:REDACTED
Server:REDACTED
Content-Length:REDACTED
Content-Type:REDACTED

Get-AzSynapsePipeline : The requested operation requires an element of type 'String', but the target element has type 'Object'.
At line:1 char:1
+ Get-AzSynapsePipeline -WorkspaceName "xyz-we-a-saw-dp"
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : CloseError: (:) [Get-AzSynapsePipeline], InvalidOperationException
    + FullyQualifiedErrorId : Microsoft.Azure.Commands.Synapse.GetAzureSynapsePipeline
 
DEBUG: AzureQoSEvent: Module: Az.Synapse:1.1.0; CommandName: Get-AzSynapsePipeline; PSVersion: 5.1.19041.2364; IsSuccess: False; Duration: 00:00:00.5692572; Exception: The requested operation requires an element of type 'String', but the target e
lement has type 'Object'.;
DEBUG: Finish sending metric.
DEBUG: 18:04:27 - GetAzureSynapsePipeline end processing.

Environment data

Name                           Value                                                                                                                                                                                                                             
----                           -----                                                                                                                                                                                                                             
PSVersion                      5.1.17763.3770                                                                                                                                                                                                                    
PSEdition                      Desktop                                                                                                                                                                                                                           
PSCompatibleVersions           {1.0, 2.0, 3.0, 4.0...}                                                                                                                                                                                                           
BuildVersion                   10.0.17763.3770                                                                                                                                                                                                                   
CLRVersion                     4.0.30319.42000                                                                                                                                                                                                                   
WSManStackVersion              3.0                                                                                                                                                                                                                               
PSRemotingProtocolVersion      2.3                                                                                                                                                                                                                               
SerializationVersion           1.1.0.1

Module versions

Get-Module Az*

ModuleType Version    Name                                ExportedCommands                                                                                                                                                                                       
---------- -------    ----                                ----------------                                                                                                                                                                                       
Script     2.10.4     Az.Accounts                         {Add-AzEnvironment, Clear-AzConfig, Clear-AzContext, Clear-AzDefault...}                                                                                                                               
Script     2.2.0      Az.Synapse                          {Add-AzSynapseDataFlowDebugSessionPackage, Add-AzSynapseTriggerSubscription, Clear-AzSynapseSqlPoolVulnerabilityAssessmentRuleBaseline, Convert-AzSynapseSqlPoolVulnerabilityAssessmentScan...}

Error output

Get-AzSynapsePipeline : The requested operation requires an element of type 'String', but the target element has type 'Object'.
At line:17 char:1
+ Get-AzSynapsePipeline -WorkspaceName "xyz-we-a-saw-dp"
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : CloseError: (:) [Get-AzSynapsePipeline], InvalidOperationException
    + FullyQualifiedErrorId : Microsoft.Azure.Commands.Synapse.GetAzureSynapsePipeline

Thank you for your feedback. This has been routed to the support team for assistance.

[PramodValavala-MSFT]

@ssisjoost Thanks for the feedback! Looks like the issue is with the underlying .NET SDK used by the PowerShell cmdlet. We will share updates as we get this fixed.

[ssisjoost]

Solved. A hardcoded value from an activity property was accidentally put in the expression override. So the expresion contained a hardcoded text. Synapse did always ran succesfully and the hardcode text was just honered. Even the build was successful.

I just checked each single pipeline with the Get-AzSynapsePipeline -Name "xxxxxx" until I found one pipeline failing... removed it and then the Get-AzSynapsePipeline without the name filter ran succesful. After that just check every activity/property until I found the mistake.

[MironAtHome]

Can we hope for a fix.
Like ever?

[microsoft-github-policy-service]

Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @wonner, @v-yanjungao.