Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
A community member has associated this post with a similar question:
How to parse nested json array of document in ADF data flow
Only moderators can edit this content.
Transform values from a nested json array of document in ADF Data Flow
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 6%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVR%3C/text%3E%3C/svg%3E)
venkat rao
65
Reputation points
Hi All
I am trying to fetch the values from an array of document using ADF data flow, I have consider the array of document on source side and used aggregate to convert into object but not able to fitch the values of json node like, getting an error while fetching the values of itOffer.item
**itOffer.item
itOffer.item.SplOfr
itOffer.item.SplOfr.deal.item
itOffer.item.SplOfr.lGroup.location.item[]
itOffer.item.SplOfr.zdeal.item[]
**
require your assistance kindly find below
[
{"itOffer":{"item":{"SplOfr":{"TypeCode":null,"From":20210510000000,"buy":{"item":{"avaab":0,"annn":null,"babab":2,"SequenceNr":1,"Amount":".01000","diType":"04"}},"parentOffer":"ag==","To":20210520235959,"offerDesc":"Created for ST 13","offerSetId":"ag==","refEventName":null,"refOfferId":"abcd==","get":{"item":{"gsgs":0,"variantSprof":null,"sghshs":2,"agsg":1,"minAmount":".01000","gshxh":"EA","unitForecast":0}},"limit":0,"refId":"0000000000","lGroup":{"NodeId":"AAAAAAAAAAAAAAAAAAAAAA==","eNodeId":null,"oGroup":null,"exterId":null,"parentId":"AAAAAAAAAAAAAAAAAAAAAA==","parentGroupId":"AAAAAAAAAAAAAAAAAAAAAA==","lHId":"0000000000","location":{"item":[{"offerId":"AAAAAAAAAAAAAAAAAAAAAA==","exterId":"ZST2","loId":"AA062mkBHtujxXcjAoc1fA==","lot":1040},{"offerId":"AAAAAAAAAAAAAAAAAAAAAA==","exterId":1700,"loId":"AA062mkBHtujxXcbt1TVfA==","lot":1040}]},"externalLocationHierarchyDesc":null,"externalLocationHierarchyNodeId":null,"locationHierarchyTypeCode":null,"locationGroupId":"AAAAAAAAAAAAAAAAAAAAAA=="},"promotionType":"DOF","externalLeadingCategoryId":null,"unitOfMeasure":null,"offerSetName":null,"leadingOffer":"AA062mkBHtutql1wc9l2tw==","intExternalOfferId":"000000000000000000000000000000000101","offerTypeCode":1,"retailEventId":null,"forecastTstmp":0,"liftTypeCode":"00","financialCalcRequired":null,"mdSystem":10001,"enforceMultiple":"X","name":"Sample_5","zdeal":{"item":[{"dNumber":"0000006966","term":"21FB2021","vFrom":"20240410000000","vTo":"20240507235959"}]},"incentive":{"item":[{"externalId":"2063828089181","iId":"21FB20210B791EEEB9BE77FC3411ED9E","iPtId":"00000000000000000000000000000000","inCls":"Z3","inTypeCode":"Z31"}]}}}}},
{"itOffer":{"item":{"SplOfr":{"TypeCode":null,"From":20210510000000,"buy":{"item":{"avaab":0,"annn":null,"babab":2,"SequenceNr":1,"Amount":".01000","diType":"04"}},"parentOffer":"ag==","To":20210520235959,"offerDesc":"Created for ST 13","offerSetId":"ag==","refEventName":null,"refOfferId":"abcd==","get":{"item":{"gsgs":0,"variantSprof":null,"sghshs":2,"agsg":1,"minAmount":".01000","gshxh":"EA","unitForecast":0}},"limit":0,"refId":"0000000000","lGroup":{"NodeId":"AAAAAAAAAAAAAAAAAAAAAA==","eNodeId":null,"oGroup":null,"exterId":null,"parentId":"AAAAAAAAAAAAAAAAAAAAAA==","parentGroupId":"AAAAAAAAAAAAAAAAAAAAAA==","lHId":"0000000000","location":{"item":[{"offerId":"AAAAAAAAAAAAAAAAAAAAAA==","exterId":"ZST2","loId":"AA062mkBHtujxXcjAoc1fA==","lot":1040},{"offerId":"AAAAAAAAAAAAAAAAAAAAAA==","exterId":1700,"loId":"AA062mkBHtujxXcbt1TVfA==","lot":1040}]},"externalLocationHierarchyDesc":null,"externalLocationHierarchyNodeId":null,"locationHierarchyTypeCode":null,"locationGroupId":"AAAAAAAAAAAAAAAAAAAAAA=="},"promotionType":"DOF","externalLeadingCategoryId":null,"unitOfMeasure":null,"offerSetName":null,"leadingOffer":"AA062mkBHtutql1wc9l2tw==","intExternalOfferId":"000000000000000000000000000000000101","offerTypeCode":1,"retailEventId":null,"forecastTstmp":0,"liftTypeCode":"00","financialCalcRequired":null,"mdSystem":10001,"enforceMultiple":"X","name":"Sample_5","zdeal":{"item":[{"dNumber":"0000006966","term":"21FB2021","vFrom":"20240410000000","vTo":"20240507235959"}]},"incentive":{"item":[{"externalId":"2063828089181","iId":"21FB20210B791EEEB9BE77FC3411ED9E","iPtId":"00000000000000000000000000000000","inCls":"Z3","inTypeCode":"Z31"}]}}}}},
{"itOffer":{"item":{"SplOfr":{"TypeCode":null,"From":20210510000000,"buy":{"item":{"avaab":0,"annn":null,"babab":2,"SequenceNr":1,"Amount":".01000","diType":"04"}},"parentOffer":"ag==","To":20210520235959,"offerDesc":"Created for ST 13","offerSetId":"ag==","refEventName":null,"refOfferId":"abcd==","get":{"item":{"gsgs":0,"variantSprof":null,"sghshs":2,"agsg":1,"minAmount":".01000","gshxh":"EA","unitForecast":0}},"limit":0,"refId":"0000000000","lGroup":{"NodeId":"AAAAAAAAAAAAAAAAAAAAAA==","eNodeId":null,"oGroup":null,"exterId":null,"parentId":"AAAAAAAAAAAAAAAAAAAAAA==","parentGroupId":"AAAAAAAAAAAAAAAAAAAAAA==","lHId":"0000000000","location":{"item":[{"offerId":"AAAAAAAAAAAAAAAAAAAAAA==","exterId":"ZST2","loId":"AA062mkBHtujxXcjAoc1fA==","lot":1040},{"offerId":"AAAAAAAAAAAAAAAAAAAAAA==","exterId":1700,"loId":"AA062mkBHtujxXcbt1TVfA==","lot":1040}]},"externalLocationHierarchyDesc":null,"externalLocationHierarchyNodeId":null,"locationHierarchyTypeCode":null,"locationGroupId":"AAAAAAAAAAAAAAAAAAAAAA=="},"promotionType":"DOF","externalLeadingCategoryId":null,"unitOfMeasure":null,"offerSetName":null,"leadingOffer":"AA062mkBHtutql1wc9l2tw==","intExternalOfferId":"000000000000000000000000000000000101","offerTypeCode":1,"retailEventId":null,"forecastTstmp":0,"liftTypeCode":"00","financialCalcRequired":null,"mdSystem":10001,"enforceMultiple":"X","name":"Sample_5","zdeal":{"item":[{"dNumber":"0000006966","term":"21FB2021","vFrom":"20240410000000","vTo":"20240507235959"}]},"incentive":{"item":[{"externalId":"2063828089181","iId":"21FB20210B791EEEB9BE77FC3411ED9E","iPtId":"00000000000000000000000000000000","inCls":"Z3","inTypeCode":"Z31"}]}}}}}
]
Azure Synapse Analytics
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
{count} votes