# Search metadata

> For the complete documentation index, see [llms.txt](https://developers.thoughtspot.com/docs/llms.txt)

Source: https://developers.thoughtspot.com/docs/rest-apiv2-metadata-search

# Search metadata

The `[/metadata/search](https://developers.thoughtspot.com/docs/restV2-playground?apiResourceId=http%2Fapi-endpoints%2Fmetadata%2Fsearch-metadata)` endpoint is the most versatile of all metadata endpoints. It can be used to search for lists or to retrieve very detailed information about specific objects. This endpoint replaces `metadata/list`, `metadata/listobjectheaders`, `metadata/details`, and `metadata/listvizheaders` from REST API v1.

## Overview

The overall structure of `metadata/search` request is [described as a combination of objects](https://developers.thoughtspot.com/docs/restV2-playground?apiResourceId=http%2Fmodels%2Fstructures%2Fapi-rest-20-metadata-search-request).

Note that many parameters in the request are **optional**, and leaving the parameter name out entirely has a different effect from including the parameter and specific values.

Throughout this article, requests and responses are shown as JSON only; the code to send the requests is not included. The V2.0 Playground generates requests that always include default values, which might not be listed in this article. Assume that every request shown in this article also includes the default parameters, unless stated otherwise.

## Object request parameters

The basic metadata selectors for the `/metadata/search` are placed in the `metadata` parameter as an array of [Metadata List objects](https://developers.thoughtspot.com/docs/restV2-playground?apiResourceId=http%2Fmodels%2Fstructures%2Fmetadata-list-item-input).

The API gets the details of an object if an object ID or name is specified in the request. The `identifier` parameter allows referencing an object by name or by object GUID.

Specific objects can be retrieved via the object GUID without specifying `type`:

```JSON
{
 "metadata": [
    {
      "identifier": "009d8d6c-5026-47a9-96d7-9e0f84896d17"
    }
  ]
}
```

### Metadata object types

The `type` attribute is optional when an object ID is specified in the API request. However, if the request includes only the name of the object in the `identifier` key, you must specify the `type`.

If you do not send specific object IDs as part of your request, the API lists all the objects. By default, the metadata `type` is set to `LiVEBOARD`. If you send a request without specifying the object ID or type, the API returns a list of Liveboards.

For information about the supported object types, see [API Playground](https://developers.thoughtspot.com/docs/restV2-playground?apiResourceId=http%2Fmodels%2Fenumerations%2Ftype-3).

### Subtypes for LOGICAL\_TABLE

For metadata types such as Models, Tables, and Views, set the `type` to `LOGICAL_TABLE`. When `type` is set as `LOGICAL_TABLE` and no object identifier is specified in the request, the API returns all available objects in ThoughtSpot. To get a complete list of `LOGICAL_TABLE` objects, set the `record_size` attribute to a desired value and configure [pagination settings]({{navprefix}}/{{rest-api-v2-metadata-search}}#_pagination_settings).

For `LOGICAL_TABLE` object type, you can also specify the subtype as an additional option to filter API response. You can specify one of the following values to define the `LOGICAL_TABLE` subtype:

-   `ONE_TO_ONE_LOGICAL` for Tables.
    
-   `WORKSHEET` for data objects such as Models
    
-   `PRIVATE_WORKSHEET` for private data objects such as Models.
    
-   `USER_DEFINED` for data imported from other sources such as a CSV file.
    
-   `AGGR_WORKSHEET` for Views. A **View** in ThoughtSpot refers to a Table materialized from a saved Answer that was saved as a View by a user.
    
-   `SQL_VIEW` for SQL Views. An SQL View is a virtual table and data source created from writing and saving a SQL query against your external data warehouse connection.
    

```JSON
{
"metadata": [
    {
      "type": "LOGICAL_TABLE",
      "subtypes": [
        "WORKSHEET"
      ]
    }
  ]
}
```

## Response format

The response from any call to `metadata/search` returns an array of [Metadata Response Objects](https://developers.thoughtspot.com/docs/restV2-playground?apiResourceId=http%2Fmodels%2Fstructures%2Fmetadata-search-response):

```JSON
[
  {
  "metadata_id": "4081f38c-1f26-4354-a418-af14136e3bd7",
  "metadata_name": "Snowflake",
  "metadata_type": "LIVEBOARD",
  "dependent_objects": null,
  "incomplete_objects": null,
  "metadata_detail": null,
  "metadata_header": {...},
  "visualization_headers": null,
  "stats": null
  },
...
]
```

You’ll notice a number of other keys with a `null` value. Various request parameters cause those sections of the response to be filled in with additional details.

The `metadata_header` key is always returned with values, regardless of the request. This section resembles the V1 REST API response from the [`metadata/list`]({{navprefix}}/{{metadata-api}}#metadata-list) and [`metadata/listobjectheaders`]({{navprefix}}/{{metadata-api}}#object-header) endpoints.

The value of `metadata_header` is a complex object with the most important set of attributes of the item. Note that `author` is the creator or current user who has been assigned the _ownership_ of the object, while `owner` describes a hierarchical relationship between ThoughtSpot objects (for example, this Liveboard has an `owner` property identical to its own `id` property):

```JSON
"metadata_header": {
      "hasTabs": false,
      "modelVersion": "V1",
      "hasMandatoryFilter": false,
      "isMandatoryFilterValueSelected": true,
      "totalContainerCount": 36,
      "id": "2681a4d3-98ad-4d37-b5c0-378dbac36320",
      "indexVersion": 14,
      "generationNum": 48857,
      "name": "Snowflake",
      "description": "Connection to Snowflake data warehouse",
      "author": "67e15c06-d153-4924-a4cd-ff615393b60f",
      "authorName": "UserA",
      "hasLenientDiscoverability": false,
      "descriptionAutoGenerated": false,
      "authorDisplayName": "UserA",
      "created": 1592450556601,
      "modified": 1592605750424,
      "modifiedBy": "67e15c06-d153-4924-a4cd-ff615393b60f",
      "owner": "2681a4d3-98ad-4d37-b5c0-378dbac36320",
      "isDeleted": false,
      "isHidden": false,
      "isAutoCreated": false,
      "isAutoDelete": false,
      "resolvedObjects": {},
      "tags": [],
      "aiAnswerGenerationDisabled": false,
      "isExternal": false,
      "isDeprecated": false,
      "isSharedViaConnection": false
 }
```

### Response format for Liveboards

On ThoughtSpot instances running 10.11.0.cl or later version, you can also specify the Liveboard version in the `liveboard_response_version` attribute. Valid values for this attribute are:

-   `V1`  
    Use this option to fetch Liveboard details in the legacy response format. If no value is specified for the `liveboard_response_version` attribute, the `V1` option will be used in the API request by default.
    
-   `V2`  
    Use this option to get the Liveboard details in modular structure, with separate object categories and properties for tab information, visualizations and filter details.
    

> **IMPORTANT:** If liveboard\_response\_version is set to V2 in your API request, ensure that you set the include\_details attribute to true. The structure of the API response and metadata details for the v1 varies from v2. If your current implementation is using the legacy Liveboard response structure, ensure that you update your implementation before requesting Liveboard data in the v2 response format.

```JSON
{
 "liveboard_response_version": "V2",//NEW PARAMETER
 "include_details": true,
 "metadata": [
    {
      "type": "LIVEBOARD",
      "identifier": "My Great Liveboard"
    }
  ]
}
```

### V1 and V2 Liveboard response comparison

The following table provides a high-level overview of the differences in v1 and v2 response structure:

  
| Data type | V1 response structure | V2 response structure |
| --- | --- | --- |
| 
Metadata fields

 | 

Monolithic structure with deep nested objects

 | 

Modular structure with top-level properties categorized under distinct objects.

 |
| 

Metadata header

 | 

Metadata fields like `metadata_id`, `metadata_name`, and `metadata_type` are top-level properties. There is no explicit `metadata_header` object.

 | 

Apart from the `metadata_id`, `metadata_name`, and `metadata_type`, with main Liveboard metadata details are categorized under the `header` object within `metadata_detail`.

 |
| 

Object structure

 | 

The Liveboard object details are nested under `metadata_details`

 | 

Explicitly categorized as `sheetProperties`, `pinboardTabs`, `containerLayouts`, `pinboardContainers`, `pinboardFilter`, and so on.

 |
| 

Tabs

 | 

Not explicitly listed as tabs

 | 

Tabs are defined in the `pinboardTabs` object, with each tab having a `header` and a list of container IDs. The order of tabs is given by `orderedTabIds`.

 |
| 

Filters

 | 

Filters are embedded within the `pinboardFilterDetails` object.

 | 

Filters are organized under a top-level `pinboardFilter` object, with clear separation of `filterGroups`, `filterRows`, and logical column order.

 |
| 

Containers and visualizations

 | 

Visualizations are nested within sheets and tiles, with less explicit mapping between containers and their visualizations

 | 

Each container is defined in `pinboardContainers`, with a clear mapping to its header, client state, and referenced visualization.

 |
| 

Layout

 | 

Layout is defined in a `layout` object with a list of tiles, each with position and size.

 | 

Layout is defined in `containerLayouts`, with each container’s position and size specified, and containers referenced by ID.

 |
| 

Parameter overrides and chips

 | 

No explicit parameter override or chip structure.

 | 

Includes `pinboardParameterOverride` and `orderedChips`.

 |
| 

JSON example

 | 

V1 response  

![Liveboard V1 response](/docs/doc-images/images/v1-lb-response.png)





 | 

V2 response  

![Liveboard V2 response](/docs/doc-images/images/v2-lb-response.png)





 |
|  |  |  |

#### JSON output format for Liveboard response V2

\[
   {
      "metadata\_id":"7752fa9e-db22-415e-bf34-e082c4bc41c3",
      "metadata\_name":"MyLiveboard",
      "metadata\_type":"LIVEBOARD",
      "metadata\_obj\_id":null,
      "dependent\_objects":null,
      "incomplete\_objects":null,
      "metadata\_detail":{
         "header":{
            "hasTabs":true,
            "modelVersion":"V2",
            "hasMandatoryFilter":false,
            "isMandatoryFilterValueSelected":true,
            "totalContainerCount":2,
            "id":"7752fa9e-db22-415e-bf34-e082c4bc41c3",
            "indexVersion":119,
            "generationNum":119,
            "name":"MyLiveboard",
            "description":"",
            "author":"59481331-ee53-42be-a548-bd87be6ddd4a",
            "authorName":"tsadmin",
            "hasLenientDiscoverability":false,
            "descriptionAutoGenerated":false,
            "authorDisplayName":"Administrator",
            "created":1450823023991,
            "modified":1753270167016,
            "modifiedBy":"59481331-ee53-42be-a548-bd87be6ddd4a",
            "owner":"7752fa9e-db22-415e-bf34-e082c4bc41c3",
            "isDeleted":false,
            "isHidden":false,
            "isAutoCreated":false,
            "isAutoDelete":false,
            "ownerOrgId":0,
            "resolvedObjects":{

            },
            "tags":\[

            \],
            "configs":\[

            \],
            "isConnectionConfigurationDisabled":false,
            "aiAnswerGenerationDisabled":true,
            "isExternal":false,
            "isDeprecated":false,
            "isSharedViaConnection":false,
            "syncWithSource":false,
            "isVerified":false,
            "isVersioningEnabled":false,
            "datasetId":"",
            "subType":"",
            "reportId":"",
            "viewId":"",
            "contentUpgradeId":"MAPBOX\_TOKEN\_ROTATION\_HANDLER",
            "headerUpgradeId":"MAPBOX\_TOKEN\_ROTATION\_HANDLER",
            "isPublished":false,
            "csrProtected":false
         },
         "sheetProperties":{
            "sheet\_id":"63cddf67-4863-4cd4-8bd5-050465462c9d",
            "client\_state":"null"
         },
         "type":"PINBOARD",
         "pinboardFilter":{
            "filterGroups":{
               "3b09bf9b-6a20-4ae4-8338-ab81cd612198":{
                  "group\_id":{
                     "logical\_column\_id":"3b09bf9b-6a20-4ae4-8338-ab81cd612198",
                     "data\_source\_id":"7d2fbbc1-d3bb-4ee4-9218-ec6421958c62"
                  }
               }
            },
            "crossFilterGroups":{

            },
            "crossFilterRows":{

            },
            "crossFilterSource":{

            },
            "filterRows":{
               "3b09bf9b-6a20-4ae4-8338-ab81cd612198":\[
                  {
                     "predicate":\[
                        {
                           "op":"IN",
                           "value":\[
                              {
                                 "selected":true,
                                 "value":{
                                    "s":"fob",
                                    "type":"TYPE\_STRING"
                                 },
                                 "key":"fob"
                              },
                              {
                                 "selected":true,
                                 "value":{
                                    "s":"air",
                                    "type":"TYPE\_STRING"
                                 },
                                 "key":"air"
                              }
                           \]
                        }
                     \],
                     "negate":false,
                     "filter\_id":"3db36b63-141a-415f-8e24-b923c3da85a1",
                     "logical\_column\_id":"3b09bf9b-6a20-4ae4-8338-ab81cd612198"
                  }
               \]
            },
            "linkedFilterColumns":{

            },
            "excludedContainers":{

            },
            "logicalColumnOrder":\[
               "3b09bf9b-6a20-4ae4-8338-ab81cd612198"
            \]
         },
         "pinboardTabs":{
            "tabs":{
               "60231d9c-42d6-4f66-b9ea-eec833de29b1":{
                  "header":{
                     "guid":"60231d9c-42d6-4f66-b9ea-eec833de29b1",
                     "display\_name":"Revenue",
                     "description":""
                  },
                  "container\_id":\[
                     "a448f425-bc51-4d35-bb34-6de22e7ce0d4"
                  \]
               },
               "410aa1fc-d382-443f-a863-214eed92f10c":{
                  "header":{
                     "guid":"410aa1fc-d382-443f-a863-214eed92f10c",
                     "display\_name":"Ship Mode",
                     "description":""
                  },
                  "container\_id":\[
                     "b8497b68-e87c-4857-a3b0-b014607e2fc7"
                  \]
               }
            },
            "orderedTabIds":\[
               "60231d9c-42d6-4f66-b9ea-eec833de29b1",
               "410aa1fc-d382-443f-a863-214eed92f10c"
            \]
         },
         "containerLayouts":\[
            {
               "id":"a448f425-bc51-4d35-bb34-6de22e7ce0d4",
               "x":0,
               "y":0,
               "height":8,
               "width":6
            },
            {
               "id":"b8497b68-e87c-4857-a3b0-b014607e2fc7",
               "x":0,
               "y":8,
               "height":2,
               "width":3
            }
         \],
         "pinboardContainers":{
            "a448f425-bc51-4d35-bb34-6de22e7ce0d4":{
               "header":{
                  "guid":"a448f425-bc51-4d35-bb34-6de22e7ce0d4",
                  "display\_name":"Answer: Total Revenue by Man Viz: Chart Viz revenue ma"
               },
               "clientState":{

               },
               "answerSpecInfo":{
                  "answer\_header":{
                     "guid":"bd6229fd-ee87-4a02-b878-be32e5ad3712",
                     "display\_name":"Total Revenue by Manufacturer"
                  },
                  "referenced\_tables":\[
                     {
                        "guid":"2445fe81-30d6-46fa-9f42-f6b1b4e01623",
                        "display\_name":"LINEORDER"
                     },
                     {
                        "guid":"a7fc012e-bdb3-4e75-9ce4-b3f731d90136",
                        "display\_name":"PART"
                     }
                  \],
                  "referenced\_viz\_type":"CHART",
                  "chart\_type":"COLUMN"
               },
               "referrencedVizId":"bec65c9c-263e-4c01-8742-3354dea78935"
            },
            "b8497b68-e87c-4857-a3b0-b014607e2fc7":{
               "header":{
                  "guid":"b8497b68-e87c-4857-a3b0-b014607e2fc7",
                  "display\_name":"Answer: Total Order Total Pr Viz: Chart Viz order tota"
               },
               "clientState":{

               },
               "answerSpecInfo":{
                  "answer\_header":{
                     "guid":"7a412074-15a2-43c1-92b1-91d634609990",
                     "display\_name":"Total Order Total Price"
                  },
                  "referenced\_tables":\[
                     {
                        "guid":"7d2fbbc1-d3bb-4ee4-9218-ec6421958c62",
                        "display\_name":"Formula Worksheet"
                     }
                  \],
                  "referenced\_viz\_type":"CHART",
                  "chart\_type":"KPI"
               },
               "referrencedVizId":"491fe06c-a245-41a3-832b-c0fb8d4e3e32"
            }
         },
         "pinboardParameterOverride":{

         },
         "orderedChips":\[
            {
               "object\_id":"3b09bf9b-6a20-4ae4-8338-ab81cd612198",
               "type":"FILTER"
            }
         \]
      },
      "metadata\_header":{
         "hasTabs":true,
         "modelVersion":"V2",
         "hasMandatoryFilter":false,
         "isMandatoryFilterValueSelected":true,
         "totalContainerCount":2,
         "id":"7752fa9e-db22-415e-bf34-e082c4bc41c3",
         "indexVersion":119,
         "generationNum":119,
         "name":"MyLiveboard",
         "description":"",
         "author":"59481331-ee53-42be-a548-bd87be6ddd4a",
         "authorName":"tsadmin",
         "hasLenientDiscoverability":false,
         "descriptionAutoGenerated":false,
         "authorDisplayName":"Administrator",
         "created":1450823023991,
         "modified":1753270167016,
         "modifiedBy":"59481331-ee53-42be-a548-bd87be6ddd4a",
         "owner":"7752fa9e-db22-415e-bf34-e082c4bc41c3",
         "isDeleted":false,
         "isHidden":false,
         "isAutoCreated":false,
         "isAutoDelete":false,
         "ownerOrgId":0,
         "resolvedObjects":{

         },
         "tags":\[

         \],
         "configs":\[

         \],
         "isConnectionConfigurationDisabled":false,
         "aiAnswerGenerationDisabled":true,
         "isExternal":false,
         "isDeprecated":false,
         "isSharedViaConnection":false,
         "syncWithSource":false,
         "isVerified":false,
         "isVersioningEnabled":false,
         "datasetId":"",
         "subType":"",
         "reportId":"",
         "viewId":"",
         "contentUpgradeId":"MAPBOX\_TOKEN\_ROTATION\_HANDLER",
         "headerUpgradeId":"MAPBOX\_TOKEN\_ROTATION\_HANDLER",
         "isPublished":false,
         "csrProtected":false
      },
      "visualization\_headers":null,
      "stats":null
   }
\]

#### JSON output format for Liveboard response V1

```JSON
[
   {
      "metadata_id":"7752fa9e-db22-415e-bf34-e082c4bc41c3",
      "metadata_name":"MyLiveboard",
      "metadata_type":"LIVEBOARD",
      "metadata_obj_id":null,
      "dependent_objects":null,
      "incomplete_objects":null,
      "metadata_detail":{
         "reportContent":{
            "sheets":[
               {
                  "sheetType":"PINBOARD",
                  "sheetContent":{
                     "sheetContentType":"PINBOARD",
                     "pinboardFilterDetails":{
                        "pinboardFiltersAnswerIds":[
                           "b114ff01-6777-40c7-808f-c29f7faed5f3"
                        ],
                        "filterLogicalTableIds":[
                           "7d2fbbc1-d3bb-4ee4-9218-ec6421958c62"
                        ],
                        "logicalTableIdToPinboardFilterVizIds":{
                           "7d2fbbc1-d3bb-4ee4-9218-ec6421958c62":[
                              "54a8a396-f278-4f11-afb5-ddc21e25bc9c"
                           ]
                        },
                        "filterIdToLinkedFilterIds":{

                        },
                        "filterIdToExcludedVizs":{

                        }
                     },
                     "visualizations":[
                        {
                           "vizContent":{
                              "refAnswerSheetIndex":0,
                              "refVizId":"bec65c9c-263e-4c01-8742-3354dea78935",
                              "locked":false,
                              "dataOnDemand":false,
                              "refAnswerBook":{
                                 "id":"bd6229fd-ee87-4a02-b878-be32e5ad3712",
                                 "name":"Total Revenue by Manufacturer",
                                 "sheets":[
                                    {
                                       "id":"d3956e7f-d7a1-466f-8bc4-9c40503d37ef",
                                       "name":"Total Revenue by Manufacturer",
                                       "owner":"bd6229fd-ee87-4a02-b878-be32e5ad3712"
                                    }
                                 ]
                              },
                              "vizType":"PINBOARD_VIZ"
                           },
                           "relatedLinks":[

                           ],
                           "header":{
                              "id":"a448f425-bc51-4d35-bb34-6de22e7ce0d4",
                              "indexVersion":119,
                              "generationNum":119,
                              "name":"Answer: Total Revenue by Man Viz: Chart Viz revenue ma",
                              "author":"59481331-ee53-42be-a548-bd87be6ddd4a",
                              "authorName":"tsadmin",
                              "hasLenientDiscoverability":false,
                              "authorDisplayName":"Administrator",
                              "created":1753267407876,
                              "modified":1753270167018,
                              "modifiedBy":"59481331-ee53-42be-a548-bd87be6ddd4a",
                              "owner":"7752fa9e-db22-415e-bf34-e082c4bc41c3",
                              "isDeleted":false,
                              "isHidden":false,
                              "orgIds":[
                                 0
                              ],
                              "belongToAllOrgs":false,
                              "tags":[

                              ],
                              "configs":[

                              ],
                              "isConnectionConfigurationDisabled":false,
                              "aiAnswerGenerationDisabled":true,
                              "isExternal":false,
                              "isDeprecated":false,
                              "isSharedViaConnection":false,
                              "syncWithSource":false,
                              "isVerified":false,
                              "isVersioningEnabled":false,
                              "contentUpgradeId":"MAPBOX_TOKEN_ROTATION_HANDLER",
                              "headerUpgradeId":"MAPBOX_TOKEN_ROTATION_HANDLER",
                              "isPublished":false,
                              "csrProtected":false
                           },
                           "complete":true,
                           "incompleteDetail":[

                           ]
                        },
                        {
                           "vizContent":{
                              "refAnswerSheetIndex":0,
                              "refVizId":"491fe06c-a245-41a3-832b-c0fb8d4e3e32",
                              "effectiveQuestion":{
                                 "sageContextProto":"CqEGCgMKATAaiAQKsgEKEU9yZGVyIFRvdGFsIFByaWNlEAIYBSokZjVkZDgzZDktODg5ZC00ZjA4LTg3OWUtNjYyZDA4NWZmNzVkMiQ3NGEwYmI3Mi00Y2E3LTQ1NjEtYWU2OC1mM2UyNjM5NDAwOGY6CgoDCgExGgMKATFSHxIRT3JkZXIgVG90YWwgUHJpY2UiAwoBMSoDCgExMACAAQHqARFPcmRlciBUb3RhbCBQcmljZYACAJoCAggAwAIACpcBCghRdWFudGl0eRACGAUqJGM0N2JhOGQwLTZkMDItNDM2ZS05ZTU4LTExMDgzNjI5MjliYzIkYTgyYmM2ZTItZDkzYy00MGY0LWJiNTItNjExZTZiNjc1NzBiOgoKAwoBMRoDCgExUhYSCFF1YW50aXR5IgMKATEqAwoBMTAAgAEB6gEIUXVhbnRpdHmAAgGaAgIIAMACAAqYAQoJYWlyLi4uZm9iEAQYAiokM2IwOWJmOWItNmEyMC00YWU0LTgzMzgtYWI4MWNkNjEyMTk4MiRlODVlMDA1MS03ZjY3LTRhNmItYTIzOC03NmM0OTc1YmJkZGI6CgoDCgExGgMKATFSFxIJU2hpcCBNb2RlIgMKATEqAwoBMTAAgAEBwgEDYWlywgEDZm9igAICuAIBwAIAEggIARAAGAEgARIICAEQARgBIAESCAgDEAIYASABMhQxNzQzNTQ2NDI2NjczNTc5NTI1NTrRARLOAQolIAI4A0AAchcIASIRCgMKATMaCgoDCgExGgMKATFABYIBAwoBNAolIAI4A0AAchcIASIRCgMKATUaCgoDCgExGgMKATFABYIBAwoBNhJTGAYqA2FpcioDZm9iggEXCAEiEQoDCgE3GgoKAwoBMRoDCgExQAKSAQMKATjaASQ1MWVmYjA4Ny01NDllLTVhNDYtOGUyMC1lODE2Y2RhZGE0ZDFKAwoBMlokN2QyZmJiYzEtZDNiYi00ZWU0LTkyMTgtZWM2NDIxOTU4YzYySgoKBAgAEgASAhIAWBF6CmVuX0dCLnV0ZjiCAQplbl9HQi51dGY4MjIKJDZlMWQ4ZDZkLTRiZDMtNGNiMi04MWY1LTIyZDRiNTdhMzIxMRIKTmV3IFRhYmxlMDI5CiQ3ZDJmYmJjMS1kM2JiLTRlZTQtOTIxOC1lYzY0MjE5NThjNjISEUZvcm11bGEgV29ya3NoZWV0MiYKJGI0MzQ5N2EzLTMxOWItNDUyYi04N2MxLTEwOGUwMzIwODFiZjI5CiRmNWRkODNkOS04ODlkLTRmMDgtODc5ZS02NjJkMDg1ZmY3NWQSEU9yZGVyIFRvdGFsIFByaWNlMiYKJDc0YTBiYjcyLTRjYTctNDU2MS1hZTY4LWYzZTI2Mzk0MDA4ZjIwCiRjNDdiYThkMC02ZDAyLTQzNmUtOWU1OC0xMTA4MzYyOTI5YmMSCFF1YW50aXR5MiYKJGE4MmJjNmUyLWQ5M2MtNDBmNC1iYjUyLTYxMWU2YjY3NTcwYjIxCiQzYjA5YmY5Yi02YTIwLTRhZTQtODMzOC1hYjgxY2Q2MTIxOTgSCVNoaXAgTW9kZTImCiRlODVlMDA1MS03ZjY3LTRhNmItYTIzOC03NmM0OTc1YmJkZGI4AoIBIDJkYTVmYWU5NGY0MGY5MjA5MmQ5MmZjYjM2NTM0NjMz",
                                 "sageContextIndex":0,
                                 "text":"order total price quantity air...fob",
                                 "isChasmTrapQuery":false
                              },
                              "locked":false,
                              "dataOnDemand":false,
                              "refAnswerBook":{
                                 "id":"7a412074-15a2-43c1-92b1-91d634609990",
                                 "name":"Total Order Total Price",
                                 "sheets":[
                                    {
                                       "id":"c53e28d3-7ea8-45e1-b752-1146e02d96d8",
                                       "name":"Total Order Total Price",
                                       "owner":"7a412074-15a2-43c1-92b1-91d634609990"
                                    }
                                 ]
                              },
                              "vizType":"PINBOARD_VIZ"
                           },
                           "relatedLinks":[

                           ],
                           "header":{
                              "id":"b8497b68-e87c-4857-a3b0-b014607e2fc7",
                              "indexVersion":119,
                              "generationNum":119,
                              "name":"Answer: Total Order Total Pr Viz: Chart Viz order tota",
                              "author":"59481331-ee53-42be-a548-bd87be6ddd4a",
                              "authorName":"tsadmin",
                              "hasLenientDiscoverability":false,
                              "authorDisplayName":"Administrator",
                              "created":1753267514945,
                              "modified":1753270167020,
                              "modifiedBy":"59481331-ee53-42be-a548-bd87be6ddd4a",
                              "owner":"7752fa9e-db22-415e-bf34-e082c4bc41c3",
                              "isDeleted":false,
                              "isHidden":false,
                              "orgIds":[
                                 0
                              ],
                              "belongToAllOrgs":false,
                              "tags":[

                              ],
                              "configs":[

                              ],
                              "isConnectionConfigurationDisabled":false,
                              "aiAnswerGenerationDisabled":true,
                              "isExternal":false,
                              "isDeprecated":false,
                              "isSharedViaConnection":false,
                              "syncWithSource":false,
                              "isVerified":false,
                              "isVersioningEnabled":false,
                              "contentUpgradeId":"MAPBOX_TOKEN_ROTATION_HANDLER",
                              "headerUpgradeId":"MAPBOX_TOKEN_ROTATION_HANDLER",
                              "isPublished":false,
                              "csrProtected":false
                           },
                           "complete":true,
                           "incompleteDetail":[

                           ]
                        },
                        {
                           "vizContent":{
                              "refAnswerSheetIndex":0,
                              "refVizId":"f7668b07-440f-46f0-9dff-757eeef70c9a",
                              "locked":false,
                              "dataOnDemand":false,
                              "refAnswerBook":{
                                 "id":"b114ff01-6777-40c7-808f-c29f7faed5f3",
                                 "name":"Untitled",
                                 "sheets":[
                                    {
                                       "id":"a5406af3-8e61-4f29-8ca2-a6481be71196",
                                       "name":"Untitled",
                                       "owner":"b114ff01-6777-40c7-808f-c29f7faed5f3"
                                    }
                                 ]
                              },
                              "vizType":"PINBOARD_VIZ"
                           },
                           "relatedLinks":[

                           ],
                           "header":{
                              "id":"54a8a396-f278-4f11-afb5-ddc21e25bc9c",
                              "indexVersion":0,
                              "generationNum":-1,
                              "name":"Answer: Untitled Viz: Filter Viz output id",
                              "author":"59481331-ee53-42be-a548-bd87be6ddd4a",
                              "authorName":"tsadmin",
                              "hasLenientDiscoverability":false,
                              "authorDisplayName":"Administrator",
                              "created":1753287860716,
                              "owner":"7752fa9e-db22-415e-bf34-e082c4bc41c3",
                              "isDeleted":false,
                              "isHidden":false,
                              "tags":[

                              ],
                              "configs":[

                              ],
                              "isConnectionConfigurationDisabled":false,
                              "aiAnswerGenerationDisabled":true,
                              "isExternal":false,
                              "isDeprecated":false,
                              "isSharedViaConnection":false,
                              "syncWithSource":false,
                              "isVerified":false,
                              "isVersioningEnabled":false,
                              "contentUpgradeId":"MAPBOX_TOKEN_ROTATION_HANDLER",
                              "headerUpgradeId":"MAPBOX_TOKEN_ROTATION_HANDLER",
                              "isPublished":false,
                              "csrProtected":false
                           },
                           "complete":true,
                           "incompleteDetail":[

                           ]
                        }
                     ],
                     "layout":{
                        "layoutMode":"auto",
                        "tiles":[
                           {
                              "id":"a448f425-bc51-4d35-bb34-6de22e7ce0d4",
                              "x":0,
                              "y":0,
                              "width":0,
                              "height":0,
                              "order":0,
                              "size":"m"
                           },
                           {
                              "id":"b8497b68-e87c-4857-a3b0-b014607e2fc7",
                              "x":0,
                              "y":0,
                              "width":0,
                              "height":0,
                              "order":1,
                              "size":"xs"
                           }
                        ]
                     },
                     "vizLayout":"GioKJGE0NDhmNDI1LWJjNTEtNGQzNS1iYjM0LTZkZTIyZTdjZTBkNDAAOAIaKgokYjg0OTdiNjgtZTg3Yy00ODU3LWEzYjAtYjAxNDYwN2UyZmM3MAE4AA",
                     "canGenerateLeafData":false
                  },
                  "header":{
                     "id":"63cddf67-4863-4cd4-8bd5-050465462c9d",
                     "indexVersion":119,
                     "generationNum":119,
                     "name":"MyLiveboard",
                     "description":"",
                     "author":"59481331-ee53-42be-a548-bd87be6ddd4a",
                     "authorName":"tsadmin",
                     "hasLenientDiscoverability":false,
                     "authorDisplayName":"Administrator",
                     "created":1450823023991,
                     "modified":1753270167016,
                     "modifiedBy":"59481331-ee53-42be-a548-bd87be6ddd4a",
                     "owner":"7752fa9e-db22-415e-bf34-e082c4bc41c3",
                     "isDeleted":false,
                     "isHidden":false,
                     "tags":[

                     ],
                     "configs":[

                     ],
                     "isConnectionConfigurationDisabled":false,
                     "aiAnswerGenerationDisabled":true,
                     "isExternal":false,
                     "isDeprecated":false,
                     "isSharedViaConnection":false,
                     "syncWithSource":false,
                     "isVerified":false,
                     "isVersioningEnabled":false,
                     "contentUpgradeId":"MAPBOX_TOKEN_ROTATION_HANDLER",
                     "headerUpgradeId":"MAPBOX_TOKEN_ROTATION_HANDLER",
                     "isPublished":false,
                     "csrProtected":false
                  },
                  "complete":true,
                  "incompleteDetail":[

                  ]
               }
            ]
         },
         "type":"PINBOARD",
         "header":{
            "hasTabs":true,
            "modelVersion":"V1",
            "hasMandatoryFilter":false,
            "isMandatoryFilterValueSelected":true,
            "totalContainerCount":2,
            "id":"7752fa9e-db22-415e-bf34-e082c4bc41c3",
            "indexVersion":119,
            "generationNum":119,
            "name":"MyLiveboard",
            "description":"",
            "author":"59481331-ee53-42be-a548-bd87be6ddd4a",
            "authorName":"tsadmin",
            "hasLenientDiscoverability":false,
            "descriptionAutoGenerated":false,
            "authorDisplayName":"Administrator",
            "created":1450823023991,
            "modified":1753270167016,
            "modifiedBy":"59481331-ee53-42be-a548-bd87be6ddd4a",
            "owner":"7752fa9e-db22-415e-bf34-e082c4bc41c3",
            "isDeleted":false,
            "isHidden":false,
            "isAutoCreated":false,
            "isAutoDelete":false,
            "ownerOrgId":0,
            "resolvedObjects":{
               "f7668b07-440f-46f0-9dff-757eeef70c9a":{
                  "reportContent":{
                     "sheets":[
                        {
                           "sheetType":"QUESTION",
                           "sheetContent":{
                              "headlineVisibilityMap":{
                                 "c14210f5-9a9d-453d-84cf-125e78bcaba5":true
                              },
                              "defaultQueryableSource":"FALCON",
                              "querableSources":[
                                 "FALCON"
                              ],
                              "externalQueryableDataSource":"DEFAULT",
                              "bestDisplayMode":"TABLE_MODE",
                              "canGenerateLeafData":true,
                              "sheetContentType":"QUESTION",
                              "filter":{
                                 "filterContent":{
                                    "rows":[
                                       {
                                          "column":{
                                             "isUserSorted":false,
                                             "aggrTypeOverride":"NONE",
                                             "typeOverride":"UNKNOWN",
                                             "dataTypeOverride":"UNKNOWN",
                                             "formatTypeOverride":"NONE",
                                             "uniqueValues":0,
                                             "sageOutputColumnId":"c14210f5-9a9d-453d-84cf-125e78bcaba5",
                                             "outputIdsWithMatchingLogicalKey":[

                                             ],
                                             "aggrApplied":false,
                                             "isVisible":true,
                                             "columnToFormatPatternType":{

                                             },
                                             "effectiveAggrType":"NONE",
                                             "effectiveDataType":"VARCHAR",
                                             "effectiveType":"ATTRIBUTE",
                                             "id":"c14210f5-9a9d-453d-84cf-125e78bcaba5",
                                             "effectiveColumnGuid":"2b9fe355-3e8a-3db7-85ea-e160ddb48fd9",
                                             "effectiveColumnIdString":"3b09bf9b-6a20-4ae4-8338-ab81cd612198#NONE#ATTRIBUTE#null",
                                             "baseColumnName":"Ship Mode",
                                             "baseAggrType":"NONE",
                                             "baseDataType":"VARCHAR",
                                             "baseType":"ATTRIBUTE",
                                             "isBaseColumnAdditive":false,
                                             "referencedTableHeaders":[
                                                {
                                                   "id":"7d2fbbc1-d3bb-4ee4-9218-ec6421958c62",
                                                   "name":"Formula Worksheet"
                                                }
                                             ],
                                             "referencedColumnHeaders":[
                                                {
                                                   "id":"3b09bf9b-6a20-4ae4-8338-ab81cd612198",
                                                   "name":"Ship Mode"
                                                }
                                             ],
                                             "allLevelReferencedTableHeaders":[
                                                {
                                                   "id":"7d2fbbc1-d3bb-4ee4-9218-ec6421958c62",
                                                   "name":"Formula Worksheet"
                                                },
                                                {
                                                   "id":"2445fe81-30d6-46fa-9f42-f6b1b4e01623",
                                                   "name":"LINEORDER"
                                                }
                                             ],
                                             "allLevelReferencedColumnHeaders":[
                                                {
                                                   "id":"3b09bf9b-6a20-4ae4-8338-ab81cd612198",
                                                   "name":"Ship Mode"
                                                },
                                                {
                                                   "id":"4f1e2f95-8ec6-4567-8c4c-bc77d55b9d67",
                                                   "name":"Ship Mode"
                                                }
                                             ],
                                             "customOrder":[

                                             ]
                                          },
                                          "oper":"IN",
                                          "values":[
                                             {
                                                "key":"air",
                                                "selected":true
                                             },
                                             {
                                                "key":"fob",
                                                "selected":true
                                             }
                                          ],
                                          "negation":false,
                                          "applyOnTablesGuids":[

                                          ],
                                          "type":"SIMPLE"
                                       }
                                    ]
                                 },
                                 "header":{
                                    "id":"de2e46d5-57a6-4425-b482-175733465484",
                                    "indexVersion":0,
                                    "generationNum":-1,
                                    "name":"Filter ship mode air...fob ship mode = {wildcard}",
                                    "author":"59481331-ee53-42be-a548-bd87be6ddd4a",
                                    "authorName":"tsadmin",
                                    "hasLenientDiscoverability":false,
                                    "authorDisplayName":"Administrator",
                                    "created":1753287860716,
                                    "owner":"a5406af3-8e61-4f29-8ca2-a6481be71196",
                                    "isDeleted":false,
                                    "isHidden":false,
                                    "tags":[

                                    ],
                                    "configs":[

                                    ],
                                    "isConnectionConfigurationDisabled":false,
                                    "type":"QUESTION",
                                    "aiAnswerGenerationDisabled":true,
                                    "isExternal":false,
                                    "isDeprecated":false,
                                    "isSharedViaConnection":false,
                                    "syncWithSource":false,
                                    "isVerified":false,
                                    "isVersioningEnabled":false,
                                    "contentUpgradeId":"MAPBOX_TOKEN_ROTATION_HANDLER",
                                    "headerUpgradeId":"MAPBOX_TOKEN_ROTATION_HANDLER",
                                    "isPublished":false,
                                    "csrProtected":false
                                 },
                                 "complete":true,
                                 "incompleteDetail":[

                                 ]
                              },
                              "question":{
                                 "sageContextProto":"CuMGCgMKATAa7wQKiQEKCVNoaXAgTW9kZRADGAIqJDNiMDliZjliLTZhMjAtNGFlNC04MzM4LWFiODFjZDYxMjE5ODIkYzE0MjEwZjUtOWE5ZC00NTNkLTg0Y2YtMTI1ZTc4YmNhYmE1OgoKAwoBMRoDCgExUhcSCVNoaXAgTW9kZSIDCgExKgMKATEwAIABAYACAMACAAqYAQoJYWlyLi4uZm9iEAQYAiokM2IwOWJmOWItNmEyMC00YWU0LTgzMzgtYWI4MWNkNjEyMTk4MiRjMTQyMTBmNS05YTlkLTQ1M2QtODRjZi0xMjVlNzhiY2FiYTU6CgoDCgExGgMKATFSFxIJU2hpcCBNb2RlIgMKATEqAwoBMTAAgAEBwgEDYWlywgEDZm9igAIBuAIBwAIACokBCglTaGlwIE1vZGUQAxgCKiQzYjA5YmY5Yi02YTIwLTRhZTQtODMzOC1hYjgxY2Q2MTIxOTgyJGMxNDIxMGY1LTlhOWQtNDUzZC04NGNmLTEyNWU3OGJjYWJhNToKCgMKATEaAwoBMVIXEglTaGlwIE1vZGUiAwoBMSoDCgExMACAAQGAAgLAAgAKDwoBPRAGgAEB6gEBPYACAwqKAQoKe3dpbGRjYXJkfRAEGAIqJDNiMDliZjliLTZhMjAtNGFlNC04MzM4LWFiODFjZDYxMjE5ODIkYzE0MjEwZjUtOWE5ZC00NTNkLTg0Y2YtMTI1ZTc4YmNhYmE1OgoKAwoBMRoDCgExUhcSCVNoaXAgTW9kZSIDCgExKgMKATEwAIABAYACBMACABIICAIQABgBIAESCAgDEAEYASABEggIAxACGAMgATIUMTY1MzQxODg1NDg1NTI2NDU4NTk6rAESqQEKJxgBIAFAAGAIchcIASIRCgMKATMaCgoDCgExGgMKATFAAoIBAwoBNBJTGAYqA2FpcioDZm9iggEXCAEiEQoDCgEzGgoKAwoBMRoDCgExQAKSAQMKATTaASRlYzBmNzM5OC03MmMxLTVlZDItYWE2Ni1mMzE1ZGMwZDU1NzhKAwoBMlokN2QyZmJiYzEtZDNiYi00ZWU0LTkyMTgtZWM2NDIxOTU4YzYySgoKBAgAEgASAhIAWBF6CmVuX0dCLnV0ZjiCAQplbl9HQi51dGY4MjIKJDhkMmY3MDlmLTNhZjAtNDdkNC1hNTIwLTRlODkzOWQyZjg3NRIKTmV3IFRhYmxlMDI5CiQ3ZDJmYmJjMS1kM2JiLTRlZTQtOTIxOC1lYzY0MjE5NThjNjISEUZvcm11bGEgV29ya3NoZWV0MiYKJGU5YjQzZmEzLTdjNjMtNDMzZC1iNjJiLWQ0OGEwMTkyNTRmNTIxCiQzYjA5YmY5Yi02YTIwLTRhZTQtODMzOC1hYjgxY2Q2MTIxOTgSCVNoaXAgTW9kZTImCiRjMTQyMTBmNS05YTlkLTQ1M2QtODRjZi0xMjVlNzhiY2FiYTU4AoIBIDJkYTVmYWU5NGY0MGY5MjA5MmQ5MmZjYjM2NTM0NjMz",
                                 "sageContextIndex":0,
                                 "text":"ship mode air...fob ship mode = {wildcard}",
                                 "isChasmTrapQuery":false
                              },
                              "visualizations":[
                                 {
                                    "vizContent":{
                                       "vizType":"TABLE",
                                       "columns":[
                                          {
                                             "isUserSorted":false,
                                             "aggrTypeOverride":"NONE",
                                             "typeOverride":"ATTRIBUTE",
                                             "dataTypeOverride":"UNKNOWN",
                                             "formatTypeOverride":"NONE",
                                             "groupBy":true,
                                             "clientState":{
                                                "version":"V1"
                                             },
                                             "uniqueValues":8,
                                             "sageOutputColumnId":"c14210f5-9a9d-453d-84cf-125e78bcaba5",
                                             "outputIdsWithMatchingLogicalKey":[

                                             ],
                                             "aggrApplied":false,
                                             "isVisible":true,
                                             "columnToFormatPatternType":{

                                             },
                                             "effectiveAggrType":"NONE",
                                             "effectiveDataType":"VARCHAR",
                                             "effectiveType":"ATTRIBUTE",
                                             "id":"c14210f5-9a9d-453d-84cf-125e78bcaba5",
                                             "effectiveColumnGuid":"2b9fe355-3e8a-3db7-85ea-e160ddb48fd9",
                                             "effectiveColumnIdString":"3b09bf9b-6a20-4ae4-8338-ab81cd612198#NONE#ATTRIBUTE#null",
                                             "baseColumnName":"Ship Mode",
                                             "baseAggrType":"NONE",
                                             "baseDataType":"VARCHAR",
                                             "baseType":"ATTRIBUTE",
                                             "isBaseColumnAdditive":false,
                                             "referencedTableHeaders":[
                                                {
                                                   "id":"7d2fbbc1-d3bb-4ee4-9218-ec6421958c62",
                                                   "name":"Formula Worksheet"
                                                }
                                             ],
                                             "referencedColumnHeaders":[
                                                {
                                                   "id":"3b09bf9b-6a20-4ae4-8338-ab81cd612198",
                                                   "name":"Ship Mode"
                                                }
                                             ],
                                             "allLevelReferencedTableHeaders":[
                                                {
                                                   "id":"7d2fbbc1-d3bb-4ee4-9218-ec6421958c62",
                                                   "name":"Formula Worksheet"
                                                },
                                                {
                                                   "id":"2445fe81-30d6-46fa-9f42-f6b1b4e01623",
                                                   "name":"LINEORDER"
                                                }
                                             ],
                                             "allLevelReferencedColumnHeaders":[
                                                {
                                                   "id":"3b09bf9b-6a20-4ae4-8338-ab81cd612198",
                                                   "name":"Ship Mode"
                                                },
                                                {
                                                   "id":"4f1e2f95-8ec6-4567-8c4c-bc77d55b9d67",
                                                   "name":"Ship Mode"
                                                }
                                             ],
                                             "customOrder":[

                                             ]
                                          }
                                       ],
                                       "title":{
                                          "value":{
                                             "text":"Table 1"
                                          }
                                       },
                                       "customTitle":false,
                                       "locked":false
                                    },
                                    "relatedLinks":[

                                    ],
                                    "header":{
                                       "id":"76da6c33-caf1-4409-bd35-20243d0d9115",
                                       "indexVersion":0,
                                       "generationNum":-1,
                                       "name":"Table Viz ship mode air...fob ship mode = {wildcard}",
                                       "author":"59481331-ee53-42be-a548-bd87be6ddd4a",
                                       "authorName":"tsadmin",
                                       "hasLenientDiscoverability":false,
                                       "authorDisplayName":"Administrator",
                                       "created":1753287860716,
                                       "owner":"a5406af3-8e61-4f29-8ca2-a6481be71196",
                                       "isDeleted":false,
                                       "isHidden":false,
                                       "tags":[

                                       ],
                                       "configs":[

                                       ],
                                       "isConnectionConfigurationDisabled":false,
                                       "type":"QUESTION",
                                       "aiAnswerGenerationDisabled":true,
                                       "isExternal":false,
                                       "isDeprecated":false,
                                       "isSharedViaConnection":false,
                                       "syncWithSource":false,
                                       "isVerified":false,
                                       "isVersioningEnabled":false,
                                       "contentUpgradeId":"MAPBOX_TOKEN_ROTATION_HANDLER",
                                       "headerUpgradeId":"MAPBOX_TOKEN_ROTATION_HANDLER",
                                       "isPublished":false,
                                       "csrProtected":false
                                    },
                                    "complete":true,
                                    "incompleteDetail":[

                                    ]
                                 },
                                 {
                                    "vizContent":{
                                       "vizType":"HEADLINE",
                                       "template":"ATTRIBUTE",
                                       "columns":[
                                          {
                                             "column":{
                                                "isUserSorted":false,
                                                "aggrTypeOverride":"NONE",
                                                "typeOverride":"ATTRIBUTE",
                                                "dataTypeOverride":"UNKNOWN",
                                                "formatTypeOverride":"NONE",
                                                "groupBy":true,
                                                "clientState":{
                                                   "version":"V1"
                                                },
                                                "uniqueValues":8,
                                                "sageOutputColumnId":"c14210f5-9a9d-453d-84cf-125e78bcaba5",
                                                "outputIdsWithMatchingLogicalKey":[

                                                ],
                                                "aggrApplied":true,
                                                "isVisible":true,
                                                "columnToFormatPatternType":{

                                                },
                                                "effectiveAggrType":"NONE",
                                                "effectiveDataType":"VARCHAR",
                                                "effectiveType":"ATTRIBUTE",
                                                "id":"c14210f5-9a9d-453d-84cf-125e78bcaba5",
                                                "effectiveColumnGuid":"2b9fe355-3e8a-3db7-85ea-e160ddb48fd9",
                                                "effectiveColumnIdString":"3b09bf9b-6a20-4ae4-8338-ab81cd612198#NONE#ATTRIBUTE#null",
                                                "baseColumnName":"Ship Mode",
                                                "baseAggrType":"NONE",
                                                "baseDataType":"VARCHAR",
                                                "baseType":"ATTRIBUTE",
                                                "isBaseColumnAdditive":false,
                                                "referencedTableHeaders":[
                                                   {
                                                      "id":"7d2fbbc1-d3bb-4ee4-9218-ec6421958c62",
                                                      "name":"Formula Worksheet"
                                                   }
                                                ],
                                                "referencedColumnHeaders":[
                                                   {
                                                      "id":"3b09bf9b-6a20-4ae4-8338-ab81cd612198",
                                                      "name":"Ship Mode"
                                                   }
                                                ],
                                                "allLevelReferencedTableHeaders":[
                                                   {
                                                      "id":"7d2fbbc1-d3bb-4ee4-9218-ec6421958c62",
                                                      "name":"Formula Worksheet"
                                                   },
                                                   {
                                                      "id":"2445fe81-30d6-46fa-9f42-f6b1b4e01623",
                                                      "name":"LINEORDER"
                                                   }
                                                ],
                                                "allLevelReferencedColumnHeaders":[
                                                   {
                                                      "id":"3b09bf9b-6a20-4ae4-8338-ab81cd612198",
                                                      "name":"Ship Mode"
                                                   },
                                                   {
                                                      "id":"4f1e2f95-8ec6-4567-8c4c-bc77d55b9d67",
                                                      "name":"Ship Mode"
                                                   }
                                                ],
                                                "customOrder":[

                                                ]
                                             },
                                             "possibleAggrs":[
                                                "COUNT",
                                                "COUNT_DISTINCT"
                                             ],
                                             "aggrs":[
                                                "COUNT_DISTINCT"
                                             ],
                                             "tableSummary":true
                                          }
                                       ],
                                       "showSummaryAggrs":true,
                                       "title":{
                                          "value":{
                                             "text":"Headline Ship Mode"
                                          }
                                       },
                                       "customTitle":false,
                                       "locked":true
                                    },
                                    "relatedLinks":[

                                    ],
                                    "header":{
                                       "id":"07b4c14f-f2f8-49e0-b74d-89fa0c7d5c8b",
                                       "indexVersion":0,
                                       "generationNum":-1,
                                       "name":"Headline Ship Mode",
                                       "author":"59481331-ee53-42be-a548-bd87be6ddd4a",
                                       "authorName":"tsadmin",
                                       "hasLenientDiscoverability":false,
                                       "authorDisplayName":"Administrator",
                                       "created":1753287860716,
                                       "owner":"a5406af3-8e61-4f29-8ca2-a6481be71196",
                                       "isDeleted":false,
                                       "isHidden":false,
                                       "tags":[

                                       ],
                                       "configs":[

                                       ],
                                       "isConnectionConfigurationDisabled":false,
                                       "type":"QUESTION",
                                       "aiAnswerGenerationDisabled":true,
                                       "isExternal":false,
                                       "isDeprecated":false,
                                       "isSharedViaConnection":false,
                                       "syncWithSource":false,
                                       "isVerified":false,
                                       "isVersioningEnabled":false,
                                       "contentUpgradeId":"MAPBOX_TOKEN_ROTATION_HANDLER",
                                       "headerUpgradeId":"MAPBOX_TOKEN_ROTATION_HANDLER",
                                       "isPublished":false,
                                       "csrProtected":false
                                    },
                                    "complete":true,
                                    "incompleteDetail":[

                                    ]
                                 },
                                 {
                                    "vizContent":{
                                       "vizType":"FILTER",
                                       "compoundRowIndices":[
                                          0
                                       ]
                                    },
                                    "relatedLinks":[

                                    ],
                                    "header":{
                                       "id":"f7668b07-440f-46f0-9dff-757eeef70c9a",
                                       "indexVersion":0,
                                       "generationNum":-1,
                                       "name":"Filter Viz output id: c14210f5-9a9d-453d-84cf-125e78bcaba5",
                                       "author":"59481331-ee53-42be-a548-bd87be6ddd4a",
                                       "authorName":"tsadmin",
                                       "hasLenientDiscoverability":false,
                                       "authorDisplayName":"Administrator",
                                       "created":1753287860716,
                                       "owner":"a5406af3-8e61-4f29-8ca2-a6481be71196",
                                       "isDeleted":false,
                                       "isHidden":false,
                                       "tags":[

                                       ],
                                       "configs":[

                                       ],
                                       "isConnectionConfigurationDisabled":false,
                                       "type":"QUESTION",
                                       "aiAnswerGenerationDisabled":true,
                                       "isExternal":false,
                                       "isDeprecated":false,
                                       "isSharedViaConnection":false,
                                       "syncWithSource":false,
                                       "isVerified":false,
                                       "isVersioningEnabled":false,
                                       "contentUpgradeId":"MAPBOX_TOKEN_ROTATION_HANDLER",
                                       "headerUpgradeId":"MAPBOX_TOKEN_ROTATION_HANDLER",
                                       "isPublished":false,
                                       "csrProtected":false
                                    },
                                    "complete":true,
                                    "incompleteDetail":[

                                    ]
                                 },
                                 {
                                    "vizContent":{
                                       "chartType":"KPI",
                                       "axisConfigs":[
                                          {
                                             "y":[
                                                "c14210f5-9a9d-453d-84cf-125e78bcaba5"
                                             ]
                                          }
                                       ],
                                       "bestAxisConfigs":{
                                          "KPI":{
                                             "y":[
                                                "c14210f5-9a9d-453d-84cf-125e78bcaba5"
                                             ]
                                          }
                                       },
                                       "title":{
                                          "value":{
                                             "text":"Chart 0"
                                          }
                                       },
                                       "customTitle":false,
                                       "locked":false,
                                       "dataOnDemand":false,
                                       "columns":[
                                          {
                                             "isUserSorted":false,
                                             "aggrTypeOverride":"NONE",
                                             "typeOverride":"ATTRIBUTE",
                                             "dataTypeOverride":"UNKNOWN",
                                             "formatTypeOverride":"NONE",
                                             "groupBy":true,
                                             "clientState":{
                                                "version":"V1"
                                             },
                                             "uniqueValues":8,
                                             "sageOutputColumnId":"c14210f5-9a9d-453d-84cf-125e78bcaba5",
                                             "outputIdsWithMatchingLogicalKey":[

                                             ],
                                             "aggrApplied":false,
                                             "isVisible":true,
                                             "columnToFormatPatternType":{

                                             },
                                             "effectiveAggrType":"NONE",
                                             "effectiveDataType":"VARCHAR",
                                             "effectiveType":"ATTRIBUTE",
                                             "id":"c14210f5-9a9d-453d-84cf-125e78bcaba5",
                                             "effectiveColumnGuid":"2b9fe355-3e8a-3db7-85ea-e160ddb48fd9",
                                             "effectiveColumnIdString":"3b09bf9b-6a20-4ae4-8338-ab81cd612198#NONE#ATTRIBUTE#null",
                                             "baseColumnName":"Ship Mode",
                                             "baseAggrType":"NONE",
                                             "baseDataType":"VARCHAR",
                                             "baseType":"ATTRIBUTE",
                                             "isBaseColumnAdditive":false,
                                             "referencedTableHeaders":[
                                                {
                                                   "id":"7d2fbbc1-d3bb-4ee4-9218-ec6421958c62",
                                                   "name":"Formula Worksheet"
                                                }
                                             ],
                                             "referencedColumnHeaders":[
                                                {
                                                   "id":"3b09bf9b-6a20-4ae4-8338-ab81cd612198",
                                                   "name":"Ship Mode"
                                                }
                                             ],
                                             "allLevelReferencedTableHeaders":[
                                                {
                                                   "id":"7d2fbbc1-d3bb-4ee4-9218-ec6421958c62",
                                                   "name":"Formula Worksheet"
                                                },
                                                {
                                                   "id":"2445fe81-30d6-46fa-9f42-f6b1b4e01623",
                                                   "name":"LINEORDER"
                                                }
                                             ],
                                             "allLevelReferencedColumnHeaders":[
                                                {
                                                   "id":"3b09bf9b-6a20-4ae4-8338-ab81cd612198",
                                                   "name":"Ship Mode"
                                                },
                                                {
                                                   "id":"4f1e2f95-8ec6-4567-8c4c-bc77d55b9d67",
                                                   "name":"Ship Mode"
                                                }
                                             ],
                                             "customOrder":[

                                             ]
                                          }
                                       ],
                                       "vizType":"CHART"
                                    },
                                    "relatedLinks":[

                                    ],
                                    "header":{
                                       "id":"e1abc966-e7cd-4f02-9649-c5fec516c04c",
                                       "indexVersion":0,
                                       "generationNum":-1,
                                       "name":"Chart Viz ship mode air...fob ship mode = {wildcard}",
                                       "author":"59481331-ee53-42be-a548-bd87be6ddd4a",
                                       "authorName":"tsadmin",
                                       "hasLenientDiscoverability":false,
                                       "authorDisplayName":"Administrator",
                                       "created":1753287860716,
                                       "owner":"a5406af3-8e61-4f29-8ca2-a6481be71196",
                                       "isDeleted":false,
                                       "isHidden":false,
                                       "tags":[

                                       ],
                                       "configs":[

                                       ],
                                       "isConnectionConfigurationDisabled":false,
                                       "type":"QUESTION",
                                       "aiAnswerGenerationDisabled":true,
                                       "isExternal":false,
                                       "isDeprecated":false,
                                       "isSharedViaConnection":false,
                                       "syncWithSource":false,
                                       "isVerified":false,
                                       "isVersioningEnabled":false,
                                       "contentUpgradeId":"MAPBOX_TOKEN_ROTATION_HANDLER",
                                       "headerUpgradeId":"MAPBOX_TOKEN_ROTATION_HANDLER",
                                       "isPublished":false,
                                       "csrProtected":false
                                    },
                                    "complete":true,
                                    "incompleteDetail":[

                                    ]
                                 }
                              ]
                           },
                           "header":{
                              "id":"a5406af3-8e61-4f29-8ca2-a6481be71196",
                              "indexVersion":0,
                              "generationNum":-1,
                              "name":"Untitled",
                              "author":"59481331-ee53-42be-a548-bd87be6ddd4a",
                              "authorName":"tsadmin",
                              "hasLenientDiscoverability":false,
                              "authorDisplayName":"Administrator",
                              "created":1753287860716,
                              "owner":"b114ff01-6777-40c7-808f-c29f7faed5f3",
                              "isDeleted":false,
                              "isHidden":true,
                              "tags":[

                              ],
                              "configs":[

                              ],
                              "isConnectionConfigurationDisabled":false,
                              "type":"QUESTION",
                              "aiAnswerGenerationDisabled":true,
                              "isExternal":false,
                              "isDeprecated":false,
                              "isSharedViaConnection":false,
                              "syncWithSource":false,
                              "isVerified":false,
                              "isVersioningEnabled":false,
                              "contentUpgradeId":"MAPBOX_TOKEN_ROTATION_HANDLER",
                              "headerUpgradeId":"MAPBOX_TOKEN_ROTATION_HANDLER",
                              "isPublished":false,
                              "csrProtected":false
                           },
                           "complete":true,
                           "incompleteDetail":[

                           ]
                        }
                     ]
                  },
                  "type":"QUESTION",
                  "header":{
                     "id":"b114ff01-6777-40c7-808f-c29f7faed5f3",
                     "indexVersion":0,
                     "generationNum":-1,
                     "name":"Untitled",
                     "author":"59481331-ee53-42be-a548-bd87be6ddd4a",
                     "authorName":"tsadmin",
                     "authorDisplayName":"Administrator",
                     "created":1753287860716,
                     "owner":"7752fa9e-db22-415e-bf34-e082c4bc41c3",
                     "isHidden":true,
                     "tags":[

                     ],
                     "configs":[

                     ],
                     "isConnectionConfigurationDisabled":false,
                     "aiAnswerGenerationDisabled":true,
                     "isExternal":false,
                     "isDeprecated":false,
                     "isSharedViaConnection":false,
                     "syncWithSource":false,
                     "isVerified":false,
                     "isVersioningEnabled":false,
                     "contentUpgradeId":"MAPBOX_TOKEN_ROTATION_HANDLER",
                     "headerUpgradeId":"MAPBOX_TOKEN_ROTATION_HANDLER",
                     "isPublished":false,
                     "csrProtected":false
                  },
                  "complete":true,
                  "incompleteDetail":[

                  ]
               },
               "491fe06c-a245-41a3-832b-c0fb8d4e3e32":{
                  "reportContent":{
                     "sheets":[
                        {
                           "sheetType":"QUESTION",
                           "sheetContent":{
                              "headlineVisibilityMap":{
                                 "a82bc6e2-d93c-40f4-bb52-611e6b67570b":true,
                                 "74a0bb72-4ca7-4561-ae68-f3e26394008f":true
                              },
                              "defaultQueryableSource":"FALCON",
                              "querableSources":[
                                 "FALCON"
                              ],
                              "externalQueryableDataSource":"DEFAULT",
                              "bestDisplayMode":"CHART_MODE",
                              "canGenerateLeafData":true,
                              "sheetContentType":"QUESTION",
                              "question":{
                                 "sageContextProto":"CpQECgMKATAa0wIKsgEKEU9yZGVyIFRvdGFsIFByaWNlEAIYBSokZjVkZDgzZDktODg5ZC00ZjA4LTg3OWUtNjYyZDA4NWZmNzVkMiQ3NGEwYmI3Mi00Y2E3LTQ1NjEtYWU2OC1mM2UyNjM5NDAwOGY6CgoDCgExGgMKATFSHxIRT3JkZXIgVG90YWwgUHJpY2UiAwoBMSoDCgExMACAAQHqARFPcmRlciBUb3RhbCBQcmljZYACAJoCAggAwAIACocBCghRdWFudGl0eRACGAUqJGM0N2JhOGQwLTZkMDItNDM2ZS05ZTU4LTExMDgzNjI5MjliYzIkYTgyYmM2ZTItZDkzYy00MGY0LWJiNTItNjExZTZiNjc1NzBiOgoKAwoBMRoDCgExUhYSCFF1YW50aXR5IgMKATEqAwoBMTAAgAEBgAIBwAIAEggIARAAGAEgARIICAEQARgBIAEyEzQxOTQ1ODk2MTU0NjgzODYyNjQ6exJ5CiUgAjgDQAByFwgBIhEKAwoBMxoKCgMKATEaAwoBMUAFggEDCgE0CiUgAjgDQAByFwgBIhEKAwoBNRoKCgMKATEaAwoBMUAFggEDCgE2SgMKATJaJDdkMmZiYmMxLWQzYmItNGVlNC05MjE4LWVjNjQyMTk1OGM2MkoKCgQIABIAEgISAFgRegplbl9HQi51dGY4ggEKZW5fR0IudXRmODIyCiQ2ZTFkOGQ2ZC00YmQzLTRjYjItODFmNS0yMmQ0YjU3YTMyMTESCk5ldyBUYWJsZTAyOQokN2QyZmJiYzEtZDNiYi00ZWU0LTkyMTgtZWM2NDIxOTU4YzYyEhFGb3JtdWxhIFdvcmtzaGVldDImCiQ0ZDdjMGUyOC03N2NhLTQwZjEtYjU3Mi1lMTk4NWQ2ZmFiZjIyOQokZjVkZDgzZDktODg5ZC00ZjA4LTg3OWUtNjYyZDA4NWZmNzVkEhFPcmRlciBUb3RhbCBQcmljZTImCiQ3NGEwYmI3Mi00Y2E3LTQ1NjEtYWU2OC1mM2UyNjM5NDAwOGYyMAokYzQ3YmE4ZDAtNmQwMi00MzZlLTllNTgtMTEwODM2MjkyOWJjEghRdWFudGl0eTImCiRhODJiYzZlMi1kOTNjLTQwZjQtYmI1Mi02MTFlNmI2NzU3MGI4AoIBIDJkYTVmYWU5NGY0MGY5MjA5MmQ5MmZjYjM2NTM0NjMz",
                                 "sageContextIndex":0,
                                 "text":"order total price quantity",
                                 "isChasmTrapQuery":false
                              },
                              "visualizations":[
                                 {
                                    "vizContent":{
                                       "chartType":"KPI",
                                       "axisConfigs":[
                                          {
                                             "y":[
                                                "74a0bb72-4ca7-4561-ae68-f3e26394008f"
                                             ]
                                          }
                                       ],
                                       "bestAxisConfigs":{
                                          "KPI":{
                                             "y":[
                                                "74a0bb72-4ca7-4561-ae68-f3e26394008f"
                                             ]
                                          }
                                       },
                                       "title":{
                                          "value":{
                                             "text":"Chart 0"
                                          }
                                       },
                                       "customTitle":false,
                                       "locked":false,
                                       "dataOnDemand":false,
                                       "columns":[
                                          {
                                             "isUserSorted":false,
                                             "aggrTypeOverride":"SUM",
                                             "typeOverride":"MEASURE",
                                             "dataTypeOverride":"UNKNOWN",
                                             "formatTypeOverride":"NONE",
                                             "groupBy":false,
                                             "clientState":{
                                                "version":"V1"
                                             },
                                             "uniqueValues":-1,
                                             "sageOutputColumnId":"74a0bb72-4ca7-4561-ae68-f3e26394008f",
                                             "outputIdsWithMatchingLogicalKey":[

                                             ],
                                             "aggrApplied":true,
                                             "isVisible":true,
                                             "columnToFormatPatternType":{

                                             },
                                             "effectiveAggrType":"SUM",
                                             "effectiveDataType":"INT64",
                                             "effectiveType":"MEASURE",
                                             "id":"74a0bb72-4ca7-4561-ae68-f3e26394008f",
                                             "effectiveColumnGuid":"c5d76f1e-4c4f-36c4-8611-c2c4760af126",
                                             "effectiveColumnIdString":"f5dd83d9-889d-4f08-879e-662d085ff75d#SUM#MEASURE#null",
                                             "baseColumnName":"Order Total Price",
                                             "baseAggrType":"SUM",
                                             "baseDataType":"INT64",
                                             "baseType":"MEASURE",
                                             "isBaseColumnAdditive":true,
                                             "referencedTableHeaders":[
                                                {
                                                   "id":"7d2fbbc1-d3bb-4ee4-9218-ec6421958c62",
                                                   "name":"Formula Worksheet"
                                                }
                                             ],
                                             "referencedColumnHeaders":[
                                                {
                                                   "id":"f5dd83d9-889d-4f08-879e-662d085ff75d",
                                                   "name":"Order Total Price"
                                                }
                                             ],
                                             "allLevelReferencedTableHeaders":[
                                                {
                                                   "id":"7d2fbbc1-d3bb-4ee4-9218-ec6421958c62",
                                                   "name":"Formula Worksheet"
                                                },
                                                {
                                                   "id":"2445fe81-30d6-46fa-9f42-f6b1b4e01623",
                                                   "name":"LINEORDER"
                                                }
                                             ],
                                             "allLevelReferencedColumnHeaders":[
                                                {
                                                   "id":"f5dd83d9-889d-4f08-879e-662d085ff75d",
                                                   "name":"Order Total Price"
                                                },
                                                {
                                                   "id":"68b814a8-2389-498e-8dec-8ff0fae22809",
                                                   "name":"Order Total Price"
                                                }
                                             ],
                                             "customOrder":[

                                             ]
                                          },
                                          {
                                             "isUserSorted":false,
                                             "aggrTypeOverride":"SUM",
                                             "typeOverride":"MEASURE",
                                             "dataTypeOverride":"UNKNOWN",
                                             "formatTypeOverride":"NONE",
                                             "groupBy":false,
                                             "clientState":{
                                                "version":"V1"
                                             },
                                             "uniqueValues":-1,
                                             "sageOutputColumnId":"a82bc6e2-d93c-40f4-bb52-611e6b67570b",
                                             "outputIdsWithMatchingLogicalKey":[

                                             ],
                                             "aggrApplied":true,
                                             "isVisible":true,
                                             "columnToFormatPatternType":{

                                             },
                                             "effectiveAggrType":"SUM",
                                             "effectiveDataType":"INT64",
                                             "effectiveType":"MEASURE",
                                             "id":"a82bc6e2-d93c-40f4-bb52-611e6b67570b",
                                             "effectiveColumnGuid":"602f73ae-c959-3a38-ad5c-5443967814ae",
                                             "effectiveColumnIdString":"c47ba8d0-6d02-436e-9e58-1108362929bc#SUM#MEASURE#null",
                                             "baseColumnName":"Quantity",
                                             "baseAggrType":"SUM",
                                             "baseDataType":"INT64",
                                             "baseType":"MEASURE",
                                             "isBaseColumnAdditive":true,
                                             "referencedTableHeaders":[
                                                {
                                                   "id":"7d2fbbc1-d3bb-4ee4-9218-ec6421958c62",
                                                   "name":"Formula Worksheet"
                                                }
                                             ],
                                             "referencedColumnHeaders":[
                                                {
                                                   "id":"c47ba8d0-6d02-436e-9e58-1108362929bc",
                                                   "name":"Quantity"
                                                }
                                             ],
                                             "allLevelReferencedTableHeaders":[
                                                {
                                                   "id":"7d2fbbc1-d3bb-4ee4-9218-ec6421958c62",
                                                   "name":"Formula Worksheet"
                                                },
                                                {
                                                   "id":"2445fe81-30d6-46fa-9f42-f6b1b4e01623",
                                                   "name":"LINEORDER"
                                                }
                                             ],
                                             "allLevelReferencedColumnHeaders":[
                                                {
                                                   "id":"c47ba8d0-6d02-436e-9e58-1108362929bc",
                                                   "name":"Quantity"
                                                },
                                                {
                                                   "id":"8eab0b4b-e3ad-4114-a810-a3665c5defbd",
                                                   "name":"Quantity"
                                                }
                                             ],
                                             "customOrder":[

                                             ]
                                          }
                                       ],
                                       "vizType":"CHART"
                                    },
                                    "relatedLinks":[

                                    ],
                                    "header":{
                                       "id":"491fe06c-a245-41a3-832b-c0fb8d4e3e32",
                                       "indexVersion":119,
                                       "generationNum":119,
                                       "name":"Chart Viz order total price quantity",
                                       "author":"59481331-ee53-42be-a548-bd87be6ddd4a",
                                       "authorName":"tsadmin",
                                       "hasLenientDiscoverability":false,
                                       "authorDisplayName":"Administrator",
                                       "created":1753267514945,
                                       "modified":1753270167020,
                                       "modifiedBy":"59481331-ee53-42be-a548-bd87be6ddd4a",
                                       "owner":"c53e28d3-7ea8-45e1-b752-1146e02d96d8",
                                       "isDeleted":false,
                                       "isHidden":false,
                                       "tags":[

                                       ],
                                       "configs":[

                                       ],
                                       "isConnectionConfigurationDisabled":false,
                                       "type":"QUESTION",
                                       "aiAnswerGenerationDisabled":true,
                                       "isExternal":false,
                                       "isDeprecated":false,
                                       "isSharedViaConnection":false,
                                       "syncWithSource":false,
                                       "isVerified":false,
                                       "isVersioningEnabled":false,
                                       "contentUpgradeId":"MAPBOX_TOKEN_ROTATION_HANDLER",
                                       "headerUpgradeId":"MAPBOX_TOKEN_ROTATION_HANDLER",
                                       "isPublished":false,
                                       "csrProtected":false
                                    },
                                    "complete":true,
                                    "incompleteDetail":[

                                    ]
                                 },
                                 {
                                    "vizContent":{
                                       "vizType":"TABLE",
                                       "columns":[
                                          {
                                             "isUserSorted":false,
                                             "aggrTypeOverride":"SUM",
                                             "typeOverride":"MEASURE",
                                             "dataTypeOverride":"UNKNOWN",
                                             "formatTypeOverride":"NONE",
                                             "groupBy":false,
                                             "clientState":{
                                                "version":"V1"
                                             },
                                             "uniqueValues":-1,
                                             "sageOutputColumnId":"74a0bb72-4ca7-4561-ae68-f3e26394008f",
                                             "outputIdsWithMatchingLogicalKey":[

                                             ],
                                             "aggrApplied":true,
                                             "isVisible":true,
                                             "columnToFormatPatternType":{

                                             },
                                             "effectiveAggrType":"SUM",
                                             "effectiveDataType":"INT64",
                                             "effectiveType":"MEASURE",
                                             "id":"74a0bb72-4ca7-4561-ae68-f3e26394008f",
                                             "effectiveColumnGuid":"c5d76f1e-4c4f-36c4-8611-c2c4760af126",
                                             "effectiveColumnIdString":"f5dd83d9-889d-4f08-879e-662d085ff75d#SUM#MEASURE#null",
                                             "baseColumnName":"Order Total Price",
                                             "baseAggrType":"SUM",
                                             "baseDataType":"INT64",
                                             "baseType":"MEASURE",
                                             "isBaseColumnAdditive":true,
                                             "referencedTableHeaders":[
                                                {
                                                   "id":"7d2fbbc1-d3bb-4ee4-9218-ec6421958c62",
                                                   "name":"Formula Worksheet"
                                                }
                                             ],
                                             "referencedColumnHeaders":[
                                                {
                                                   "id":"f5dd83d9-889d-4f08-879e-662d085ff75d",
                                                   "name":"Order Total Price"
                                                }
                                             ],
                                             "allLevelReferencedTableHeaders":[
                                                {
                                                   "id":"7d2fbbc1-d3bb-4ee4-9218-ec6421958c62",
                                                   "name":"Formula Worksheet"
                                                },
                                                {

---

> **Content truncated.** This page exceeds the inline size limit. View the complete documentation at [https://developers.thoughtspot.com/docs/rest-apiv2-metadata-search](https://developers.thoughtspot.com/docs/rest-apiv2-metadata-search)
