Connect MySQL to Knack

Both apps 22MySQL 10Knack 12

• Trigger
  New or Updated Row

  Triggers when a new row is added or modified.

• Trigger
  New or Updated Row (Custom Query)

  Fires for each new or changed row returned by a SELECT statement you write against the connected MySQL database.

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected MySQL database.

• Action
  Add Row

  Adds a new row.

• Action
  Delete Row

  Delete the rows in a table whose chosen column equals a value.

• Action
  Find Row

  Finds a row in a table via a lookup column.

• Action
  Find Rows via Custom Query

  Run an author-written SELECT against the connected MySQL database and return every row it produced. Mirrors PostgreSQL 715ae2ac, SQL Server 8e0bbb5d and Oracle 2c308e4d; MySQL placeholder style is ?.

• Action
  Find Row via Custom Query

  Runs a SELECT statement you write against the connected MySQL database and returns the first row it matches.

• Action
  Update Row

  Updates an existing row.

• Trigger
  New View Record

  Fires when a new record appears in a Knack page view — polls a view's records (respects the view's access control and filters), the view-based counterpart to New Record.

• Action
  Create Record

  Add a new record to a Knack object. Provide field values as a JSON object keyed by field key (e.g. field_1).

• Action
  Create View Record

  create a record through a view, including inserting a connected record (view-based)

• Action
  Delete Record

  Delete a record from a Knack object by ID.

• Action
  Delete View Record

  delete a record through a view (view-based)

• Action
  Get Record

  Retrieve a single record by ID from a Knack object.

• Action
  Get View Record

  Retrieve a single record through a page view by its ID — returns only the fields exposed by the view and respects the view's access control, the view-based counterpart to Get Record.

• Action
  List Records

  Retrieve records from a Knack object, with optional paging and filters.

• Action
  List View Records

  retrieve records through a view (view-based, applies view permissions/filters)

• Action
  Update Record

  Update an existing record in a Knack object by ID.

• Action
  Update View Record

  update a record through a view (view-based)

• Action
  Upload File or Image

  upload a file or image asset to associate with a record field

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.