API Creation Endpoints

The 
CA Live API Creator
 Admin Project API provides endpoints and attributes.
lac31
The 
CA Live API Creator
 Admin Project API provides the following endpoints and attributes:
The 
ident
 and 
ts
 attributes are excluded from the table but are present in all cases except where noted. Required attributes are in bold. Unused attributes are in ita
lics
. Some endpoints, such as 
rules
 and 
resources
, are non-obvious. To give you guidance, we recommend you create them using API Creator and then look at them in the API.
Endpoint
Description
Attributes
accounts
The account that your API is part of.
For more information about this endpoint, see The accounts Endpoint.
"
name
": "default account",
"
url_name
": "default",
"
status
": "A",
"
public_key
": null,
"
private_key
": null
apikeyroles
The connection between auth tokens and roles.
"apikey_ident": 2142,
"role_ident": 2052
apikeys
The auth tokens for an API.
For more information about auth tokens, see Auth Tokens.
"
name
": "Bob's key",
"description": "Auth token for Bob",
"
apikey
": "UED8gvCScR0ahxGQ1d9N",
"
status
": "A",
"expiration": "2015-11-26T21:27:44.709Z",
"logging": "*=FINE",
"user_identifier": "bob",
"data": "username=bob",
"origin": "A",
"
project_ident
": 2022
apiversions
The API versions.
For more information about API versions, including a complete list of this endpoint's attributes, see API Versions.
"
name
": "v1",
"comments": "Version 1 of my API",
"
project_ident
": 2022
authproviders
The authentication providers. 
"
name
": "Built-in authentication",
"comments": null,
"
auth_type_ident
": 1,
"
class_name
": "com.acme.AuthProvider",
"bootstrap_config_value": null,
"class_location": "",
"param_map": "datasource=AdminDB",
"
account_ident
": 1000
dbaseschemas
The connection to the database. 
"
conn_type
": null,
"
prefix
": "nw",
"
name
": "Database: Derby - Northwind",
"comments": "Northwind db",
"datasource_name": null,
"
url
": "jdbc:derby:Northwind",
"catalog_name": null,
"schema_name": null,
"user_name": "Northwind",
"password": "2:nZkkWa3wn1n7ORL...l1g==",
"salt": "ei2Eh8Pq/d62gq...1u2CV1",
"port_num": null,
"read_only": null,
"schema_editable": null,
"admin_url": null,
"
active
": true,
"status": null,
"
project_ident
": 2022,
"
dbasetype_ident
": 17
dbasetypes
The database types that 
CA Live API Creator
 supports.
For more information about the 
dbasetypes
 endpoint, see The dbasetypes Endpoint.
"
name
": "MySQL",
"description": "MySQL Database",
"version_name": "All versions",
"
driver_class_name_list
": "com.mysql.jdbc.Driver",
"catalog_term": "Database",
"schema_term": null,
"url_prototype": "jdbc:mysql://<host>:<port>/<db>",
"
driver_help
": null,
"enabled": true,
"managed_data_capable": true
eventhandlers
The resource event handlers.
"
name
": "Inject metadata tags",
"description": null,
"
code
": "if etc...\n",
"
active
": true,
"enabled_verbs": null,
"resource_name_pattern": null,
"
eventtype_ident
": 1,
"code_type": null,
"
project_ident
": 2025
gateways
The CA API Gateway integration definition endpoint.
"name": "CA API Gateway Development Server",
"default_username": "test",
"url": "http://someserver:8657",
"comments": "test",
"account_ident": 1,
"is_active": true
handlers
The HTTP handlers.
"
name
": "My custom endpoint",
"
active
": true,
"
url_pattern
": "special/.*",
"
verbs
": "GET,",
"
code
": "if etc...\n",
"comments": null,
"
project_ident
": 2033
managed_data_servers
Used to define a connection url for managed database services (adding databases, tables, columns, and relationships).
"
name
": "testing_postgres",
"comments": "this is a postgresql comment",
"datasource_name": null,
"url": "jdbc:postgresql://192.168.99.100:5432/postgres",
"catalog_name": null,
"
user_name
": "postgres",
"
password
": "password1",
"
is_active
": true,
"
dbasetype_ident
": 8,
"
account_ident
": 1000
named_filters
Named filters, created to handle complex queries without risking a SQL injection.
"
name
": "My filter",
"description": "Yadda yadda",
"
resource_names
": "customers",
"
filter_text
": "balance < {bal}",
"
project_ident
": 2033
named_sorts
Named sorts, created to provide complex sorting without risking a SQL injection.
"
name
": "My sort",
"description": "Desc here",
"
resource_names
": "customers",
"
sort_text
": "round(balance)",
"
project_ident
": 2033
permissiondata
The additional data attached to roles.
"
name
": "Data",
"description": "Employee number",
"
prefix
": "cust",
"
query
": "select empno from etc...",
"query_order": 1,
"required": true,
"
code_type
": "SQL",
"
role_ident
": 2075
projectoptions
The options for an API.
"
option_value
": "20",
"
project_ident
": 2022,
"
projectoptiontype_ident
": 7
projectoptiontypes
The possible types of options.
Note: 
You cannot alter these type.
"
name
": "HTTPS only",
"
data_type
": "boolean",
"description": "Yadda yadda.",
"default_value": "false",
"valid_values": null,
"
system_only
": false
projects
The API.
"
name
": "Northwind",
"
url_name
": "nw",
"comments": "Simple order processing demo",
"status": null,
"
is_active
": true,
"
account_ident
": 1000,
"
authprovider_ident
": 1000
relationships
Virtual foreign keys between tables (potentially in different databases).
"
name
": "Between customers and orders", "
parent_entity_name
": "cust:customers", "
child_entity_name
": "cust:orders", "
role_to_child
": "orders", "
role_to_parent
": "customer", "
parent_columns
": "cust_no", "
child_columns
": "customer_no", "
update_rule
": "R", "
delete_rule
": "R", "comments": "Yadda", "
project_ident
": 2033
resource_types
The types of resources. You cannot change the resource types.
"
ident
": 1,
"
description
": "Normal resource"
resourceattributes
An attribute in a resource. If a resource has none of these, then it is assumed that all columns for its table should be included in the resource.
"
name
": "ID",
"description": null,
"
column_name
": "CustomerID",
"format": null,
"formula": null,
"is_defined_key_part": false,
"
resource_ident
": 2070,
"code_type": null
resources
A resource that can be part of a resource tree.
"
resource_type_ident
": 1,
"
prefix
": "nw",
"
table_name
": "Customers",
"
name
": "CustomersWithOrders",
"description": "Customers with orders",
"is_collection": "Y",
"join_condition": null,
"filter": null,
"sorting": "\"CompanyName\" asc",
"attach_path": null,
"caching": null,
"custom_class": null,
"code_text": null,
"filter_code": null,
"serial_filter": null,
"prop1": null,
"prop2": null,
"prop3": null,
"prop4": null,
"prop5": null,
"container_ident": null,
"sibling_rank": 100,
"root_ident": null,
"linked_ident": null,
"
apiversion_ident
": 2022
roles
The security roles defined as part of an API.
"
name
": "Full access",
"description": "Full access to this API",
"
default_permission
": "A",
"
default_apivisibility
": "TVPRM",
"
project_ident
": 2022
rules
The business logic for an API.
"
entity_name
": "nw:Customers",
"attribute_name": null,
"prop1": null,
"prop2": null,
"prop3": null,
"prop4": "javascript",
"prop5": null,
"rule_text1": "return etc...;",
"rule_text2": "Transaction cannot be etc...",
"rule_text3": null,
"rule_text4": null,
"rule_text5": null,
"predicate": null,
"name": "",
"auto_name": "Validation etc...",
"verbs": null,
"comments": "Yadda yadda",
"
active
": true,
"
project_ident
": 2022,
"
ruletype_ident
": 5
ruletypes
The types of rules.
 
Note: 
You cannot change the rule types.
"
name
": "sum",
"method": null,
"template": "Derive etc...",
"short_desc": "sum child attr into parent",
"description_url": null,
"
ruleexecutiontype_ident
": 1,
"isCore": null
tablepermissions
The permissions for a role's table.
"
name
": "My Regions Customer",
"description": "Yadda yadda",
"
entity_name
": "nw:Customers",
"column_names": null,
"predicate": "\"Region\" = '@{UserRegion}'",
"
access_type
": "A",
"
role_ident
": 2054
topics
The topics for rules.
"
name
": "Customer creation",
"color": "#a4fcc6",
"summary": "Yadda yadda",
"description": "HTML code here",
"
project_ident
": 2031
users
The users for the built-in authentication provider.
"
name
": "bob",
"fullname": "Bob Newhart",
"email": "[email protected]",
"
status
": "A",
"
roles
": "Customer rep,",
"data": "empId=1234",
"comments": "Yadda",
"apikey_lifespan": null,
"password_hash": "thCQL0ADu2...ZQ==",
"password_salt": "MSUVe...BmCqQ==",
"
project_ident
": 3