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,