invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

Products: ActiveCampaign Products

Esta página aún no está disponible en tu idioma; se muestra la versión original.

insert REST

  • Catalog: ActiveCampaign
  • Schema: CustomObjects
  • Primary Keys: id
  • Label: Products

Can retrieve data and change data using insert.

Summary

Products imported into ActiveCampaign

API Source

  • Endpoint: /customObjects/records/1fadeeeb-0a94-4499-a01a-83ffe9111f47

Performance Characteristics

Characteristic Value
Average access latency (ms) 264
Full scan rows per minute 13,400

The result can be cached on the client.

Table Columns

The columns of the table Products are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
attributes varchar2 Attributes filters on the platform, writable, fields[?(@.id=='attributes')].value Attributes
average_rating varchar2 Average Rating filters on the platform, writable, fields[?(@.id=='average-rating')].value DEPRECATED!
average_ratings decimal Average Ratings filters on the platform, writable, fields[?(@.id=='average-ratings')].value Average Rating
base_product_description varchar2 Base Product Description filters on the platform, writable, fields[?(@.id=='base-product-description')].value FIELD_BASE_PRODUCT_DESCRIPTION
base_product_dimensions varchar2 Base Product Dimensions filters on the platform, writable, fields[?(@.id=='base-product-dimensions')].value Base product dimensions
base_product_images varchar2 Base Product Images filters on the platform, writable, fields[?(@.id=='base-product-images')].value Base product images
base_product_name varchar2 Base Product Name filters on the platform, writable, fields[?(@.id=='base-product-name')].value Base Product Name
base_product_store_created_date datetime Base Product Store Created Date filters on the platform, writable, fields[?(@.id=='base-product-store-created-date')].value Created date for base product in store
base_product_store_modified_date datetime Base Product Store Modified Date filters on the platform, writable, fields[?(@.id=='base-product-store-modified-date')].value Modified date for base product in store
base_product_url varchar2 Base Product URL filters on the platform, writable, fields[?(@.id=='base-product-url')].value Base product URL
base_product_url_slug varchar2 Base Product URL Slug filters on the platform, writable, fields[?(@.id=='base-product-url-slug')].value Base product URL slugs
base_product_weight decimal Base Product Weight filters on the platform, writable, fields[?(@.id=='base-product-weight')].value Base product weight
brand varchar2 Brand filters on the platform, writable, fields[?(@.id=='brand')].value Brand
categories varchar2 Categories filters on the platform, writable, fields[?(@.id=='categories')].value Categories
condition varchar2 Condition filters on the platform, writable, fields[?(@.id=='condition')].value Condition
connection_id varchar2 Connection ID filters on the platform, writable, fields[?(@.id=='connection-id')].value Connection ID
createdTimestamp datetime Created filters on the platform, writable, computed Moment of creation.
dimensions_unit varchar2 Dimensions Unit filters on the platform, writable, fields[?(@.id=='dimensions-unit')].value Unit for dimensions
id varchar2 ID filters on the platform, writable, computed Unique ID of the record, in the form of a GUID.
inventory_quantity int64 Inventory Quantity filters on the platform, writable, fields[?(@.id=='inventory-quantity')].value Inventory Quantity
is_backorders_allowed varchar2 Is Backorders Allowed filters on the platform, writable, fields[?(@.id=='is-backorders-allowed')].value Are backorders allowed
is_deleted varchar2 Is Deleted filters on the platform, writable, fields[?(@.id=='is-deleted')].value Is deleted
is_downloadable varchar2 Is Downloadable filters on the platform, writable, fields[?(@.id=='is-downloadable')].value Is downloadable
is_on_sale varchar2 Is on Sale filters on the platform, writable, fields[?(@.id=='is-on-sale')].value Is on sale
is_virtual varchar2 Is Virtual filters on the platform, writable, fields[?(@.id=='is-virtual')].value Is virtual
is_visible varchar2 Is Visible filters on the platform, writable, fields[?(@.id=='is-visible')].value Is visible
legacy_connection_id int64 Legacy Connection ID filters on the platform, writable, fields[?(@.id=='legacy-connection-id')].value Legacy Connection ID
number_of_sales int64 Number of Sales filters on the platform, writable, fields[?(@.id=='number-of-sales')].value Number of sales
rating_count int64 Rating Count filters on the platform, writable, fields[?(@.id=='rating-count')].value Rating Count
schemaId varchar2 Schema ID filters on the platform, writable, computed Unique ID of the custom object the record belongs to.
search_keywords varchar2 Search Keywords filters on the platform, writable, fields[?(@.id=='search-keywords')].value Search keywords
status varchar2 Status filters on the platform, writable, fields[?(@.id=='status')].value Status
stock_status varchar2 Stock Status filters on the platform, writable, fields[?(@.id=='stock-status')].value Stock status
store_base_product_id varchar2 Store Base Product ID filters on the platform, writable, fields[?(@.id=='store-base-product-id')].value Store Parent ID
store_primary_id varchar2 Store Primary ID filters on the platform, writable, fields[?(@.id=='store-primary-id')].value Store variant ID
store_variant_id varchar2 Store Variant ID filters on the platform, writable, fields[?(@.id=='store-variant-id')].value Deprecated
tags varchar2 Tags filters on the platform, writable, fields[?(@.id=='tags')].value Tags
type varchar2 Type filters on the platform, writable, fields[?(@.id=='type')].value Type
upc varchar2 UPC filters on the platform, writable, fields[?(@.id=='upc')].value UPC
updatedTimestamp datetime Last Modified filters on the platform, writable, computed Moment of last change.
variant_description varchar2 Variant Description filters on the platform, writable, fields[?(@.id=='variant-description')].value Variant description
variant_dimensions varchar2 Variant Dimensions filters on the platform, writable, fields[?(@.id=='variant-dimensions')].value Variant Dimension
variant_images varchar2 Variant Images filters on the platform, writable, fields[?(@.id=='variant-images')].value Variant Image
variant_name varchar2 Variant Name filters on the platform, writable, fields[?(@.id=='variant-name')].value Variant name
variant_price decimal Variant Price filters on the platform, writable, fields[?(@.id=='variant-price')].value Variant price
variant_price_amount varchar2 Variant Price Amount filters on the platform, writable, fields[?(@.id=='variant-price-amount')].value Variant price amount (deprecated field)
variant_price_amounts varchar2 Variant Price Amounts filters on the platform, writable, fields[?(@.id=='variant-price-amounts')].value Variant price (Deprecated Field)
variant_price_currency varchar2 Variant Price Currency filters on the platform, writable, fields[?(@.id=='variant-price-currency')].value Variant price currency
variant_price_currency_code varchar2 Variant Price Currency Code filters on the platform, writable, fields[?(@.id=='variant-price')].currency Currency of the amount in column variant_price.
variant_sku varchar2 Variant SKU filters on the platform, writable, fields[?(@.id=='variant-sku')].value Variant sku
variant_store_created_date datetime Variant Store Created Date filters on the platform, writable, fields[?(@.id=='variant-store-created-date')].value Variant store created date
variant_store_modified_date datetime Variant Store Modified Date filters on the platform, writable, fields[?(@.id=='variant-store-modified-date')].value Variant store modified date
variant_url varchar2 Variant URL filters on the platform, writable, fields[?(@.id=='variant-url')].value Variant URL
variant_url_slug varchar2 Variant URL Slug filters on the platform, writable, fields[?(@.id=='variant-url-slug')].value Variant URL slug
variant_weight decimal Variant Weight filters on the platform, writable, fields[?(@.id=='variant-weight')].value Variant weight
view_count int64 View Count filters on the platform, writable, fields[?(@.id=='view-count')].value View count

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador:

Modificaciones de esta tabla, De 26.0 a 27.0

Se ha añadido la tabla ActiveCampaign.CustomObjects.Products

La tabla tiene 56 columnas y admite las operaciones «select» e «insert».

  • importancia 3

Todos los cambios del conductor, De 26.0 a 27.0