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.

Language
Credentials
:
URL
Click Try It! to start a request and see the response here!