Connect MySQL to Wicked Reports

Both apps 26MySQL 10Wicked Reports 16

• 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
  Add Marketing Cost

  Sends ad spend, clicks and conversions from an ad platform Wicked Reports does not integrate with, so cost is included in ROI reports.

• Action
  Create Contact

  Sends a contact (lead) from your CRM or email platform into Wicked Reports for attribution. Contacts already present by email are ignored.

• Action
  Create Order

  Sends an order from your cart or payment system into Wicked Reports so revenue is attributed to marketing.

• Action
  Create Order Item

  Adds a line item (product, quantity, unit price) to an order already sent to Wicked Reports.

• Action
  Create Order Payment

  Records a payment, failure or refund against an order in Wicked Reports.

• Action
  Create or Update Product

  Creates a product in Wicked Reports, or updates it if one with the same ID already exists.

• Action
  Get Export Results

  Returns one page of records (contacts, clicks or orders) for a result ID from any Request ... Export or Lookup operation, and whether more pages remain.

• Action
  Get Last Updated Date

  Returns the date your Wicked Reports reports are up to.

• Action
  List Saved Views

  Returns the report views saved in your Wicked Reports dashboard, with their IDs and names.

• Action
  Request Clicks Export

  Starts an export of clicks tied to contacts in a date range and returns a result ID; pass it to Get Export Results to read the clicks.

• Action
  Request Contact Clicks Export

  Starts an export of one contact's raw clicks and returns a result ID; pass it to Get Export Results to read the clicks.

• Action
  Request Contact Lookup

  Starts a lookup of one contact by Wicked Reports ID, your source-system ID or email, and returns a result ID; pass it to Get Export Results to read the contact.

• Action
  Request Contact Orders Export

  Starts an export of one contact's orders in a date range and returns a result ID; pass it to Get Export Results to read the orders.

• Action
  Request Contacts Export

  Starts an export of all contacts created in a date range and returns a result ID; pass it to Get Export Results to read the contacts.

• Action
  Request Orders Export

  Starts an export of orders (with attribution, products and payments) in a date range and returns a result ID; pass it to Get Export Results to read the orders.

• Action
  Track a Click

  Sends a click or conversion event you tracked yourself (lead, meeting, webinar, last click on an order, etc.) into Wicked Reports.

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