Connect Castos and Oracle Database

Both apps 33Castos 21Oracle Database 12

• Trigger
  New Episode

  Triggers when a new episode is added to a Castos podcast.

• Trigger
  New Podcast

  Triggers when a new podcast is created in your Castos account.

• Trigger
  New Private Subscriber

  Triggers when a new private subscriber is added to a Castos private podcast.

• Action
  Create Episode

  Creates an episode on a Castos podcast, uploading its audio from a URL.

• Action
  Create Podcast

  Creates a podcast in Castos and returns its ID.

• Action
  Create Private Subscriber

  Adds a private subscriber to a Castos private podcast, giving them their own private feed.

• Action
  Delete Episode

  Deletes an episode from a Castos podcast.

• Action
  Delete Podcast

  Deletes a Castos podcast.

• Action
  Delete Private Subscription

  Deletes a private subscriber's subscription record from a Castos private podcast.

• Action
  Find Private Subscriber by Email

  Finds a Castos private subscriber by email and returns their subscriptions to your private podcasts.

• Action
  Get Episode

  Returns one episode of a Castos podcast, with its title, show notes, publish date and audio file.

• Action
  Get Podcast

  Returns one Castos podcast by its ID, including its title, description, RSS URL and author.

• Action
  Get Private Subscriber

  Returns a Castos private subscriber by ID, with their subscriptions to your private podcasts.

• Action
  List Episodes

  Returns the episodes of one Castos podcast.

• Action
  List Podcast Categories

  Returns the podcast category names Castos accepts, such as "Business: Marketing".

• Action
  List Podcasts

  Returns every podcast in the Castos account with its ID, title, type and whether its feed is protected.

• Action
  List Private Subscribers

  Returns the private subscribers of a Castos private podcast, with each one's email, feed URL and status.

• Action
  Reactivate Private Subscriber

  Reactivates a canceled private subscriber's access to a Castos private podcast, by their email.

• Action
  Revoke Private Subscriber

  Cancels a private subscriber's subscription to a Castos private podcast, cutting off their private feed.

• Action
  Update Episode

  Updates a Castos episode's details; only the fields you supply change.

• Action
  Update Podcast

  Updates a Castos podcast's details; only the fields you supply change.

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

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