Sign in

v1

latestOpenAPI 3.0.02026-08-064842333.5 MB
Lookup Tables / Company Parameters

List All Lookup Table Values

Retrieves all Company Parameter records for the specified Company Parameter table (LookupTable).<p> Export the table to the Excel file (XLSX) using the output=xls URL query parameter. When exporting to the file, specify fields (within the resultFields property) you want to include in the output table.<p> Example:

{
   "data":{
      "criteria":[

      ],
      "operator":"and"
   },
   "resultFields":[
      "key1",
      "key2",
      "key3",
      "attribute1",
      "attribute2",
      "attribute3"
   ],
   "valueFields":[

   ]
}
post/lookuptablemanager.fetch/{tableId}

Query parameters

output'json' | 'xls' | 'csv' | 'pdf'
Example:xls

Specifies the format of the output file.

useColumnNames'true' | 'false'
Example:false

Set to false to retrieve the table with labels (as used in the database) instead of names in the table header.

Request body

endRownumber

The number of the end row that defines the end of the result set's returned objects. Use this parameter if you want to implement paging for results.

{"stackTrail":"paths:/lookuptablemanager.fetch/{tableId}:post:requestBody:content:application/json:schema:properties:oldValues","oasType":"schema","type":"unknown"}
operationTypestring
startRownumber

The number of the first row that defines the start of the result set's returned objects. Use this parameter if you want to implement paging for results.

textMatchStylestring
sortByobject[]

Response

OK