Find child assets by parent qualifiedName

POST /api/meta/search/indexsearch#findChildAssets

Search for child assets using prefix match on qualifiedName of the parent asset. The search result will work on the asset hierarchy based on qualifiedName. The request example shows the child assets of a table, which in this case would be columns.

Body Required

Query to run the search.
In case, prefix of say a schema is passed in prefix all underlying assets
(tables and columns in this case) would be returned

You can chose to restrict the asset type by mentioning
the specific typeName as in the example below.

  • dsl object Required

    Search query for Atlan. This uses the Elastic Query DSL, which will not be fully described here due to its complexity.

  • attributes array[string] | null

    List of attribute names to include on each result. These attributes should exist on the assets being searched.

  • relationAttributes array[string] | null

    List of attribute names to include on each relationship included in the results. These attributes should exist on at least one of the relationships that could be returned on one of the assets in the results.

Responses

  • • 200 object

    Assets that exactly have the prefix as the qualifiedName value would be returned. In this case since the qualifiedName is of a table, columns will be returned. Since the typeName is set to Column even with qualifiedName of a schema is passed, only underlying columns would be returned.

    • queryType string

      Type of query.

      Value is INDEX.

    • searchParameters object

      Details of the query that was run. These can be used to re-run precisely the same query for paging.

      • attributes array[string]

        List of attribute names requested to be included on each result.

      • relationAttributes array[string]

        List of attribute names requested to be included on each relationship included in the results.

      • showSearchScore boolean

        Default value is false.

      • suppressLogs boolean

        Default value is false.

      • allowDeletedRelations boolean

        Default value is false.

      • query string

        Full DSL query that was received to produce these results, but encoded as a string rather than a JSON object.

    • entities array[object]

      Details of a single result from a search.

      • typeName string

        Name of the type definition that defines this instance.

      • attributes object | null

        Attributes that can exist across all assets in Atlan.

        • qualifiedName string

          Unique name for this asset. This is typically a concatenation of the asset's name onto its parent's qualifiedName.

        • name string

          Human-readable name of the asset.

      • classifications array[object] | null

        Instance of a classification in Atlan, with its detailed information.

        • typeName string

          Name of the classification. Note that this is the static-hashed unique name of the classification, not the human-readable displayName.

        • entityGuid string

          Unique identifier of the entity to which this classification is attached.

        • propagate boolean | null

          Whether to propagate this classification to other entities related to the entity to which the classification is attached.

        • removePropagationsOnEntityDelete boolean | null

          Whether to remove this classification from other entities to which it has been propagated when the classification is removed from this entity.

        • entityStatus string | null

          Status of the entity to which this classification is attached.

          Values are ACTIVE or DELETED.

      • displayText string | null

        Human-readable name of the entity.

      • guid string

        Unique identifier of the entity instance.

      • isIncomplete boolean | null

        Default value is false.

      • createdBy string | null

        Username of the user who created the object.

      • updatedBy string | null

        Username of the user who last updated the object.

      • createTime integer | null

        Time (epoch) at which this object was created, in milliseconds.

      • updateTime integer | null

        Time (epoch) at which this object was last updated, in milliseconds.

      • version integer | null

        Version of this object.

      • classificationNames array[string] | null

        List of classifications for this entity. Note that these are the internal hashed names used in Atlan, not the displayText of the classification.

      • labels array[string] | null

        Internal use only.

      • status string

        Status of the entity, either ACTIVE or DELETED.

        Values are ACTIVE or DELETED.

      • meaningNames array[string] Deprecated

        Unused.

      • meanings array[object] Deprecated

        Unused.

    • approximateCount integer

      Approximate count of the total number of results.

POST /api/meta/search/indexsearch#findChildAssets 
curl \
 -X POST https://tenant.atlan.com/api/meta/search/indexsearch#findChildAssets \
 -H "Authorization: Bearer $ACCESS_TOKEN" \
 -H "Content-Type: application/json" \
 -d '{"dsl":{"from":0,"size":1,"query":{"bool":{"must":[{"match":{"__state":"ACTIVE"}},{"match":{"__typeName.keyword":"Column"}},{"prefix":{"qualifiedName":"default/snowflake/1646904424/ATLAN_SAMPLE_DATA/FOOD_BEVERAGE"}}]}}}}'
Request example 
{
  "dsl": {
    "from": 0,
    "size": 1,
    "query": {
      "bool": {
        "must": [
          {
            "match": {
              "__state": "ACTIVE"
            }
          },
          {
            "match": {
              "__typeName.keyword": "Column"
            }
          },
          {
            "prefix": {
              "qualifiedName": "default/snowflake/1646904424/ATLAN_SAMPLE_DATA/FOOD_BEVERAGE"
            }
          }
        ]
      }
    }
  }
}
Response example (200) 
{
  "searchParameters": {
    "showSearchScore": false,
    "suppressLogs": false,
    "allowDeletedRelations": false,
    "query": "{\\\"from\\\":0,\\\"size\\\":1,\\\"query\\\":{\\\"bool\\\":{\\\"must\\\":[{\\\"matc h\\\":{\\\"__state\\\":\\\"ACTIVE\\\"}},{\\\"match\\\":{\\\"__typeName.key word\\\":\\\"Column\\\"}},{\\\"prefix\\\":{\\ \"qualifiedName\\\":\\\"default/snowflake/1646749526\\\"}}]}}}"
  },
  "entities": [
    {
      "typeName": "Column",
      "attributes": {
        "qualifiedName": "default/snowflake/1646749526/ATLAN_SAMPLE_DATA/FOOD_BEVERAGE/INSTACART_BEVERAGES_ORDER_CUSTOMER/aisle_id",
        "name": "aisle_id",
        "description": "Unique ID of the sub-category"
      },
      "guid": "4663f2d6-8b12-4f65-b94c-7407af10034d",
      "status": "ACTIVE",
      "displayText": "aisle_id",
      "classificationNames": [
        "J5q2QzErHG4unHTA0C5GE0",
        "EO7Gp8Y6xeI1JHctrlpQhB"
      ],
      "classifications": [
        {
          "typeName": "J5q2QzErHG4unHTA0C5GE0",
          "entityGuid": "af6a32d4-936b-4a59-9917-7082c56ba443",
          "entityStatus": "ACTIVE",
          "propagate": true,
          "removePropagationsOnEntityDelete": true
        },
        {
          "typeName": "EO7Gp8Y6xeI1JHctrlpQhB",
          "entityGuid": "85d141c2-d383-4b4f-93a5-c3eed20988b9",
          "entityStatus": "ACTIVE",
          "propagate": true,
          "removePropagationsOnEntityDelete": true
        }
      ],
      "meaningNames": [],
      "meanings": [],
      "isIncomplete": false,
      "labels": [],
      "createdBy": "jsmith",
      "updatedBy": "jdoe",
      "createTime": 1646904643794,
      "updateTime": 1650525230506
    }
  ],
  "approximateCount": 14
}