Connect Amazon Redshift to Kiflo PRM

Both apps 29Amazon Redshift 7Kiflo PRM 22

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

• Action
  Accept Deal

  Accepts a deal in Kiflo and sets its status to Accepted, optionally adding a note.

• Action
  Accept Lead

  Accepts a lead in Kiflo and sets its status to Accepted, optionally adding a note.

• Action
  Associate Customer to Deal

  Links a customer to an existing deal — either an existing customer by ID, or a new customer created from the details you supply.

• Action
  Convert Lead to Customer

  Converts a lead into a customer and marks the lead as Converted, returning the updated lead.

• Action
  Convert Lead to Deal

  Converts a lead into a deal and sets the lead's status to Converted. Returns the updated lead, including the id of the new deal.

• Action
  Create Attachment

  Downloads a file from a URL and attaches it to a Kiflo partner, deal, lead, note, payout, customer or collaboration.

• Action
  Create Channel Conflict

  Records a channel conflict detected in an external source, such as your CRM, and makes it visible in Kiflo. Returns the created channel conflict.

• Action
  Create Customer

  Creates a new customer in Kiflo, with your customer properties, and optionally associates it with a partner.

• Action
  Create Deal

  Creates a new deal in Kiflo, optionally linking a contact, partners and custom deal properties.

• Action
  Create Lead

  Creates a lead in Kiflo, optionally assigning it to a partner or recording the partner who sourced it.

• Action
  Create Note

  Creates a note on an existing partner, lead, deal, customer or payout in Kiflo.

• Action
  Create Partner

  Creates a new partner in Kiflo, optionally with its main contact, group, program level, onboarding stage and payout details.

• Action
  Create Transaction

  Creates a transaction in Kiflo for an existing customer, optionally linked to a partner and a deal, and returns the new transaction.

• Action
  Find a Certification

  Returns the certifications defined in your Kiflo account whose name contains the text you specify.

• Action
  Find a Contact

  Returns the contacts whose chosen property exactly matches the value you specify.

• Action
  Find a Partner Application

  Returns the partner applications that match a partner name, team member email, status or partner.

• Action
  Find a Partner Team Member

  Returns the partner team members that match an email address, a partner, or both.

• Action
  Pay Payout

  Marks a validated payout as paid in Kiflo and returns the updated payout. This records the payment and does not move any money.

• Action
  Refuse Deal

  Refuses a deal in Kiflo and sets its status to Refused, optionally adding a note. Returns the refused deal.

• Action
  Refuse Lead

  Refuses a lead in Kiflo and sets its status to Refused, optionally adding a note. Returns the updated lead.

• Action
  Reject a Partner Application

  Rejects a partner application that is still pending, so the applicant does not become a partner. Returns the rejected application.

• Action
  Update Lead

  Updates an existing lead's deadline, currency, assigned partner contact, owner and properties, and returns the updated lead.

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