Connect Google BigQuery to Plentymarkets

Both apps 34Google BigQuery 14Plentymarkets 20

• Trigger
  New Job Completed

  Triggers when a BigQuery job in the project finishes, whether it succeeded or failed.

• Trigger
  New Row

  Triggers when a new row is added to a table. New rows are detected by a column you name that increases for newer rows, such as a creation time or a sequential ID.

• Trigger
  Query Job Completed (With Row Data)

  Triggers when a SELECT query job in the project finishes successfully, and includes its result rows.

• Trigger
  Updated Row

  Triggers when a row in a table is added or changed, detected by a last-updated timestamp column you name.

• Action
  Create Row

  Creates a new row of data in a table. Note: Does not create a job.

• Action
  Create Rows

  Creates new rows of data in a table (accepts line items). Note: Does not create a job.

• Action
  Delete Rows

  Deletes every row in a table whose match column equals the value you give.

• Action
  Find One Row

  Finds the first row in a table whose column equals the value you give.

• Action
  Get Rows for Job Completed

  Returns the result rows of a finished query job.

• Action
  Import Data

  Imports a JSON, CSV, Avro or Parquet file from Cloud Storage into a table. Waits up to about 40 seconds for the import to finish; larger imports keep running in BigQuery and return state RUNNING.

• Action
  List Datasets

  Returns the datasets in a Google Cloud project.

• Action
  List Tables

  Returns the tables in a BigQuery dataset.

• Action
  Run a Query

  Runs a SQL query against a table in BigQuery.

• Action
  Update Row(s)

  Updates every row in a table whose match column equals the value you give, setting the columns you choose.

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