Payments: Knack Payments |
Catalog: Knack
Schema: Objects
Primary Keys: record_id
Label: Payments
Can retrieve data and change data using insert, update and delete.
Select Knack API URL: /objects/object_9/records
Insert Knack API URL: /objects/object_9/records
Update Knack API URL: /objects/object_9/records
Delete Knack API URL: /objects/object_9/records
Field Selection Method: NotRequired
Base Path: records[*]
Table Columns
The columns of the table Payments are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert or update.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
Account_id |
string |
|
☐ |
|
Account_identifier |
string |
|
☐ |
|
Amount |
decimal |
|
☐ |
|
Charge |
string |
|
☐ |
|
Date |
datetime |
|
☐ |
|
Description |
string |
|
☐ |
|
ID |
string |
|
☐ |
|
IP_Address |
string |
|
☐ |
|
Notes |
string |
|
☐ |
|
Processor |
string |
|
☐ |
|
record_id |
string |
|
☑ |
|
Source |
string |
|
☐ |
|
Status |
string |
|
☐ |
|
16-06-2022 09:35 Version 22.1.46-BETA+3385