Connect MySQL to PayCrunch

Both apps 15MySQL 10PayCrunch 5

• 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.

• Action
  Get job

  Get full wage and detail data for one occupation by its slug. Endpoint: GET /jobs/{slug}.json

• Action
  Get SOC code wage data

  Get the state-by-state wage table for one Standard Occupational Classification (SOC) code. Endpoint: GET /soc/{code}.json

• Action
  List best-paying states by occupation

  List the best-paying state for each occupation. Endpoint: GET /states.json

• Action
  List jobs

  List every occupation covered by PayCrunch, with summary wage data. Endpoint: GET /jobs.json

• Action
  List state wages

  List wage figures by state for every occupation. Endpoint: GET /state-wages.json

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