Documentation Index

Fetch the complete documentation index at: https://docs.zilliant.com/llms.txt

Use this file to discover all available pages before exploring further.

List lookup tables

  • 3 minute(s) read
Prev Next
Get
/lookupTables

Retrieves the list of lookup tables.

Security
HTTP
Type bearer

OAuth access token. For details, read Obtain or refresh an OAuth token.

Query parameters
filter
string

Filter expression for lookup tables.

resolveRelations
string

Resolve relations option.

Responses
200

Returns lookup table details.

{
  "total": 8,
  "type": "Bundle",
  "entry": [
    {
      "id": "aHR0cHM6Ly9teGRldjAzeHR2czdzNHZsMi5oYW5hLm9uZGVtYW5kLmNvbS9Mb29rdXBUYWJsZSNkNmM5MzI1ZTg1NmU0YmQ1ODgyMGNiMWI5YTU2NTFmMg==",
      "type": "LookupTable",
      "uri": "https://mxdev03xtvs7s4vl2.hana.ondemand.com/LookupTable#d6c9325e856e4bd58820cb1b9a5651f2",
      "objectName": "TEST_UNIQUE",
      "objectId": "d6c9325e856e4bd58820cb1b9a5651f2",
      "objectExternalId": [],
      "objectERPId": [],
      "objectDateOfCreation": 1713331584829,
      "deltaTable": false,
      "objectDateOfUpdate": 1713332050531,
      "lookupTableDescription": [],
      "lookupTableFM": [],
      "lookupTableName": "TEST_UNIQUE",
      "lookupTablePermissionRestrict": [],
      "validFrom": [],
      "validTo": [],
      "lookupTableEditable": true,
      "lookupTableHidden": false,
      "lookupTableType": 4,
      "lookupTableValidityBased": false,
      "objectLastModifiedStateId": "1713332050455",
      "hasAllowRead": [],
      "hasAllowDelete": [],
      "hasAllowEdit": [],
      "includesLookupRecord": [],
      "hasLookupTableStatus": [
        "http://www.inmindcloud.com/application/schema.owl#LOOKUP_TABLE_ACTIVE"
      ],
      "containsLastModifiedUser": [
        "https://mxdev03xtvs7s4vl2.hana.ondemand.com/Employee#876d8d9f38f54d859c40407f03597078"
      ],
      "definesAnnotation": [],
      "includesLookupField": [
        {
          "id": "aHR0cHM6Ly9teGRldjAzeHR2czdzNHZsMi5oYW5hLm9uZGVtYW5kLmNvbS9Mb29rdXBGaWVsZCMyYmIzNjc0ZTdkYTg0NGUzYThjNTc0YzcxNjE5MTdiOA==",
          "type": "LookupField",
          "uri": "https://mxdev03xtvs7s4vl2.hana.ondemand.com/LookupField#2bb3674e7da844e3a8c574c7161917b8",
          "objectName": "AID",
          "lookupFieldSequenceId": 5,
          "lookupFieldName": "AID",
          "lookupFieldSearchable": true,
          "lookupFieldUniqueKey": true,
          "lookupFieldPrimaryKey": [],
          "objectId": "2bb3674e7da844e3a8c574c7161917b8",
          "objectExternalId": [],
          "objectERPId": [],
          "onType": "http://www.inmindcloud.com/application/schema.owl#Account",
          "onAttribute": "http://www.inmindcloud.com/application/schema.owl#objectName",
          "searchExpression": "Quote().quoteContainedBy.objectName[0]",
          "objectDateOfCreation": 1713331667584,
          "lookupFieldDeltaPrice": [],
          "objectDateOfUpdate": 1713331667661,
          "lookupFieldPriceItemType": [],
          "objectLastModifiedStateId": [],
          "hasRecordType": [
            "http://www.inmindcloud.com/application/schema.owl#RecordType_Fetch"
          ],
          "hasLookupFieldDataType": [
            "http://www.inmindcloud.com/application/schema.owl#LookupFieldDataType_String"
          ],
          "linksCurrencyLookupField": [],
          "hasOperator": [],
          "definesAnnotation": [],
          "objectFollowedByUser": [],
          "lookupFieldIncludedBy": [
            "https://mxdev03xtvs7s4vl2.hana.ondemand.com/LookupTable#d6c9325e856e4bd58820cb1b9a5651f2"
          ]
        },
        {
          "id": "aHR0cHM6Ly9teGRldjAzeHR2czdzNHZsMi5oYW5hLm9uZGVtYW5kLmNvbS9Mb29rdXBGaWVsZCM3ZDNjN2RlMmJlZDE0ZjIyYTg5YTcwMmUwYmY3NjNiYg==",
          "type": "LookupField",
          "uri": "https://mxdev03xtvs7s4vl2.hana.ondemand.com/LookupField#7d3c7de2bed14f22a89a702e0bf763bb",
          "objectName": "PID",
          "lookupFieldSequenceId": 4,
          "lookupFieldName": "PID",
          "lookupFieldSearchable": true,
          "lookupFieldUniqueKey": true,
          "lookupFieldPrimaryKey": [],
          "objectId": "7d3c7de2bed14f22a89a702e0bf763bb",
          "objectExternalId": [],
          "objectERPId": [],
          "onType": "http://www.inmindcloud.com/application/schema.owl#Product",
          "onAttribute": "http://www.inmindcloud.com/application/schema.owl#objectERPId",
          "searchExpression": "SalesItem().isProduct.objectERPId[0]",
          "objectDateOfCreation": 1713331605226,
          "lookupFieldDeltaPrice": [],
          "objectDateOfUpdate": 1713331641223,
          "lookupFieldPriceItemType": [],
          "objectLastModifiedStateId": [],
          "hasRecordType": [
            "http://www.inmindcloud.com/application/schema.owl#RecordType_Fetch"
          ],
          "hasLookupFieldDataType": [
            "http://www.inmindcloud.com/application/schema.owl#LookupFieldDataType_String"
          ],
          "linksCurrencyLookupField": [],
          "hasOperator": [],
          "definesAnnotation": [],
          "objectFollowedByUser": [],
          "lookupFieldIncludedBy": [
            "https://mxdev03xtvs7s4vl2.hana.ondemand.com/LookupTable#d6c9325e856e4bd58820cb1b9a5651f2"
          ]
        },
        {
          "id": "aHR0cDovL3d3dy5pbm1pbmRjbG91ZC5jb20vTG9va3VwRmllbGQjMmZjZTJhMDIxNjJkNDU5NThmOTg1MWMwODA0NWYwNzE=",
          "type": "LookupField",
          "uri": "http://www.inmindcloud.com/LookupField#2fce2a02162d45958f9851c08045f071",
          "objectName": "id",
          "lookupFieldSequenceId": 1,
          "lookupFieldName": "id",
          "lookupFieldSearchable": false,
          "lookupFieldUniqueKey": false,
          "lookupFieldPrimaryKey": [],
          "objectId": "2fce2a02162d45958f9851c08045f071",
          "objectExternalId": [],
          "objectERPId": [],
          "onType": [],
          "onAttribute": [],
          "searchExpression": "",
          "objectDateOfCreation": 1713331584834,
          "lookupFieldDeltaPrice": [],
          "objectDateOfUpdate": 1713331584958,
          "lookupFieldPriceItemType": [],
          "objectLastModifiedStateId": [],
          "hasRecordType": [
            "http://www.inmindcloud.com/application/schema.owl#RecordType_Assert"
          ],
          "hasLookupFieldDataType": [
            "http://www.inmindcloud.com/application/schema.owl#LookupFieldDataType_BigInteger"
          ],
          "linksCurrencyLookupField": [],
          "hasOperator": [],
          "definesAnnotation": [],
          "objectFollowedByUser": [],
          "lookupFieldIncludedBy": [
            "https://mxdev03xtvs7s4vl2.hana.ondemand.com/LookupTable#d6c9325e856e4bd58820cb1b9a5651f2"
          ]
        },
        {
          "id": "aHR0cHM6Ly9teGRldjAzeHR2czdzNHZsMi5oYW5hLm9uZGVtYW5kLmNvbS9Mb29rdXBGaWVsZCM0ODE5OTFlNWIzOTE0MzRkOGY0OWVkMGQ2NDlmMTM3Ng==",
          "type": "LookupField",
          "uri": "https://mxdev03xtvs7s4vl2.hana.ondemand.com/LookupField#481991e5b391434d8f49ed0d649f1376",
          "objectName": "Price",
          "lookupFieldSequenceId": 6,
          "lookupFieldName": "Price",
          "lookupFieldSearchable": false,
          "lookupFieldUniqueKey": false,
          "lookupFieldPrimaryKey": [],
          "objectId": "481991e5b391434d8f49ed0d649f1376",
          "objectExternalId": [],
          "objectERPId": [],
          "onType": [],
          "onAttribute": [],
          "searchExpression": "",
          "objectDateOfCreation": 1713331680541,
          "lookupFieldDeltaPrice": [],
          "objectDateOfUpdate": 1713331680618,
          "lookupFieldPriceItemType": [],
          "objectLastModifiedStateId": [],
          "hasRecordType": [
            "http://www.inmindcloud.com/application/schema.owl#RecordType_Price"
          ],
          "hasLookupFieldDataType": [
            "http://www.inmindcloud.com/application/schema.owl#LookupFieldDataType_Decimal"
          ],
          "linksCurrencyLookupField": [],
          "hasOperator": [],
          "definesAnnotation": [],
          "objectFollowedByUser": [],
          "lookupFieldIncludedBy": [
            "https://mxdev03xtvs7s4vl2.hana.ondemand.com/LookupTable#d6c9325e856e4bd58820cb1b9a5651f2"
          ]
        },
        {
          "id": "aHR0cHM6Ly9teGRldjAzeHR2czdzNHZsMi5oYW5hLm9uZGVtYW5kLmNvbS9Mb29rdXBGaWVsZCNkYmE5ZTcxZDM4ODg0YTE5ODNiYjczMGY1YWY3OGUwYQ==",
          "type": "LookupField",
          "uri": "https://mxdev03xtvs7s4vl2.hana.ondemand.com/LookupField#dba9e71d38884a1983bb730f5af78e0a",
          "objectName": "DATA",
          "lookupFieldSequenceId": 7,
          "lookupFieldName": "DATA",
          "lookupFieldSearchable": false,
          "lookupFieldUniqueKey": true,
          "lookupFieldPrimaryKey": [],
          "objectId": "dba9e71d38884a1983bb730f5af78e0a",
          "objectExternalId": [],
          "objectERPId": [],
          "onType": [],
          "onAttribute": [],
          "searchExpression": "",
          "objectDateOfCreation": 1713331941505,
          "lookupFieldDeltaPrice": [],
          "objectDateOfUpdate": 1713331941585,
          "lookupFieldPriceItemType": [],
          "objectLastModifiedStateId": [],
          "hasRecordType": [
            "http://www.inmindcloud.com/application/schema.owl#RecordType_Data"
          ],
          "hasLookupFieldDataType": [
            "http://www.inmindcloud.com/application/schema.owl#LookupFieldDataType_String"
          ],
          "linksCurrencyLookupField": [],
          "hasOperator": [],
          "definesAnnotation": [],
          "objectFollowedByUser": [],
          "lookupFieldIncludedBy": [
            "https://mxdev03xtvs7s4vl2.hana.ondemand.com/LookupTable#d6c9325e856e4bd58820cb1b9a5651f2"
          ]
        },
        {
          "id": "aHR0cDovL3d3dy5pbm1pbmRjbG91ZC5jb20vTG9va3VwRmllbGQjZDgwODlhMDRmZGFiNGVhNDgwM2I4NTA4Nzk0NWZiOTM=",
          "type": "LookupField",
          "uri": "http://www.inmindcloud.com/LookupField#d8089a04fdab4ea4803b85087945fb93",
          "objectName": "last_modified",
          "lookupFieldSequenceId": 3,
          "lookupFieldName": "last_modified",
          "lookupFieldSearchable": false,
          "lookupFieldUniqueKey": false,
          "lookupFieldPrimaryKey": [],
          "objectId": "d8089a04fdab4ea4803b85087945fb93",
          "objectExternalId": [],
          "objectERPId": [],
          "onType": [],
          "onAttribute": [],
          "searchExpression": "",
          "objectDateOfCreation": 1713331584842,
          "lookupFieldDeltaPrice": [],
          "objectDateOfUpdate": 1713331584958,
          "lookupFieldPriceItemType": [],
          "objectLastModifiedStateId": [],
          "hasRecordType": [
            "http://www.inmindcloud.com/application/schema.owl#RecordType_Assert"
          ],
          "hasLookupFieldDataType": [
            "http://www.inmindcloud.com/application/schema.owl#LookupFieldDataType_Date"
          ],
          "linksCurrencyLookupField": [],
          "hasOperator": [],
          "definesAnnotation": [],
          "objectFollowedByUser": [],
          "lookupFieldIncludedBy": [
            "https://mxdev03xtvs7s4vl2.hana.ondemand.com/LookupTable#d6c9325e856e4bd58820cb1b9a5651f2"
          ]
        },
        {
          "id": "aHR0cDovL3d3dy5pbm1pbmRjbG91ZC5jb20vTG9va3VwRmllbGQjNjVhOWE0ZDI2YWI0NGNmNGIxMjE4MDgzNWU1MDgzODQ=",
          "type": "LookupField",
          "uri": "http://www.inmindcloud.com/LookupField#65a9a4d26ab44cf4b12180835e508384",
          "objectName": "status",
          "lookupFieldSequenceId": 2,
          "lookupFieldName": "status",
          "lookupFieldSearchable": false,
          "lookupFieldUniqueKey": false,
          "lookupFieldPrimaryKey": [],
          "objectId": "65a9a4d26ab44cf4b12180835e508384",
          "objectExternalId": [],
          "objectERPId": [],
          "onType": [],
          "onAttribute": [],
          "searchExpression": "",
          "objectDateOfCreation": 1713331584838,
          "lookupFieldDeltaPrice": [],
          "objectDateOfUpdate": 1713331584958,
          "lookupFieldPriceItemType": [],
          "objectLastModifiedStateId": [],
          "hasRecordType": [
            "http://www.inmindcloud.com/application/schema.owl#RecordType_Assert"
          ],
          "hasLookupFieldDataType": [
            "http://www.inmindcloud.com/application/schema.owl#LookupFieldDataType_Integer"
          ],
          "linksCurrencyLookupField": [],
          "hasOperator": [],
          "definesAnnotation": [],
          "objectFollowedByUser": [],
          "lookupFieldIncludedBy": [
            "https://mxdev03xtvs7s4vl2.hana.ondemand.com/LookupTable#d6c9325e856e4bd58820cb1b9a5651f2"
          ]
        }
      ],
      "objectFollowedByUser": []
    }
  ],
  "include": []
}
object
id
string
ExampleaHR0cHM6Ly9teGRldjAzeHR2czdzNHZsMi5oYW5hLm9uZGVtYW5kLmNvbS9Mb29rdXBUYWJsZSM0MjQ2ZmJlYzA5NDg0OGEyYmJhZjJkOTk3ZTE0NDE1ZQ==
type
string
ExampleLookupTable
uri
string
Examplehttps://mxdev03xtvs7s4vl2.hana.ondemand.com/LookupTable#4246fbec094848a2bbaf2d997e14415e
objectName
string
ExampleTEST_API
objectId
string
Example4246fbec094848a2bbaf2d997e14415e
objectExternalId
Array of string
string
objectERPId
Array of string
string
objectDateOfCreation
integer (int64)
Example1713749417294
deltaTable
boolean
Examplefalse
objectDateOfUpdate
integer (int64)
Example1713937218462
lookupTableDescription
Array of string
string
lookupTableFM
Array of string
string
lookupTableName
string
ExampleTEST_API
lookupTablePermissionRestrict
Array of string
string
validFrom
Array of string
string
validTo
Array of string
string
lookupTableEditable
boolean
Exampletrue
lookupTableHidden
boolean
Examplefalse
lookupTableType
integer
Example4
lookupTableValidityBased
boolean
Examplefalse
objectLastModifiedStateId
string
Example1713937218386
hasAllowRead
Array of string
string
hasAllowDelete
Array of string
string
hasAllowEdit
Array of string
string
includesLookupRecord
Array of string
string
hasLookupTableStatus
Array of string
string
Examplehttp://www.inmindcloud.com/application/schema.owl#LOOKUP_TABLE_ACTIVE
containsLastModifiedUser
Array of string
string
definesAnnotation
Array of string
string
includesLookupField
Array of string
string
objectFollowedByUser
Array of string
string