Do everything in one place

Customize your Data247.Com and MySQL integration with the following triggers and actions.

Triggers

When this happens…

MySQL
  • New row
    New row in a table in MySQL
  • New rows Batch
    New batch of rows in a table in MySQL
  • Scheduled query Batch
    New/updated batch of rows via scheduled custom SQL in MySQL
  • New/updated row
    New/updated row in a table in MySQL
  • New/updated rows Batch
    New/updated batch of rows in a table in MySQL
  • Any other trigger you can think up

Actions

Do this…

Data247.Com
  • Append247 (Email)
    Append247 (Email) appends email addresses for your contacts. You supply names and addresses or their phone numbers, and api will return their email addresses.
  • Append247 (Gender)
    Append247 (Gender) returns the probable gender associated with a name.
  • Append247 (Name)
    Append247 (Name) takes phone as input and returns name of person behind it.
  • Append247 (Phone)
    Append247 (Phone) appends phone number for your contacts. You supply names and addresses of your contacts, and api will return their phone.
  • Append247 (Profile Data)
    Our Append247 (Profile Data) service gives you additional information about the people on your lead list, including Financial, Interests, and/or Household data.
  • Append247 (Reverse Email)
    Append247 (Reverse Phone) finds the name and address associated with a phone number.
  • Append247 (Reverse Phone)
    Append247 (Reverse Phone) finds the name and address associated with a phone number.
  • Append247 (Reverse Zipcode)
    Append247 (Reverse Zipcode) takes a 5 or 9 digit zipcode, and returns the formatted address components(address, city, state etc) of that location.
  • Append247 (Zipcode)
    Append247 (Zipcode) appends 9-digit zipcodes for your contacts. You supply the addresses, and the api will return their zip code and other information.
  • Carrier247 (International)
    Carrier247 (International)returns carrier information for international phone numbers, including whether they are wireless or landline numbers.You must provide country code in your phone number.
  • Text@
    Text@ retrieves the Carrier name, iswireless, email-to-SMS, and email-to-MMS gateway addresses for your wireless phone numbers.
  • Carrier247 (Carrier Type)
    Carrier247 (Carrier Type) is similar to Carrier247 (USA), but only returns a subset of the data (just the carrier type), and it works for Canadian phone numbers as well as USA without the requirement that the user subscribe to the CLNPC to get port corrected results.
  • Do-Not-Call (USA)
    DNC Check returns whether a phone number exists in your internal dnc list OR in Federal Do-Not-Call list.
  • Locate247 (IP)
    Locate247 (IP) returns the geolocation data for IP addresses.
  • Trust247 (Phone Number)
    Trust247 (Phone Number) takes phone number as input and returns whether it's on a list of SPAM callers.
  • Carrier247 (USA)
    Carrier247 (USA) returns Carrier name, iswireless, email-to-SMS, and email-to-MMS gateway addresses for provided domestic US phone numbers.
  • Verify247 (Postal Address)
    Verify247 (Postal Address) verifies provided USA postal addresses and parses out to different address components.
  • Verify247 (Email)
    Verify247 (Email) will verify that each of your email address is properly formatted and there is a working mailbox associated with it.
  • Verify247 (Phone Number)
    Verify247 (Phone Number) will verify that each of the provided phone is active or not.
  • Any other action you can think up

MySQL
  • Delete rows Batch
    Delete rows in a table in MySQL
  • Execute stored procedure Batch
    Execute stored procedure in MySQL
  • Export query result
    Export query result as a CSV file in MySQL
  • Insert row
    Insert row in a table in MySQL
  • Insert rows Batch
    Insert batch of rows in a table in MySQL
  • Run custom SQL Batch
    Run custom SQL in MySQL
  • Select rows Batch
    Select rows in a table in MySQL
  • Get table schema
    Get table schema for MySQL
  • Update rows
    Update rows in a table in MySQL
  • Upsert rows Batch
    Upsert batch of rows in a table in MySQL
  • Upsert row
    Upsert row in a table in MySQL
  • Any other action you can think up

The wonders of Workato

Easily set up as many intelligent automations you need.
  • 1000s of ready-to-use templates
  • Accelerate work with intelligent automation
  • Do it yourself, faster
  • Build bots. Put them to work

Market leaders run on Workato

  • mgm
  • adobe
  • att
  • atlassian
  • slack

Let’s start automating

Schedule a Demo