invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

Products: ActiveCampaign Products

insert REST

  • Catalogue : ActiveCampaign
  • Schéma : CustomObjects
  • Clés primaires : id
  • Label: Products

Permet de récupérer et de modifier des données à l'aide de insert.

Résumé

Products imported into ActiveCampaign

Source de l'API

  • Point de terminaison : /customObjects/records/1fadeeeb-0a94-4499-a01a-83ffe9111f47

Caractéristiques de performance

Characteristic Value
Latence moyenne d'accès (ms) 264
Nombre de lignes par minute en mode de balayage complet 13,400

Le résultat peut être mis en cache côté client.

Colonnes de table

Les colonnes de la table Products sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

Name Type de données Label Required Marks Documentation
attributes varchar2 Attributes filters on the platform, writable, fields[?(@.id=='attributes')].value Attributes
average_rating varchar2 Note moyenne filters on the platform, writable, fields[?(@.id=='average-rating')].value DEPRECATED!
average_ratings decimal Notes moyennes filters on the platform, writable, fields[?(@.id=='average-ratings')].value Note moyenne
base_product_description varchar2 Description du produit de base filters on the platform, writable, fields[?(@.id=='base-product-description')].value FIELD_BASE_PRODUCT_DESCRIPTION
base_product_dimensions varchar2 Dimensions du produit de base filters on the platform, writable, fields[?(@.id=='base-product-dimensions')].value Base product dimensions
base_product_images varchar2 Images du produit de base filters on the platform, writable, fields[?(@.id=='base-product-images')].value Base product images
base_product_name varchar2 Nom du produit de base filters on the platform, writable, fields[?(@.id=='base-product-name')].value Nom du produit de base
base_product_store_created_date datetime Date de création de la fiche produit de base 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 Date de modification du produit de base en magasin filters on the platform, writable, fields[?(@.id=='base-product-store-modified-date')].value Modified date for base product in store
base_product_url varchar2 URL du produit de base filters on the platform, writable, fields[?(@.id=='base-product-url')].value Base product URL
base_product_url_slug varchar2 URL de base du produit (slug) filters on the platform, writable, fields[?(@.id=='base-product-url-slug')].value Base product URL slugs
base_product_weight decimal Poids du produit de base 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 Identifiant de connexion filters on the platform, writable, fields[?(@.id=='connection-id')].value Identifiant de connexion
createdTimestamp datetime Created filters on the platform, writable, computed Moment of creation.
dimensions_unit varchar2 Unité de mesure des dimensions 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 Quantité en stock filters on the platform, writable, fields[?(@.id=='inventory-quantity')].value Quantité en stock
is_backorders_allowed varchar2 Les commandes en attente sont-elles autorisées ? filters on the platform, writable, fields[?(@.id=='is-backorders-allowed')].value Are backorders allowed
is_deleted varchar2 Est Supprimé filters on the platform, writable, fields[?(@.id=='is-deleted')].value Is deleted
is_downloadable varchar2 Disponible en téléchargement filters on the platform, writable, fields[?(@.id=='is-downloadable')].value Is downloadable
is_on_sale varchar2 En promotion filters on the platform, writable, fields[?(@.id=='is-on-sale')].value Is on sale
is_virtual varchar2 Est-ce virtuel ? filters on the platform, writable, fields[?(@.id=='is-virtual')].value Is virtual
is_visible varchar2 Est visible filters on the platform, writable, fields[?(@.id=='is-visible')].value Is visible
legacy_connection_id int64 Identifiant de connexion hérité filters on the platform, writable, fields[?(@.id=='legacy-connection-id')].value Identifiant de connexion hérité
number_of_sales int64 Nombre de ventes filters on the platform, writable, fields[?(@.id=='number-of-sales')].value Number of sales
rating_count int64 Nombre d'évaluations filters on the platform, writable, fields[?(@.id=='rating-count')].value Nombre d'évaluations
schemaId varchar2 Identifiant du schéma filters on the platform, writable, computed Unique ID of the custom object the record belongs to.
search_keywords varchar2 Rechercher des mots-clés 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 État des stocks filters on the platform, writable, fields[?(@.id=='stock-status')].value Stock status
store_base_product_id varchar2 Référence du produit de base en magasin filters on the platform, writable, fields[?(@.id=='store-base-product-id')].value Store Parent ID
store_primary_id varchar2 Enregistrer l'identifiant principal filters on the platform, writable, fields[?(@.id=='store-primary-id')].value Store variant ID
store_variant_id varchar2 Identifiant de la variante du magasin 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 Dernière modification filters on the platform, writable, computed Moment of last change.
variant_description varchar2 Description de la variante filters on the platform, writable, fields[?(@.id=='variant-description')].value Variant description
variant_dimensions varchar2 Dimensions des variantes filters on the platform, writable, fields[?(@.id=='variant-dimensions')].value Variant Dimension
variant_images varchar2 Images des variantes filters on the platform, writable, fields[?(@.id=='variant-images')].value Variant Image
variant_name varchar2 Nom de la variante filters on the platform, writable, fields[?(@.id=='variant-name')].value Variant name
variant_price decimal Prix de la variante filters on the platform, writable, fields[?(@.id=='variant-price')].value Variant price
variant_price_amount varchar2 Variante Prix Montant filters on the platform, writable, fields[?(@.id=='variant-price-amount')].value Variant price amount (deprecated field)
variant_price_amounts varchar2 Montants des prix des variantes filters on the platform, writable, fields[?(@.id=='variant-price-amounts')].value Variant price (Deprecated Field)
variant_price_currency varchar2 Variante Prix Devise filters on the platform, writable, fields[?(@.id=='variant-price-currency')].value Variant price currency
variant_price_currency_code varchar2 Variante Prix Devise Code filters on the platform, writable, fields[?(@.id=='variant-price')].currency Currency of the amount in column variant_price.
variant_sku varchar2 SKU de variante filters on the platform, writable, fields[?(@.id=='variant-sku')].value Variant sku
variant_store_created_date datetime Date de création du magasin de variantes filters on the platform, writable, fields[?(@.id=='variant-store-created-date')].value Variant store created date
variant_store_modified_date datetime Date de modification de la variante en magasin filters on the platform, writable, fields[?(@.id=='variant-store-modified-date')].value Variant store modified date
variant_url varchar2 URL alternative filters on the platform, writable, fields[?(@.id=='variant-url')].value URL alternative
variant_url_slug varchar2 URL alternative (slug) filters on the platform, writable, fields[?(@.id=='variant-url-slug')].value Variant URL slug
variant_weight decimal Poids de la variante filters on the platform, writable, fields[?(@.id=='variant-weight')].value Variant weight
view_count int64 Nombre de vues filters on the platform, writable, fields[?(@.id=='view-count')].value View count

Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :

Modifications apportées à cette table, 26.0 à 27.0

La table ActiveCampaign.CustomObjects.Products est ajoutée

La table comporte 56 colonnes et permet les opérations de sélection et d'insertion.

  • importance 3

Toutes les modifications apportées au chauffeur, 26.0 à 27.0