question

arkiboys avatar image
0 Votes"
arkiboys asked MartinJaffer-MSFT commented

flatten json data

sample json data:
...
"parcels": [
{
"name": "kljkl",
"state": "fgfgf",
"quantities": [
{
"planned": "ertet",
"uom": "poui"
},
{
"actual": "7ttyty",
"uom": "qwqw"
}
],
...
As you see in the screenshots below, the first flatten, (flatten12) has the parent which is parcels.
When I use the second flatten (flatten13) to get the inside array of parcels which is called quantities, I select from drop down the parcels.quantities
Questions:
1- should the drop down show quantities rather than parcels.quantities?
2- I get this error when trying to preview flatten13: screenshot below

182554-image.png

182586-image.png

182564-image.png

182603-image.png


azure-data-factory
image.png (6.9 KiB)
image.png (27.9 KiB)
image.png (26.7 KiB)
image.png (4.4 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I think so. Let me try, to double check

0 Votes 0 ·

1 Answer

arkiboys avatar image
0 Votes"
arkiboys answered MartinJaffer-MSFT commented

solved.
thank you

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you for letting us know.

0 Votes 0 ·