invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

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

Alle wisselingen van de Driver, 26.0 tot 27.0