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.

Search lookup table records

  • 1 minute(s) read
Prev Next
Post
/lookupTables/{id}/records/search

Searches and retrieves a list of records in a table based on the query.

Security
HTTP
Type bearer

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

Path parameters
id
string (base64-encoded URI) Required

Lookup table ID in base64-encoded format.

ExampleaHR0cHM6Ly9teGRldjAzeHR2czdzNHZsMi5oYW5hLm9uZGVtYW5kLmNvbS9Mb29rdXBUYWJsZSM0MjQ2ZmJlYzA5NDg0OGEyYmJhZjJkOTk3ZTE0NDE1ZQ==
Body parameters

Example of request payload as resource.

Expand All
object
Example{ "type": "Search", "filter": "", "include": [], "elements": { "bda": [], "bra": [ "F_PRICE", "F_RATE", "DELTA_PRICE" ] }, "sort": [ "id ASC" ], "offset": 0, "limit": 10 }
example
object
type
string
ExampleSearch
filter
string
Example
include
Array of string
string
elements
object
bda
Array of string
string
bra
Array of string
string
sort
Array of string
string
offset
integer
Example0
limit
integer
Example1
Responses
200

Returns the list of table records as a bundle based on the request payload example.

{
  "total": 4,
  "type": "Bundle",
  "entry": [
    {
      "type": "LookupRecord",
      "id": 5,
      "PRODUCT_ID": "000000000000000112",
      "PRICE_ITEM_TYPE": "Calculation",
      "status": 0,
      "last_modified": 1713936390851,
      "F_CURRENCY": "http://www.inmindcloud.com/application/application-implementation.owl#USD",
      "F_BIG_INT": 10,
      "F_BOOLEAN": true,
      "F_BO": "https://my302886.crm.ondemand.com/Currency#Currency_AMD",
      "F_DATE": 1713755940000,
      "F_DECIMAL": 10.1,
      "F_INT": 20,
      "F_FETCH": "Almika Service",
      "F_PERCENT": 20,
      "F_PRICE": [],
      "F_RATE": [],
      "F_STRING": "Test String",
      "DELTA_PRICE": []
    }
  ],
  "include": []
}
Expand All
object
example
object
total
integer
Example4
type
string
ExampleBundle
entry
Array of object
object
type
string
ExampleLookupRecord
id
integer
Example5
PRODUCT_ID
string
Example000000000000000112
PRICE_ITEM_TYPE
string
ExampleCalculation
status
integer
Example0
last_modified
integer
Example1713936390851
F_CURRENCY
string
Examplehttp://www.inmindcloud.com/application/application-implementation.owl#USD
F_BIG_INT
integer
Example10
F_BOOLEAN
boolean
Exampletrue
F_BO
string
Examplehttps://my302886.crm.ondemand.com/Currency#Currency_AMD
F_DATE
integer
Example1713755940000
F_DECIMAL
number
Example10.1
F_INT
integer
Example20
F_FETCH
string
ExampleAlmika Service
F_PERCENT
integer
Example20
F_STRING
string
ExampleTest String
DELTA_PRICE
Array of string
string
include
Array of string
string