Connect Amazon Redshift to Plentymarkets

Both apps 27Amazon Redshift 7Plentymarkets 20

• 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
  Add contact

  Creates a new contact (customer, supplier or other contact type) in Plentymarkets.

• Action
  Add item

  Creates a new item in Plentymarkets, together with its main variation.

• Action
  Add order

  Creates an order in Plentymarkets with its order items, addresses and properties.

• Action
  Add payment

  Creates a payment in Plentymarkets with the given amount, currency, payment method and status.

• Action
  Add variation

  Creates a new variation on an existing item, with its number, name, prices, dimensions, stock settings and linked categories, units and attributes.

• Action
  Find items by criteria

  Finds items matching criteria such as name, ID, manufacturer, flags or update date.

• Action
  Find orders by criteria

  Searches orders matching the criteria you supply, such as order ID, status, contact data, item or document number, and returns the matching orders.

• Action
  Get contact

  Returns a single contact by its ID, optionally including its addresses and accounts.

• Action
  Get item

  Returns a single item by its ID, including its type, stock type, manufacturer, flags and marketplace settings.

• Action
  Get order

  Returns a single order by its ID, optionally with addresses, payments, comments and other related details.

• Action
  Get variation

  Returns one variation of an item, optionally with related data such as prices, barcodes, stock or properties.

• Action
  List categories

  Returns the categories in your Plentymarkets system, optionally filtered by type, parent, name, store or tag.

• Action
  List contacts

  Returns a page of contacts from your Plentymarkets system, optionally filtered by name, email, dates, type and more.

• Action
  List payments

  Returns the payments recorded in your plentymarkets system, with amount, currency, status and payment method.

• Action
  List stock

  Returns stock levels per variation and warehouse across all warehouses, optionally filtered by variation or last-updated date.

• Action
  List warehouses

  Returns the warehouses set up in your Plentymarkets system, optionally sorted by id, name or priority.

• Action
  Update contact

  Updates an existing contact in Plentymarkets, such as name, email, title or contact options.

• Action
  Update item

  Updates an existing item's settings, such as its stock type, manufacturer, condition, flags, and marketplace categories.

• Action
  Update order

  Updates an existing order, such as its status, owner, items, properties, addresses or relations.

• Action
  Update variation

  Updates an existing variation of an item, such as its number, name, prices, dimensions, stock settings and linked categories, markets or warehouses.

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