Querying for a Specific Child

You can query a hierarchy of parent and child objects by providing the pattern in the query parameter named QueryHierarchy.

This example queries Account with a given set of fields and its child Contact with a set of fields and a searchspec and sortspec.

URI: https://host:port/siebel/v1.0/data/Account/Account?QueryHierarchy={"Account": {"fields": "SBA Review,CUT First Name","searchspec":"([CUT First Name] LIKE 'M*' )","Contact": {"fields": "First Name","sortspec": "First Name : asc"}}}

HTTP Method : GET

Content-Type: application/json

Authorization: Basic

Response Body:

{
    "items": [{
            "Id": "88-26CND",
            "CUT First Name": "MAYA",
            "SBA Review": "",
            "Contact": [{
                    "Id": "88-34IB1D",
                    "First Name": "DARWIN"
                },
                {
                    "Id": "0CR-1MF5Z6",
                    "First Name": "MAYA"
                }
            ]
        },
        {
            "Id": "1-3EV",
            "CUT First Name": "Michael",
            "SBA Review": "",
            "Contact": {
                "Id": "1-33E-VFFIX",
                "First Name": "Michael"

            }
        },
        {
            "Id": "88-14QA1",
            "CUT First Name": "Mary",
            "SBA Review": "",
            "Contact": {
                "Id": "88-14QAF",
                "First Name": "Mary"
            }
        },
        {
            "Id": "88-34JIR4",
            "CUT First Name": "MULTI NAME3",
            "SBA Review": "",
            "Contact": [{
                    "Id": "88-34JIR7",
                    "First Name": "MULTI NAME3"
                },
                {
                    "Id": "88-34JIRH",
                    "First Name": "MULTI NAME5"
                }
            ]

        },
        {
            "Id": "88-34JHYB",
            "CUT First Name": "MULTI NAME3",
            "SBA Review": "",
            "Contact": [{
                    "Id": "88-34JHYF",
                    "First Name": "MULTI NAME3"
                },
                {
                    "Id": "88-34JHYO",
                    "First Name": "MULTI NAME5"
                }
            ]
        },
        {
            "Id": "88-2XVT1",
            "CUT First Name": "Mobile",
            "SBA Review": "",
            "Contact": {
                "Id": "88-2XVW6",
                "First Name": "Mobile"
            }
        },
        {
            "Id": "1-32G1",
            "CUT First Name": "Mary",
            "SBA Review": "",
            "Contact": [{
                    "Id": "1-GBZC",
                    "First Name": "Christine"
                },
                {
                    "Id": "1-4EP",
                    "First Name": "Leis"
                },
                {
                    "Id": "1-47NA",
                    "First Name": "Mary"
                }
            ]
        }
    ]
}