Forum Discussion
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
- ShayanSiddiqueIFrequent Visitor
This is WOrking for me:
$['products'][0]['catalogItem']['identifier']
But I wanted to make 0 dynamic according to the row can I do it? - v-sathmakuriCommunity Support
Hi ShayanSiddiqueI ,
Thank you for reaching out to fabric community.
This forum is intended for fabric data factory issues. Please post your issue in the adf community (Azure Data Factory | Microsoft Community Hub).
Thanks!!