invantive documentation
Invantive Support ForumsLog In / Sign Up

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:

  1. Using the user log on code and password to access Knack views.
  2. 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.

PDF, 1 A0 sheet

On a table of the poster: plus and minus zoom, the arrow keys move, 0 fits.

Knack data model, Sheet 1 of 1Knack data modelfor use with Invantive UniversalSQLRelease 25.0.205-PROD+5751 · 19-05-2026Object · OtherSheet 1 of 1 · documentation.invantive.euObjectKnack.DataDictionary.Applications: ApplicationsApplicationsKnack.DataDictionary.ObjectFieldValidations: Knack Field ValidationsObjectFieldValidationsKnack.DataDictionary.ObjectFields: Knack Object FieldsObjectFieldsKnack.DataDictionary.ObjectInboundConnections: Knack Object Inbound ConnectionsObjectInboundConnectionsKnack.DataDictionary.ObjectOutboundConnections: Knack Object Outbound ConnectionsObjectOutboundConnectionsKnack.DataDictionary.ObjectRuleCriteria: Knack Object Rule CriteriaObjectRuleCriteriaKnack.DataDictionary.ObjectRuleValues: Knack Object Rule ValuesObjectRuleValuesKnack.DataDictionary.ObjectRules: Knack Object RulesObjectRulesKnack.DataDictionary.Objects: Knack ObjectsObjectsKnack.DataDictionary.SceneViews: Knack Scene ViewsSceneViewsKnack.DataDictionary.Scenes: Knack ScenesScenesKnack.Objects.Accounts: AccountsAccountsKnack.Objects.Payments: PaymentsPaymentsOtherKnack.Objects.Companies: CompaniesCompaniesKnack.Objects.Contacts: ContactsContactsKnack.Objects.ContactsExpanded: ContactsContactsExpandedKnack.Objects.Journals: JournalsJournalsA_B_CKnack.Objects.A_B_C: A B CsA_B_CCompanyKnack.Objects.CompaniesExpanded: CompaniesCompaniesExpandedDateKnack.Objects.DateTest: DateTestsDateTestJournalKnack.Journals.Journals: TableJournalsKnack.Objects.JournalsMultiple_Choice: Multiple choices for JournalsJournalsMultiple_ChoiceNATIVEPLATFORMSCALARREQUESTSKnack.Native.NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar RequestsNATIVEPLATFORMSCALARREQUESTSOrderKnack.Objects.OrdersObject: OrdersObjectsOrdersObjectProductKnack.Objects.Products: ProductsProductsKnack.ProductsMenu.Products: TableProductsKnack.Objects.ProductsExpanded: ProductsProductsExpandedTestKnack.Objects.Test: TestsTestKnack.Objects.TestExpanded: TestsTestExpandedTestcaseKnack.Objects.TestcaseIUD: TestcaseIUDsTestcaseIUDKnack.Objects.TestcaseIUDExpanded: TestcaseIUDsTestcaseIUDExpandedTestphoKnack.Objects.testpho: testphostestphoKnackAuthentication Authentication can be done using one of thefollowing two alternatives: 1. Using the user log on code andpassword to access Knack views. 2. Using an API key to accessKnack objects. The API key can be found on the 'API & Code'page in Knack available through the settings gear on thetop-left corner next to the word 'Integration'. The URL for theNotesThis data model declares no keys yet; the dotted relations are derived from column names.Data dictionaryEvery table and column of this data model is described with its documentation ondocumentation.invantive.eu, where the poster is also available in other languages.NotesThe boxes are grouped by topic and coloured by category. A relation is drawn in the topic of thetable holding the key; a box in pale grey is defined in another topic.TopicsObject1Other1Tables without relations1LegendTransactionalSetupTechnicalHard-coded valuesDefined in another topicDeclared keyRelation described in wordsCandidate derived from column namesBold: a popular table+Bulk, +Read: the table also exists as these variants×n: n relations between the same tablesGenerated from the metadata of Invantive UniversalSQL 25.0.205-PROD+5751 on 19-05-2026. Every table links toits page with columns, keys and sample queries.documentation.invantive.eu/en/datamodels/knack
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)

A_B_C

Company (without relations)

CompaniesExpanded

Date (without relations)

DateTest

Journal (without relations)

Journals, JournalsMultiple_Choice

NATIVEPLATFORMSCALARREQUESTS (without relations)

NATIVEPLATFORMSCALARREQUESTS

Order (without relations)

OrdersObject

Product (without relations)

Products, Products, ProductsExpanded

Test (without relations)

Test, TestExpanded

Testcase (without relations)

TestcaseIUD, TestcaseIUDExpanded

Testpho (without relations)

testpho

Relations

Tables

Knack.DataDictionary

Knack.Journal_Details

Knack.Journals

Knack.Native

Knack.Objects

Knack.Product_Details

Knack.ProductsMenu

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: