Knack Data Model
Knack is a low-code platform to build online databases.
Authentication Authentication can be done using one of the following two alternatives:
- Using the user log on code and password to access Knack views.
- Using an API key to access Knack objects. The API key can be found on the 'API & Code' page in Knack available through the settings gear on the top-left corner next to the word 'Integration'. The URL for the API key is https://builder.knack.com/SAMPLE/integration#settings/api, with 'SAMPLE' replaced by your slug. The slug is the word before 'knack.com' when running your app.
Usage Limits Invantive SQL executes API calls to retrieve and upload data. The number of API calls allowed per hour depends on your Knack plan. The default usage limits vary depending on plan between 1.000 and 25.000 calls per day, with a limit of 10 calls per second. Invantive SQL ensures that within your session the number of calls allowed per hour is not exceeded. To get an impression of how Invantive SQL translates into API calls, please query the data dictionary view 'sessionios', such as with 'select * from sessionios@datadictionary'.
Set up this platform in Invantive Cloud: https://cloud.invantive.com/knack
Text comparisons on this platform are case sensitive.
Platform
- Used from: Invantive Cloud and the Invantive products on your own computer or server.
- Kind: an application reached over its API.
- The data is partitioned, such as per company or administration.
- Data can be written as well as read.
- Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
- Status of the platform: https://status.knack.com/.
- Language of its user community: English.
Figures
| Figure | Count |
|---|---|
| Tables | 45 |
| Columns | 1,257 |
Data Model Poster
This data model declares no keys yet; the dotted relations are derived from column names.
On a table of the poster: plus and minus zoom, the arrow keys move, 0 fits.
The poster as text: tables per topic and their relations
Object
Applications, ObjectFieldValidations, ObjectFields, ObjectInboundConnections, ObjectOutboundConnections, ObjectRuleCriteria, ObjectRuleValues, ObjectRules, Objects, SceneViews, Scenes, Accounts, Payments
Other
Companies, Contacts, ContactsExpanded, Journals
A_B_C (without relations)
Company (without relations)
Date (without relations)
Journal (without relations)
Journals, JournalsMultiple_Choice
NATIVEPLATFORMSCALARREQUESTS (without relations)
Order (without relations)
Product (without relations)
Products, Products, ProductsExpanded
Test (without relations)
Testcase (without relations)
TestcaseIUD, TestcaseIUDExpanded
Testpho (without relations)
Relations
- Applications → Accounts (candidate): Derived from the column account_id.
- ObjectFieldValidations → Applications (candidate): Derived from the column application_id.
- ObjectFieldValidations → Objects (candidate): Derived from the column object_id.
- ObjectFields → Applications (candidate): Derived from the column application_id.
- ObjectFields → Objects (candidate): Derived from the column object_id.
- ObjectInboundConnections → Applications (candidate): Derived from the column application_id.
- ObjectInboundConnections → Objects (candidate): Derived from the column object_id.
- ObjectOutboundConnections → Applications (candidate): Derived from the column application_id.
- ObjectOutboundConnections → Objects (candidate): Derived from the column object_id.
- ObjectRuleCriteria → Applications (candidate): Derived from the column application_id.
- ObjectRuleCriteria → Objects (candidate): Derived from the column object_id.
- ObjectRuleValues → Applications (candidate): Derived from the column application_id.
- ObjectRuleValues → Objects (candidate): Derived from the column object_id.
- ObjectRules → Applications (candidate): Derived from the column application_id.
- ObjectRules → Objects (candidate): Derived from the column object_id.
- Objects → Applications (candidate): Derived from the column application_id.
- SceneViews → Applications (candidate): Derived from the column application_id.
- SceneViews → Scenes (candidate): Derived from the column scene_id.
- Scenes → Applications (candidate): Derived from the column application_id.
- Contacts → Companies (candidate): Derived from the column Company_id.
- ContactsExpanded → Companies (candidate): Derived from the column Company_id.
- Journals → Companies (candidate): Derived from the column Company_id.
- Payments → Accounts (candidate): Derived from the column Account_id.
Tables
Knack.DataDictionary
- ApplicationById: Application by ID
- Applications: Applications
- ObjectFieldValidations: Knack Field Validations
- ObjectFieldValidationsByApplicationId: Knack Field Validations by Application ID
- ObjectFields: Knack Object Fields
- ObjectFieldsByApplicationId: Knack Object Fields by Application ID
- ObjectInboundConnections: Knack Object Inbound Connections
- ObjectInboundConnectionsByApplicationId: Knack Object Inbound Connections by Application ID
- ObjectOutboundConnections: Knack Object Outbound Connections
- ObjectOutboundConnectionsByApplicationId: Knack Object Outbound Connections by Application ID
- ObjectRuleCriteria: Knack Object Rule Criteria
- ObjectRuleCriteriaByApplicationId: Knack Object Rule Criteria by Application ID
- ObjectRuleValues: Knack Object Rule Values
- ObjectRuleValuesByApplicationId: Knack Object Rule Values by Application ID
- ObjectRules: Knack Object Rules
- ObjectRulesByApplicationId: Knack Object Rules by Application ID
- Objects: Knack Objects
- ObjectsByApplicationId: Knack Objects by Application ID
- SceneViews: Knack Scene Views
- SceneViewsByApplicationId: Knack Scene Views by Application ID
- Scenes: Knack Scenes
- ScenesByApplicationId: Knack Scenes by Application ID
Knack.Journal_Details
Knack.Journals
- Journals: Table
Knack.Native
- NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar Requests
Knack.Objects
- A_B_C: A B Cs
- Accounts: Accounts
- Companies: Companies
- CompaniesExpanded: Companies
- Contacts: Contacts
- ContactsExpanded: Contacts
- DateTest: DateTests
- Journals: Journals
- JournalsMultiple_Choice: Multiple choices for Journals
- OrdersObject: OrdersObjects
- Payments: Payments
- Products: Products
- ProductsExpanded: Products
- Test: Tests
- TestExpanded: Tests
- TestcaseIUD: TestcaseIUDs
- TestcaseIUDExpanded: TestcaseIUDs
- testpho: testphos
Knack.Product_Details
Knack.ProductsMenu
- Products: Table
Attributes
The attributes of this platform are on the page Attributes.
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: