Azure / Azure/Azure-DataFactory

Dataflow treating {} in JSON keys as references

Open
#616 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
PowerShell
Stars
529
Forks
623
PR merge metrics
No merged PRs in 30d

Description

This is a sample data where `{}` are present in JSON keys:

```
{
"value": [
{
"@odata.etag": "\"2\"",
"ItemInternalId": "27708",
"ID": 27708,
"Name": "Rakesh",
"{Identifier}":"Recordings%252thismyrecording.wma",
"{IsFolder}": false,
"{Marks}":24
},
{
"@odata.etag": "\"3\"",
"ItemInternalId": "27709",
"ID": 27709,
"Name": "Laddu",
"{Identifier}": "Recordings%2426thismyrecording.wma",
"{IsFolder}": true,
"{Marks}":26
},
{
"@odata.etag": "\"3\"",
"ItemInternalId": "27710",
"ID": 27710,
"Name": "Virat",
"{Identifier}": "Recordings%183thismyrecording.wma",
"{IsFolder}": false,
"{Marks}":16
}
]
}
```

It is showing the wrong data preview after flatten transformation in data flow.

![enter image description here](https://i.imgur.com/6iVyGHb.png)

But it is giving proper results when transformed to another sink file.

![enter image description here](https://i.imgur.com/ZujXFap.png)

The issue is with the data preview when `{}` are present in JSON keys.

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.