Forum Discussion

ShayanSiddiqueI's avatar
ShayanSiddiqueI
Frequent Visitor
5 days ago

nested Array Issue in Mapping the key Values Part

I have a nested list of the array within the API Response in the Azure Data Factory. When I am mapping it  with the column its is showing me null value instead of giving me the actual value which exist. Here rthe Product List Part part of the reposnse that I wanted to map

"products": [
{
"id": 1,
"catalogItem": {
"id": 1,
"identifier": "1",
"_info": {
"catalog_href": "https://example.com/1"
}
},
"description": "1",
"sequenceNumber": 1,
"quantity": 1,
"price": 1,
"cost": 1,
"agreementAmount": 1,
"billableOption": "1",
"agreement": {
"id": 1,
"name": "1",
"_info": {
"agreement_href": "https://example.com/1"
}
},
"locationId": 1,
"businessUnitId": 1,
"taxableFlag": false,
"dropshipFlag": false,
"specialOrderFlag": false,
"phaseProductFlag": false,
"cancelledFlag": false,
"quantityCancelled": 1,
"customerDescription": "1",
"productSuppliedFlag": false,
"invoice": {
"id": 1,
"identifier": "1",
"_info": {
"invoice_href": "https://example.com/1"
}
},
"warehouseId": 1,
"warehouseBinId": 1,
"calculatedPriceFlag": false,
"calculatedCostFlag": false,
"warehouse": "1",
"warehouseBin": "1",
"company": {
"id": 1,
"identifier": "1",
"name": "1",
"_info": {
"company_href": "https://example.com/1"
}
},
"productClass": "1",
"needToPurchaseFlag": false,
"minimumStockFlag": false,
"calculatedPrice": 1,
"calculatedCost": 1,
"_info": {
"lastUpdated": "2026-01-01T00:00:00Z",
"updatedBy": "1"
}
}
]



I am trying the catlogitem.id and the the Same Format you can see here but still cant get an data  in the rows of the SQL Table How to refrenece it or how to flat it?

2 Replies

Replies have been turned off for this discussion