Connect MySQL to Particle

Both apps 16MySQL 10Particle 6

• 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 device event (instant)

  Fires when a matching device event is published, delivered via a Particle webhook integration.

• Action
  Execute a logic function

  Run a configured Particle Logic function and return its result.

• Action
  Get ledger instance

  Retrieve the current data for a ledger instance (shared cloud/device key-value state).

• Action
  List devices

  List all devices in your account or product fleet.

• Action
  Publish an event

  Publish a custom event to the device cloud so other devices or integrations can subscribe to it.

• Action
  Set ledger instance data

  Update the data stored in a ledger instance.

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