Azure / Azure/azure-powershell

Az.Synapse Set-AzSynapsePipeline - Ignores literal nulls (value = null) in json definition

Open
#16,397 8 comments 0 reactions 0 assignees View on GitHub
act-codegen-extensibility-squad bug customer-reported question Service Attention Synapse
Dominant language
C#
Stars
4.8k
Forks
4.3k
Avg merge
2d 17h
Merged PRs (30d)
51

Description

### Description

This module has a bug when using the Set- cmdlets to publish json definition objects to Synapse.

If the JSON source file contains elements specified as literal nulls when the definition is published to Synapse it ignores the JSON elements that were literal nulls (i.e. value = null). This causes the use of the 'Treat as Null' Stored Procedure activity to not be publishable from the json files. I was able to work around this via directly using the Synapse Rest APIs, the same files published via the APIs do not strip away any literal null json element.

### Issue script & Debug output

```PowerShell
n/a
```

### Environment data

```PowerShell
5.1
```

### Module versions

```PowerShell
I tested via versions 0.1.0, 0.7.0, 0.18.0, the bug occurs with all versions
```

### Error output

```PowerShell
No error output from Powershell, the bug is that the published result to Synapse will ignore any json element set to equal a literal null (i.e. value = null)
```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.