Products: ActiveCampaign Products
insert REST
- Catalogus:
ActiveCampaign - Schema:
CustomObjects - Primaire sleutels:
id - Label: Products
Met insert kun je gegevens ophalen en wijzigen.
Samenvatting
Products imported into ActiveCampaign
API-bron
- Eindpunt:
/customObjects/records/1fadeeeb-0a94-4499-a01a-83ffe9111f47
Prestatiekenmerken
| Characteristic | Value |
|---|---|
| Gemiddelde toegangsvertraging (ms) | 264 |
| Aantal rijen per minuut bij volledige scan | 13,400 |
Het resultaat kan op de client in de Cache worden opgeslagen.
Tabelkolommen
De kolommen van de tabel Products worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| attributes | varchar2 | Attributes | [ ] | filters on the platform, writable, fields[?(@.id=='attributes')].value | Attributes |
| average_rating | varchar2 | Gemiddelde Score | [ ] | filters on the platform, writable, fields[?(@.id=='average-rating')].value | DEPRECATED! |
| average_ratings | decimal | Gemiddelde Beoordelingen | [ ] | filters on the platform, writable, fields[?(@.id=='average-ratings')].value | Gemiddelde Score |
| base_product_description | varchar2 | Basisproduct Omschrijving | [ ] | filters on the platform, writable, fields[?(@.id=='base-product-description')].value | FIELD_BASE_PRODUCT_DESCRIPTION |
| base_product_dimensions | varchar2 | Basisproduct Naam
Basisproduct Naam
Basisproduct Dimensies | [ ] | filters on the platform, writable, fields[?(@.id=='base-product-dimensions')].value | Base product dimensions |
| base_product_images | varchar2 | Basisproduct Afbeeldingen | [ ] | filters on the platform, writable, fields[?(@.id=='base-product-images')].value | Base product images |
| base_product_name | varchar2 | Basisproduct Naam | [ ] | filters on the platform, writable, fields[?(@.id=='base-product-name')].value | Basisproduct Naam |
| base_product_store_created_date | datetime | Basisproduct Winkel Aanmaakdatum | [ ] | 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 | Basisproduct Winkel Wijzigingsdatum | [ ] | filters on the platform, writable, fields[?(@.id=='base-product-store-modified-date')].value | Modified date for base product in store |
| base_product_url | varchar2 | Basisproduct URL | [ ] | filters on the platform, writable, fields[?(@.id=='base-product-url')].value | Base product URL |
| base_product_url_slug | varchar2 | Basisproduct URL Slug | [ ] | filters on the platform, writable, fields[?(@.id=='base-product-url-slug')].value | Base product URL slugs |
| base_product_weight | decimal | Basisproduct Gewicht | [ ] | 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 | Verbinding ID | [ ] | filters on the platform, writable, fields[?(@.id=='connection-id')].value | Verbinding 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 | [x] | filters on the platform, writable, computed | Unique ID of the record, in the form of a GUID. |
| inventory_quantity | int64 | Voorraadhoeveelheid | [ ] | filters on the platform, writable, fields[?(@.id=='inventory-quantity')].value | Voorraadhoeveelheid |
| is_backorders_allowed | varchar2 | Zijn Backorders Toegestaan | [ ] | filters on the platform, writable, fields[?(@.id=='is-backorders-allowed')].value | Are backorders allowed |
| is_deleted | varchar2 | Is Verwijderd | [ ] | filters on the platform, writable, fields[?(@.id=='is-deleted')].value | Is deleted |
| is_downloadable | varchar2 | Is Downloadbaar | [ ] | filters on the platform, writable, fields[?(@.id=='is-downloadable')].value | Is downloadable |
| is_on_sale | varchar2 | Is in Aanbieding | [ ] | filters on the platform, writable, fields[?(@.id=='is-on-sale')].value | Is on sale |
| is_virtual | varchar2 | Is Virtueel | [ ] | filters on the platform, writable, fields[?(@.id=='is-virtual')].value | Is virtual |
| is_visible | varchar2 | Is Zichtbaar | [ ] | filters on the platform, writable, fields[?(@.id=='is-visible')].value | Is visible |
| legacy_connection_id | int64 | Oude Verbindings-ID | [ ] | filters on the platform, writable, fields[?(@.id=='legacy-connection-id')].value | Oude Verbindings-ID |
| number_of_sales | int64 | Aantal Verkopen | [ ] | filters on the platform, writable, fields[?(@.id=='number-of-sales')].value | Number of sales |
| rating_count | int64 | Beoordelingen Aantal | [ ] | filters on the platform, writable, fields[?(@.id=='rating-count')].value | Beoordelingen Aantal |
| schemaId | varchar2 | Schema-ID | [ ] | filters on the platform, writable, computed | Unique ID of the custom object the record belongs to. |
| search_keywords | varchar2 | Zoektermen | [ ] | 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 | Voorraadstatus | [ ] | filters on the platform, writable, fields[?(@.id=='stock-status')].value | Stock status |
| store_base_product_id | varchar2 | Winkel Basisproduct-ID | [ ] | filters on the platform, writable, fields[?(@.id=='store-base-product-id')].value | Store Parent ID |
| store_primary_id | varchar2 | Winkel Primaire-ID | [ ] | filters on the platform, writable, fields[?(@.id=='store-primary-id')].value | Store variant ID |
| store_variant_id | varchar2 | Winkel 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 | Laatst Gewijzigd | [ ] | filters on the platform, writable, computed | Moment of last change. |
| variant_description | varchar2 | Variantomschrijving | [ ] | filters on the platform, writable, fields[?(@.id=='variant-description')].value | Variant description |
| variant_dimensions | varchar2 | Variantafmetingen | [ ] | filters on the platform, writable, fields[?(@.id=='variant-dimensions')].value | Variant Dimension |
| variant_images | varchar2 | Variantafbeeldingen | [ ] | filters on the platform, writable, fields[?(@.id=='variant-images')].value | Variant Image |
| variant_name | varchar2 | Variantnaam | [ ] | filters on the platform, writable, fields[?(@.id=='variant-name')].value | Variant name |
| variant_price | decimal | Variantprijs | [ ] | filters on the platform, writable, fields[?(@.id=='variant-price')].value | Variant price |
| variant_price_amount | varchar2 | Variantprijsbedrag | [ ] | filters on the platform, writable, fields[?(@.id=='variant-price-amount')].value | Variant price amount (deprecated field) |
| variant_price_amounts | varchar2 | Variantprijsbedragen | [ ] | filters on the platform, writable, fields[?(@.id=='variant-price-amounts')].value | Variant price (Deprecated Field) |
| variant_price_currency | varchar2 | Variantprijsvaluta | [ ] | filters on the platform, writable, fields[?(@.id=='variant-price-currency')].value | Variant price currency |
| variant_price_currency_code | varchar2 | Variantprijsvalutacode | [ ] | 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 Winkel Aangemaakt Datum | [ ] | filters on the platform, writable, fields[?(@.id=='variant-store-created-date')].value | Variant store created date |
| variant_store_modified_date | datetime | Variant Winkel Gewijzigd Datum | [ ] | 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 | Variantgewicht | [ ] | filters on the platform, writable, fields[?(@.id=='variant-weight')].value | Variant weight |
| view_count | int64 | Aantal Weergaven | [ ] | filters on the platform, writable, fields[?(@.id=='view-count')].value | View count |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver:
Wijzigingen in deze tabel, 26.0 tot 27.0
Tabel ActiveCampaign.CustomObjects.Products is toegevoegd
De tabel heeft 56 kolommen en ondersteunt de bewerkingen select en insert.
- belang 3