Database
Knack
15min
with the knack modules in make, you can watch new events and records, create, update, search, retrieve, and delete records, and upload new files or images to get started with knack, create an account at knack com https //www knack com/ connect knack to make to connect knack app, you need to obtain the application id and api key from your knack account and insert them into your make {{scenario singular lowercase}} log in to your knack account and navigate to the settings > apps in the my apps section, click app builder next to your app click settings > api & code copy the application id and api key to a safe place in your make account, insert a knack module in your {{scenario singular lowercase}} and click the add button next to the connection field optional in the connection name field, enter a name for the connection in the application id and api key fields, enter the details copied in step 3 in the private api server domain field, enter the private knack server domain if needed and click save you have successfully established the connection you can now edit your {{scenario singular lowercase}} and add more knack modules if your connection needs reauthorization at any point, follow the connection renewal steps here docid\ so88fm6pkt0g adkddfzz triggers new event triggers when a new record is created, updated, or deleted and forms submitted webhook name enter the name of the webhook connection knack docid\ r7dvtsn2uuntoyia1aj5j object select the object you want to watch event select the event that triggers the module the trigger knack > new event triggers only when records are created/updated/deleted in your knack app, not in the knack builder if the url in your web browser starts with https //builder knack com/ then you are using the knack builder, not your knack app to enter your knack app, click on the "view live app" button in the top right corner to create the links, follow the using actions links guide https //learn knack com/article/asw2x5q7pk using action links#adding action links links to update and/or edit the record must be created watch records triggers when a new record is added connection knack docid\ r7dvtsn2uuntoyia1aj5j object select the object you want to watch auto increment field select the auto increment field every object that you want make to watch must have at least one field of auto increment type the auto increment field contains a sequence number assigned to the record the value for the first record is 1, and it increments by 1 for each new record warning make will not correctly import records that do not include this field the option since specific id in the choose where to start dialog must contain the auto increment value, e g 1 do not use the record id ! limit the maximum number of records make will work with during one execution cycle returned data select the format type of the returned data formatted and raw the returned data is formatted and raw only formatted the returned data is formatted into one line only raw the data is returned in the raw format, as an object actions create a record creates a new record make allows the adding of records to all types of object fields, except for these types timer and signature connection knack docid\ r7dvtsn2uuntoyia1aj5j object select the object where you want to create the record field names enter the values you want to add to the new record delete a record deletes a record specified by its id connection knack docid\ r7dvtsn2uuntoyia1aj5j object select the object you want to delete record id enter the id of the record you want to delete it can be retrieved, for example, using the search for records module get a record returns details about a record specified by its id connection knack docid\ r7dvtsn2uuntoyia1aj5j object select the object that contains the desired record record id enter the record id it can be retrieved, for example, using the search for records module returned data select the format type of the returned data formatted and raw the returned data is formatted and raw only formatted the returned data is formatted into one line only raw the data is returned in raw format, as an object update a record updates a record specified by its id connection knack docid\ r7dvtsn2uuntoyia1aj5j object select the object that contains the record you want to update record id enter the id of the record you want to update the id can be retrieved, for example, using the search for records module field names enter the desired value to the field(s) you want to update upload a file uploads a file or image connection knack docid\ r7dvtsn2uuntoyia1aj5j file name enter or map the file name data enter (map) the file data you can use, for example, the dropbox > get a file module make an api call performs an arbitrary authorized api call connection knack docid\ r7dvtsn2uuntoyia1aj5j url enter a path relative to https //api knack com (or custom domain) for example, /v1/objects method get to retrieve information for an entry post to create a new entry put to update/replace an existing entry patch to make a partial entry update delete to delete an entry headers enter the desired request headers you don't have to add authorization headers; we already did that for you query string enter the request query string body enter the body content for your api call example of use search tasks the following api call returns all tasks from your account url /v1/objects method get matches of the search can be found in the module's output under bundle > body > objects in our example, 3 objects were returned searches search for records searches for a record this module retrieves information about records the result can be filtered connection knack docid\ r7dvtsn2uuntoyia1aj5j object select the object with the records you want to retrieve filter specify the filter settings e g the following example returns a record where the name is john and the amount is higher than 100 sort field select the field you want to sort the result by sort order select the sort order asc ascending desc descending limit set the maximum number of records make will return during one execution cycle returned data select the format type of the returned data formatted and raw the returned data is formatted and raw only formatted the returned data is formatted into one line only raw the data is returned in raw format, as an object private knack servers make will make connections to your database from its ip addresses docid\ d0fwd60kzrvcj9b0ozriy ensure you allow list the ip addresses to allow conections to your knack servers see also blog post triggering make from ninox https //www onlinedatabase expert/post/triggering integromat from ninox by julian kirkness https //www facebook com/julian kirkness 3 at online database expert https //www onlinedatabase expert/