Connect Amazon Redshift and inMobile - SMS gateway

Both apps 26Amazon Redshift 7inMobile - SMS gateway 19

• Trigger
  New Row

  Triggers when a new row is added to an Amazon Redshift table.

• Trigger
  Updated Row

  Triggers when a row in an Amazon Redshift table is added or changed, based on its updated-time column.

• Action
  Create Rows

  Adds a row to an Amazon Redshift table.

• Action
  Delete Rows

  Deletes the rows in an Amazon Redshift table that match a condition.

• Action
  Find Rows

  Finds rows in an Amazon Redshift table that match a condition.

• Action
  Query Database

  Runs one SQL statement on your Amazon Redshift database and returns any rows it produces.

• Action
  Update Rows

  Updates the rows in an Amazon Redshift table that match a condition.

• Trigger
  New email event

  Triggers when a new email event occurs on a message you sent, such as delivered, opened, clicked, bounced or unsubscribed.

• Trigger
  New incoming RCS message

  Triggers when a new RCS message is received by one of your inMobile RCS agents, including text, file, location and suggestion responses.

• Trigger
  New incoming SMS message

  Triggers when a new SMS message is received on one of your inMobile numbers.

• Trigger
  New SMS status report

  Triggers when a delivery status report arrives for a sent SMS message. inMobile hands out each report only once, so a report collected by this trigger can't be retrieved again through the API.

• Action
  Add list

  Creates a new recipient list in your inMobile account and returns its id, name and creation time.

• Action
  Add Mobile Number to Blacklist

  Adds a mobile number to the inMobile blacklist so it no longer receives messages, and returns the created blacklist entry.

• Action
  Add recipient

  Creates a recipient with a phone number and optional contact details on an inMobile SMS list, and returns the new recipient.

• Action
  Cancel SMS message

  Cancels scheduled SMS messages that have not been sent yet and returns a result for each message.

• Action
  Create or Update Contact

  Creates a recipient on an inMobile list, or updates the existing recipient on that list with the same phone number.

• Action
  Delete Contact

  Deletes a contact (recipient) from an inMobile list.

• Action
  Find recipient by number

  Returns the recipient on an inMobile list that has the specified phone number, and reports whether one was found.

• Action
  List lists

  Returns all recipient lists in the inMobile account, with each list's id, name and creation time.

• Action
  List recipients

  Returns all recipients in an inMobile list, including their phone numbers and fields.

• Action
  Parse phone numbers

  Checks a list of phone numbers and returns, for each one, whether it is valid along with its cleaned number, country code and local number.

• Action
  Remove Mobile Number From Blacklist

  Removes a mobile number from your inMobile blacklist, so it can receive messages again.

• Action
  Send email

  Sends an email with a subject and HTML body to up to 100 recipients through inMobile, optionally scheduled for later, and returns the message id and accepted recipients.

• Action
  Send RCS text message

  Sends a text-only RCS message from one of your RCS agents to a mobile number, with optional suggested replies and actions. Returns the message id and the parsed recipient number.

• Action
  Send SMS Message

  Sends one SMS text message to a mobile number, immediately or at a scheduled time, and returns the message ID and how many SMS parts it uses.

• Action
  Update recipient

  Updates an existing recipient on an inMobile list. Only the details you fill in are changed; anything left blank keeps its current value.

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