Create Data Table

Create a new data table and registers it with the Apache Fineract Core application table.

Field Descriptions

Mandatory - datatableName :

The name of the Data Table.

Mandatory - apptableName

Application table name. Must be one of the following:

m_client

m_group

m_loan

m_office

m_saving_account

m_product_loan

m_savings_product

Mandatory - columns
An array of columns in the new Data Table.

Optional - multiRow

Allows to create multiple entries in the Data Table. Optional, defaults to false. If this property is not provided Data Table will allow only one entry.

Field Descriptions - columns

Mandatory - name

Name of the created column. Can contain only alphanumeric characters, underscores and spaces, but cannot start with a number. Cannot start or end with an underscore or space.

Mandatory - type

Column type. Must be one of the following:

Boolean

Date

DateTime

Decimal

Dropdown

Number

String

Text

Mandatory [type = Dropdown] - code

Used in Code description fields. Column name becomes: code_cd_name. Mandatory if using type Dropdown, otherwise an error is returned.

Optional - mandatory

Determines whether this column must have a value in every entry. Optional, defaults to false.

Mandatory [type = String] - length

Length of the text field. Mandatory if type String is used, otherwise an error is returned.

Log in to see full request history
Body Params
string
required
string
required
boolean

Allows to create multiple entries in the Data Table. Optional, defaults to false. If this property is not provided Data Table will allow only one entry.

columns
array of objects
required
columns*
Response

Language
Credentials
:
URL
Click Try It! to start a request and see the response here! Or choose an example:
application/json