Tables API
Note
Data Tables are used in plugins to support calculations. Constraint Tables are used to support UI development by filtering options for the user.
Data Tables
Usage
GET /resource/{tenantLocator}/tables/{name}/record
Request Parameters:
Name | Position | Type | Required |
---|---|---|---|
tenantLocator | path | uuid | required |
name | path | string | required |
date | query | datetime? | optional |
byStaticName | query | boolean? | optional |
key | query | string[] | required |
Response:TableLookupResponse
Security Group:tables  Permission:read
TableLookupResponse
¶requiredvalue object
Configuration
GET /resource/{tenantLocator}/tables/{name}
Request Parameters:
Name | Position | Type | Required |
---|---|---|---|
tenantLocator | path | uuid | required |
name | path | string | required |
Response:StreamingResponseBody<ZipFile>
Security Group:tables  Permission:read
POST /resource/{tenantLocator}/tables
Request Parameters:
Name | Position | Type | Required |
---|---|---|---|
tenantLocator | path | uuid | required |
name | query | string | required |
staticName | query | string | required |
Request:file
Response:BasicResourceResponse
Security Group:tables  Permission:upload
PATCH /resource/{tenantLocator}/tables/{name}
Request Parameters:
Name | Position | Type | Required |
---|---|---|---|
tenantLocator | path | uuid | required |
name | path | string | required |
Request:file
Response:BasicResourceResponse
Security Group:tables  Permission:upload
Constraint Tables
Quotes
GET /policy/{tenantLocator}/quotes/{locator}/constraints/dependency
Request Parameters:
Name | Position | Type | Required |
---|---|---|---|
tenantLocator | path | uuid | required |
locator | path | locator | required |
Response:map<string,map<string,ConstraintDependency>>
Security Group:quotes  Permission:read
ConstraintDependency
¶requiredcolumn stringtable stringwhere map<string,ConditionValue>
ConditionValue
¶requiredstaticLocator locatorfieldName stringvalues string[]
POST /policy/{tenantLocator}/quotes/{locator}/constraints/evaluate
Request Parameters:
Name | Position | Type | Required |
---|---|---|---|
tenantLocator | path | uuid | required |
locator | path | locator | required |
Request:map<string,map<string,map<string,string>>>
Response:map<string,map<string,string[]>>
Security Group:quotes  Permission:read
Quick Quotes
POST /policy/{tenantLocator}/quickquotes/{locator}/constraints/evaluate
Request Parameters:
Name | Position | Type | Required |
---|---|---|---|
tenantLocator | path | uuid | required |
locator | path | locator | required |
Request:map<string,map<string,map<string,string>>>
Response:map<string,map<string,string[]>>
Security Group:quick-quotes  Permission:read
GET /policy/{tenantLocator}/quickquotes/{locator}/constraints/dependency
Request Parameters:
Name | Position | Type | Required |
---|---|---|---|
tenantLocator | path | uuid | required |
locator | path | locator | required |
Response:map<string,map<string,ConstraintDependency>>
Security Group:quick-quotes  Permission:read
Policy Transactions
GET /policy/{tenantLocator}/transactions/{locator}/elements/constraints/dependency
Request Parameters:
Name | Position | Type | Required |
---|---|---|---|
tenantLocator | path | uuid | required |
locator | path | locator | required |
Response:map<string,map<string,ConstraintDependency>>
Security Group:transactions  Permission:read
POST /policy/{tenantLocator}/transactions/{locator}/elements/constraints/evaluate
Request Parameters:
Name | Position | Type | Required |
---|---|---|---|
tenantLocator | path | uuid | required |
locator | path | locator | required |
Request:map<string,map<string,map<string,string>>>
Response:map<string,map<string,string[]>>
Security Group:transactions  Permission:read
Configuration
GET /resource/{tenantLocator}/constraints/{name}/record
Request Parameters:
Name | Position | Type | Required |
---|---|---|---|
tenantLocator | path | uuid | required |
name | path | string | required |
date | query | datetime? | optional |
byStaticName | query | boolean? | optional |
key | query | string[]? | optional |
Response:map<string,object[]>
Security Group:constraints  Permission:read
POST /resource/{tenantLocator}/constraints
Request Parameters:
Name | Position | Type | Required |
---|---|---|---|
tenantLocator | path | uuid | required |
name | query | string | required |
staticName | query | string | required |
Request:file
Response:BasicResourceResponse
Security Group:constraints  Permission:upload
PATCH /resource/{tenantLocator}/constraints/{name}
Request Parameters:
Name | Position | Type | Required |
---|---|---|---|
tenantLocator | path | uuid | required |
name | path | string | required |
Request:file
Response:BasicResourceResponse
Security Group:constraints  Permission:upload
GET /resource/{tenantLocator}/constraints/{name}
Request Parameters:
Name | Position | Type | Required |
---|---|---|---|
tenantLocator | path | uuid | required |
name | path | string | required |
Response:StreamingResponseBody<ZipFile>
Security Group:constraints  Permission:read