Test: Knack Tests |
Catalog: Knack
Schema: Objects
Primary Keys: record_id
Label: Tests
Can retrieve data and change data using insert, update and delete.
Select Knack API URL: /objects/object_4/records
Insert Knack API URL: /objects/object_4/records
Update Knack API URL: /objects/object_4/records
Delete Knack API URL: /objects/object_4/records
Field Selection Method: NotRequired
Base Path: records[*]
Table Columns
The columns of the table Test 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 |
---|---|---|---|---|
AddressWithGeocoding_city |
string |
|
☐ |
|
AddressWithGeocoding_latitude |
decimal |
|
☐ |
|
AddressWithGeocoding_longitude |
decimal |
|
☐ |
|
AddressWithGeocoding_state |
string |
|
☐ |
|
AddressWithGeocoding_street |
string |
|
☐ |
|
AddressWithGeocoding_street2 |
string |
|
☐ |
|
AddressWithGeocoding_zip |
string |
|
☐ |
|
Auto_Increment |
decimal |
|
☐ |
|
Currency |
decimal |
|
☐ |
|
Date_Time |
datetime |
|
☐ |
|
Email_email |
string |
|
☐ |
|
Email_label |
string |
|
☐ |
|
Equation |
decimal |
|
☐ |
|
File_filename |
string |
|
☐ |
|
File_s3 |
boolean |
|
☐ |
|
File_size |
int32 |
|
☐ |
|
File_thumb_url |
string |
|
☐ |
|
File_type |
string |
|
☐ |
|
File_url |
string |
|
☐ |
|
Image_filename |
string |
|
☐ |
|
Image_s3 |
boolean |
|
☐ |
|
Image_size |
int32 |
|
☐ |
|
Image_thumb_url |
string |
|
☐ |
|
Image_type |
string |
|
☐ |
|
Image_url |
string |
|
☐ |
|
IntlAddress_city |
string |
|
☐ |
|
IntlAddress_state |
string |
|
☐ |
|
IntlAddress_street |
string |
|
☐ |
|
IntlAddress_street2 |
string |
|
☐ |
|
IntlAddress_zip |
string |
|
☐ |
|
IntlAddressLatLng_latitude |
decimal |
|
☐ |
|
IntlAddressLatLng_longitude |
decimal |
|
☐ |
|
IntlAddressWithCountry_city |
string |
|
☐ |
|
IntlAddressWithCountry_country |
string |
|
☐ |
|
IntlAddressWithCountry_state |
string |
|
☐ |
|
IntlAddressWithCountry_street |
string |
|
☐ |
|
IntlAddressWithCountry_street2 |
string |
|
☐ |
|
IntlAddressWithCountry_zip |
string |
|
☐ |
|
Link_label |
string |
|
☐ |
|
Link_url |
string |
|
☐ |
|
Multiple_Choice |
string |
|
☐ |
|
Name_firstname |
string |
|
☐ |
|
Name_lastname |
string |
|
☐ |
|
Name_middlename |
string |
|
☐ |
|
Name_title |
string |
|
☐ |
|
Number |
decimal |
|
☐ |
|
Paragraph_Text |
string |
|
☐ |
|
Phone |
string |
|
☐ |
|
Rating |
decimal |
|
☐ |
|
record_id |
string |
|
☑ |
|
Rich_Text |
string |
|
☐ |
|
Signature_base30 |
string |
|
☐ |
|
Signature_svg |
string |
|
☐ |
|
Test_Name |
string |
|
☐ |
|
Text_Formula |
string |
|
☐ |
|
Timer_from_min |
datetime |
|
☐ |
|
Timer_stop_count |
int32 |
|
☐ |
|
Timer_to_max |
datetime |
|
☐ |
|
Timer_total_time |
int64 |
|
☐ |
|
USAddress_city |
string |
|
☐ |
|
USAddress_state |
string |
|
☐ |
|
USAddress_street |
string |
|
☐ |
|
USAddress_street2 |
string |
|
☐ |
|
USAddress_zip |
string |
|
☐ |
|
Yes_No |
boolean |
|
☐ |
|
16-06-2022 09:35 Version 22.1.46-BETA+3385