- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Inquiry about retrieving specific fields from nested object.
Hi,
If we have multiple objects in the JSON, how can we query specific fields from each nested object?
For example, suppose I only want to retrieve certain fields from the nested Line object of an Invoice. How can I achieve this through a Query?
"Invoice": [
{
"sparse": true,
"Id": "157",
"DocNumber": "1042",
"TxnDate": "2025-07-21",
"CurrencyRef": {
"value": "USD",
"name": "United States Dollar"
},
"Line": [
{
"Id": "1",
"LineNum": 1,
"Description": "Opening Balance",
"Amount": 275.00,
"DetailType": "SalesItemLineDetail"
}
]
}
]
Currently, when I try to include the Amount field from the Line object using projection (e.g., Line.Amount), I receive a null response.
Thanks,