dev-cloudjunctio
Level 1

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,