Connect Amazon Redshift and Casting42

Both apps 28Amazon Redshift 7Casting42 21

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

  Triggers when a casting has been created in your Casting42 Database.

• Trigger
  New Contact

  Triggers when a contact has been added to your Casting42 database.

• Trigger
  New Talent

  Triggers when a new talent is added in Casting42. Casting42 only shares talents whose "Allow API response" setting is turned on, so talents without it never trigger this.

• Trigger
  Updated Casting

  Triggers when the data of a casting has been updated.

• Trigger
  Updated Contact

  Triggers when the data of a contact has been updated in your Casting42 database.

• Trigger
  Updated Talent

  Triggers when a talent is updated in Casting42. Casting42 only shares talents whose "Allow API response" setting is turned on, so talents without it never trigger this.

• Action
  Add File to Talent

  Uploads a file such as a resume or PDF document to a talent's profile.

• Action
  Add Mediafile to Talent

  Uploads a video or audio media file to a talent's profile in Casting42.

• Action
  Add Talent to Group

  Adds one or more talents to an existing Casting42 group.

• Action
  Create Casting

  Creates a new casting project in Casting42 and returns it along with its talent sign-up link.

• Action
  Create Contact

  Creates a new contact in Casting42 with name, email, company, phone, language and address.

• Action
  Create Group

  Creates a new group in Casting42 for organizing talents.

• Action
  Create or Update Candidate

  Adds a talent to a casting as a candidate, or updates the candidate's tags if the talent is already in that casting.

• Action
  Create Talent

  Creates a new talent profile in your Casting42 database and returns the created talent.

• Action
  Find Casting

  Finds a casting by its tag and returns the full casting record.

• Action
  Get Contact

  Returns a single Casting42 contact identified by its tag.

• Action
  Get Group

  Returns a Casting42 group and its talents by the group's tag.

• Action
  Get Talent

  Returns a single talent record, including custom fields and skills, by its tag.

• Action
  Update Casting

  Updates an existing casting in Casting42, such as its name, description, dates, locations and sharing options. Fields left blank are not changed.

• Action
  Update Contact

  Updates an existing contact in Casting42. Only the fields you fill in are changed.

• Action
  Update Talent

  Updates an existing talent in Casting42, identified by its tag. Fields left blank keep their current values.

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