Connect Oracle Database and Print.one Postcards

Both apps 29Oracle Database 12Print.one Postcards 17

• Trigger
  New Column

  Fires when a new column appears on an Oracle table you choose.

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

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected Oracle user's own schema.

• Action
  Add Row

  Add one row to a table on the connected Oracle database.

• Action
  Delete Row

  Delete the rows in a table whose chosen column equals a value.

• Action
  Find Row

  Find the first row in a table whose chosen column matches a value.

• Action
  Find Rows via Custom Query

  Runs a SELECT statement you write against the connected Oracle database and returns every row it matches.

• Action
  Find Row via Custom Query

  Runs a SELECT statement you write against the connected Oracle database and returns the first row it matches.

• Action
  Run Custom Statement

  Runs a statement you write against the connected Oracle database that changes data rather than returning rows, and reports how many rows it changed.

• Action
  Update Row

  Change column values on every row of a table whose chosen column matches a value.

• Trigger
  New Campaign

  Triggers when a new campaign is created in Print.one.

• Trigger
  New Campaign Item

  Triggers when a new postcard is added to a Print.one campaign.

• Action
  Cancel Campaign Item

  Cancels a postcard in a Print.one campaign before it is printed.

• Action
  Create Campaign Item

  Creates a postcard for a recipient in a Print.one campaign; set draft to hold it before sending.

• Action
  Delete coupon

  Deletes a coupon from your Print.one account.

• Action
  Get Campaign

  Returns one Print.one campaign.

• Action
  Get Campaign Item

  Returns one postcard in a Print.one campaign, with its status.

• Action
  List campaign items

  Returns the items (postcards) in a campaign, optionally filtered by status, format, dates and more.

• Action
  List Campaigns

  Returns the Print.one campaigns in the account.

• Action
  List Coupons

  Returns the coupon lists in the Print.one account.

• Action
  List mailings

  Returns the mailings of a Print.one campaign, optionally filtered by status, destination or creation date.

• Action
  Pause campaign

  Pauses a campaign so it stops sending out items; new orders are still accepted and held until the campaign is resumed.

• Action
  Resume campaign

  Resumes a paused campaign so it starts sending out postcards again, and returns the updated campaign.

• Action
  Send Campaign Item

  Sends a draft postcard in a Print.one campaign.

• Action
  Update campaign

  Updates a campaign's name, description, default return address, Postfilter category or billing ID.

• Action
  Update campaign item

  Updates the recipient address or personalization values of a campaign item (postcard) that has not yet been sent.

• Action
  Validate Address

  Checks a postal address with Print.one and returns the validation result.

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