Products: ActiveCampaign Products
Questa pagina non è ancora disponibile nella tua lingua; viene visualizzata la versione originale.
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[? |
Attributes | |
average_ |
varchar2 |
Average Rating | filters on the platform, writable, fields[? |
DEPRECATED! | |
average_ |
decimal |
Average Ratings | filters on the platform, writable, fields[? |
Average Rating | |
base_ |
varchar2 |
Base Product Description | filters on the platform, writable, fields[? |
FIELD_BASE_PRODUCT_DESCRIPTION | |
base_ |
varchar2 |
Base Product Dimensions | filters on the platform, writable, fields[? |
Base product dimensions | |
base_ |
varchar2 |
Base Product Images | filters on the platform, writable, fields[? |
Base product images | |
base_ |
varchar2 |
Base Product Name | filters on the platform, writable, fields[? |
Base Product Name | |
base_ |
datetime |
Base Product Store Created Date | filters on the platform, writable, fields[? |
Created date for base product in store | |
base_ |
datetime |
Base Product Store Modified Date | filters on the platform, writable, fields[? |
Modified date for base product in store | |
base_ |
varchar2 |
Base Product URL | filters on the platform, writable, fields[? |
Base product URL | |
base_ |
varchar2 |
Base Product URL Slug | filters on the platform, writable, fields[? |
Base product URL slugs | |
base_ |
decimal |
Base Product Weight | filters on the platform, writable, fields[? |
Base product weight | |
brand |
varchar2 |
Brand | filters on the platform, writable, fields[? |
Brand | |
categories |
varchar2 |
Categories | filters on the platform, writable, fields[? |
Categories | |
condition |
varchar2 |
Condition | filters on the platform, writable, fields[? |
Condition | |
connection_ |
varchar2 |
Connection ID | filters on the platform, writable, fields[? |
Connection ID | |
created |
datetime |
Created | filters on the platform, writable, computed | Moment of creation. | |
dimensions_ |
varchar2 |
Dimensions Unit | filters on the platform, writable, fields[? |
Unit for dimensions | |
id |
varchar2 |
ID | filters on the platform, writable, computed | Unique ID of the record, in the form of a GUID. | |
inventory_ |
int64 |
Inventory Quantity | filters on the platform, writable, fields[? |
Inventory Quantity | |
is_ |
varchar2 |
Is Backorders Allowed | filters on the platform, writable, fields[? |
Are backorders allowed | |
is_ |
varchar2 |
Is Deleted | filters on the platform, writable, fields[? |
Is deleted | |
is_ |
varchar2 |
Is Downloadable | filters on the platform, writable, fields[? |
Is downloadable | |
is_ |
varchar2 |
Is on Sale | filters on the platform, writable, fields[? |
Is on sale | |
is_ |
varchar2 |
Is Virtual | filters on the platform, writable, fields[? |
Is virtual | |
is_ |
varchar2 |
Is Visible | filters on the platform, writable, fields[? |
Is visible | |
legacy_ |
int64 |
Legacy Connection ID | filters on the platform, writable, fields[? |
Legacy Connection ID | |
number_ |
int64 |
Number of Sales | filters on the platform, writable, fields[? |
Number of sales | |
rating_ |
int64 |
Rating Count | filters on the platform, writable, fields[? |
Rating Count | |
schema |
varchar2 |
Schema ID | filters on the platform, writable, computed | Unique ID of the custom object the record belongs to. | |
search_ |
varchar2 |
Search Keywords | filters on the platform, writable, fields[? |
Search keywords | |
status |
varchar2 |
Status | filters on the platform, writable, fields[? |
Status | |
stock_ |
varchar2 |
Stock Status | filters on the platform, writable, fields[? |
Stock status | |
store_ |
varchar2 |
Store Base Product ID | filters on the platform, writable, fields[? |
Store Parent ID | |
store_ |
varchar2 |
Store Primary ID | filters on the platform, writable, fields[? |
Store variant ID | |
store_ |
varchar2 |
Store Variant ID | filters on the platform, writable, fields[? |
Deprecated | |
tags |
varchar2 |
Tags | filters on the platform, writable, fields[? |
Tags | |
type |
varchar2 |
Type | filters on the platform, writable, fields[? |
Type | |
upc |
varchar2 |
UPC | filters on the platform, writable, fields[? |
UPC | |
updated |
datetime |
Last Modified | filters on the platform, writable, computed | Moment of last change. | |
variant_ |
varchar2 |
Variant Description | filters on the platform, writable, fields[? |
Variant description | |
variant_ |
varchar2 |
Variant Dimensions | filters on the platform, writable, fields[? |
Variant Dimension | |
variant_ |
varchar2 |
Variant Images | filters on the platform, writable, fields[? |
Variant Image | |
variant_ |
varchar2 |
Variant Name | filters on the platform, writable, fields[? |
Variant name | |
variant_ |
decimal |
Variant Price | filters on the platform, writable, fields[? |
Variant price | |
variant_ |
varchar2 |
Variant Price Amount | filters on the platform, writable, fields[? |
Variant price amount (deprecated field) | |
variant_ |
varchar2 |
Variant Price Amounts | filters on the platform, writable, fields[? |
Variant price (Deprecated Field) | |
variant_ |
varchar2 |
Variant Price Currency | filters on the platform, writable, fields[? |
Variant price currency | |
variant_ |
varchar2 |
Variant Price Currency Code | filters on the platform, writable, fields[? |
Currency of the amount in column variant_price. | |
variant_ |
varchar2 |
Variant SKU | filters on the platform, writable, fields[? |
Variant sku | |
variant_ |
datetime |
Variant Store Created Date | filters on the platform, writable, fields[? |
Variant store created date | |
variant_ |
datetime |
Variant Store Modified Date | filters on the platform, writable, fields[? |
Variant store modified date | |
variant_ |
varchar2 |
Variant URL | filters on the platform, writable, fields[? |
Variant URL | |
variant_ |
varchar2 |
Variant URL Slug | filters on the platform, writable, fields[? |
Variant URL slug | |
variant_ |
decimal |
Variant Weight | filters on the platform, writable, fields[? |
Variant weight | |
view_ |
int64 |
View Count | filters on the platform, writable, fields[? |
View count |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver:
Modifiche apportate a questa tabella, da 26.0 a 27.0
È stata aggiunta la tabella ActiveCampaign.CustomObjects.Products
La tabella ha colonne 56 e supporta le operazioni di selezione e inserimento.
- importanza 3