Get All Custom Tables for Record

Gets all the custom tables associated with the specified record.

Resource Information

Scope	records Deprecated scope name: get_record_customtables
App Type	All
Authorization Type	No authorization required
URI	/v4/records/{recordId}/customTables?lang={lang}
HTTP Method	GET
Automation Version(s)	7.3.2

Request Information

Field or Parameter	Type	Required	Values	Description	Automation Version
fields	string	No	�	Comma-delimited names of fields to be returned in the response. Note: Field names are case-sensitive and only first-level fields are supported. Invalid field names are ignored.	7.3.2
lang	String	No	�	Indicates the language applied.	7.3.2
recordId	string	Yes	Get All Records Search Records Get My Records	The unique ID associated with a record.	7.3.2

Example

Sample Request Head

GET https://apis.accela.com/v4/records/12CAP-00000-00003/customTables

Notes

The following sample request uses the ISLANDTON agency in the TEST environment on the Accela Developer Sandbox. Click the "Send to Hurl.It" link below to submit the sample request. Replace YOUR-ACCESS-TOKEN before submitting the request.

curl
   -H 'Content-type: application/json'
   -H 'Accept: application/json'
   -H 'Authorization: YOUR-ACCESS-TOKEN'
   -X GET https://apis.accela.com/v4/records/12CAP-00000-00003/customTables

Response Information

Field	Type	Description	Automation Version
result[]	result{}	�	7.3.2
result.id	string	The unique identifier for the object, assigned by the Civic Platform server and provided in a response.	7.3.2
result.rows[]	result.rows{}	Contains the table rows.	7.3.2
result.rows.action	string	Audit trail action type like 'payment allocation'	7.3.2
result.rows.fields	result.rows.fields{}	Contains fields and their attributes.	7.3.2
result.rows.fields.<customType>	string	A custom field name and value pair. For example in JSON, "My Custom Field": "My Custom Value". The custom field name and its data type are defined in Automation custom forms or custom tables. For a Text field, the maximum length is 256. For a Number field, any numeric form is allowed, including negative numbers. For a Date field, the format is MM/dd/yyyy. For a Time field, the format is hh:mm. For a TextArea field, the maximum length is 4000 characters, and allows line return characters. For a DropdownList field, the dropdown list values are in the options[] array. For a CheckBox field, the (case-sensitive) valid values are "UNCHECKED" and "CHECKED". For a Radio(Y/N) field, the(case-sensitive) valid values are "Yes" and "No".	7.3.2
result.rows.id	string	The unique identifier for the object, assigned by the Civic Platform server and provided in a response.	7.3.2
status	integer	The record status.	7.3.3

Example

Sample Response Body

{
  "status": 200,
  "result": [
    {
      "id": "BLD_STANDARD-PLANS.cSUBMITTED",
      "rows": [
        {
          "id": "1",
          "fields": {
            "Comments": "2",
            "Plan Type": "Civil",
            "Number of Sets": "1"
          }
        }
      ]
    }
  ]
}