-
General
-
Releases
-
Owl Cloud Services
-
Base connector
-
- Beginner's Guide
- SAWSConnector settings
- Overview
- Station Overview
- Station configuration
- Datamaps
- Importing templates
- Format plugins explained
- Chaining format plugins
- Setting conditions
- Placeholders in format plugins
- Notes for field settings
- Jobs
- Testing exports and the development editor
- Job related tasks
- Job filter function
- How to create backups
- Running and Monitoring Jobs
- Start jobs automatically
- Import/Export & copy of data map rows
- Synchronizing references that are not contained in views
- Get the preconfigured "Source data set - Template"
- Configuring categories and products
- Fill Bundle and Variant tables from children
- Create View tree automatically
- Configuring the price & stock modules
- Configuring the price/stock value ranges
- Configuring volume discounts/scale prices
- How to export prices
- How to export stock values from certain storage units
- Use of Contentserv Credentials
- Rename export.zip Archives
- Connector & Station User Limitation
- Show all articles ( 18 ) Collapse Articles
-
- Importing data to our price tables
- SAWSConnector Usages
- Variant Articles
- Grouped products
- Virtual products
- Assignment of articles to complex articles
- SC::Channel Management
- Searching for SC::Prices / SC::Stocks
- Searching for SC::Channels
- Setup a transformation list for CSTypes
- Context-Sensitive Product Value Export
-
- Working with placeholder in conditions
- Improve usability of SC::Tables
- Placeholder for SC::Price, SC::Channel, SC::Stock
- REST Service API for SAWS Tables (Prices, Stock, Channels & Complex Articles)
- Dataflow import of SC::Tables
- Dataflow export of SC::Tables
- The datamap summary - Creating an automated documentation
- Export images as a ZIP file
- Image export with direct access to the CONTENTSERV platform
- Image export with no access to the CONTENTSERV platform
- Image export from a third party system
- How to configure CS Dashboard
- Setup a transformation list for CSTypes
- FAQ
- Transfer final result files to remote server by using FTP, sFTP, WebDAV or Azure Blob Storage
- Export Smart Document via Active Script and assign output to product
- Format Macros
- Controlling Connector Jobs via the REST API
- Basic Placeholders
- Job Parameters
- Input Types
- Sales Channel Maintenance via Excel Cross-Reference
- Show all articles ( 7 ) Collapse Articles
-
-
- Send value of a PIM reference
- Loop values for CS PIM references
- Send value of a MAM reference
- Loop values for CS MAM references
- Send value of a Channel (view) reference
- Loop values for CS Channel (Views) references
- Send value of an attribute reference
- Send value of a user reference
- Loop values for user references
- Send value of a reference (deprecated)
- Merge reference values
-
- Loops explained
- Loop values for several attributes simultaneously
- Loop values for child elements
- Loop values for CS PIM references
- Loop values for CS Channel (Views) references
- Loop values for CS MAM references
- Loop values for user references
- Loop values for SC::Prices
- Loop values for SC::Stocktable entries
- Loop values for SC::Complex products
- Loop values for CS type reference
- Loop values for a CS table
- Loop value for simple data record
-
- Create a JSON-String (create an array)
- Export several values simultaneously
- Format value lists
- Execute a conditional format (switch-case)
- Tree paths or values from tree elements
- Export value of current attribute
- Multistep formatting
- Send accesslevel of the object
- Send value of a job parameter
- Search for values in several attributes
- Format with PHP Code (deprecated)
- Format Macros
-
GenericJSON / DynamicJSON Connector
-
-
- Send value of a PIM reference
- Loop values for CS PIM references
- Send value of a Channel (view) reference
- Loop values for CS Channel (Views) references
- Send value of a MAM reference
- Loop values for CS MAM references
- Send value of an attribute reference
- Send value of a user reference
- Loop values for user references
- Send value of a reference (deprecated)
- Merge reference values
-
- Loops explained
- Loop values for several attributes simultaneously
- Loop values for child elements
- Loop values for CS PIM references
- Loop values for CS Channel (Views) references
- Loop values for CS MAM references
- Loop values for user references
- Loop values for SC::Prices
- Loop values for SC::Stocktable entries
- Loop values for SC::Complex products
- Loop values for a CS table
- Loop values for CS type reference
- Loop value for simple data record
-
- Create a JSON-String (create an array)
- Export several values simultaneously
- Format value lists
- Execute a conditional format (switch-case)
- Tree paths or values from tree elements
- Export value of current attribute
- Multistep formatting
- Send accesslevel of the object
- Send value of a job parameter
- Search for values in several attributes
- Format with PHP Code (deprecated)
- Format Macros
-
GenericXML Connector
-
- All Tutorials for creating XMLs
- SAWSConnector settings
- Station configuration
- Example station configuration
- Source data set configuration
- Example source data set mappings for the XML export
- Job configuration
- Simple XML Tags
- Images
- References
- SC::Prices
- SC::Stock
- SC::Channel
- Specials
- BMECat 1.2 Template
-
-
- Send value of a PIM reference
- Loop values for CS PIM references
- Send value of a Channel (view) reference
- Loop values for CS Channel (Views) references
- Send value of a MAM reference
- Loop values for CS MAM references
- Send value of an attribute reference
- Send value of a user reference
- Loop values for user references
- Send value of a reference (deprecated)
- Merge reference values
-
- Loops explained
- Loop values for several attributes simultaneously
- Loop values for child elements
- Loop values for CS PIM references
- Loop values for CS Channel (Views) references
- Loop values for CS MAM references
- Loop values for user references
- Loop values for SC::Prices
- Loop values for SC::Stocktable entries
- Loop values for SC::Complex products
- Loop values for a CS table
- Loop values for CS type reference
- Loop value for simple data record
-
- Create a JSON-String (create an array)
- Export several values simultaneously
- Format value lists
- Execute a conditional format (switch-case)
- Tree paths or values from tree elements
- Export value of current attribute
- Multistep formatting
- Send accesslevel of the object
- Send value of a job parameter
- Search for values in several attributes
- Format with PHP Code (deprecated)
- Format Macros
-
SimpleExcel Connector
-
-
- Send value of a PIM reference
- Loop values for CS PIM references
- Send value of a Channel (view) reference
- Loop values for CS Channel (Views) references
- Send value of a MAM reference
- Loop values for CS MAM references
- Send value of an attribute reference
- Send value of a user reference
- Loop values for user references
- Send value of a reference (deprecated)
- Merge reference values
-
- Loops explained
- Loop values for several attributes simultaneously
- Loop values for child elements
- Loop values for CS PIM references
- Loop values for CS Channel (Views) references
- Loop values for CS MAM references
- Loop values for user references
- Loop values for SC::Prices
- Loop values for SC::Stocktable entries
- Loop values for SC::Complex products
- Loop values for a CS table
- Loop values for CS type reference
- Loop value for simple data record
-
- Create a JSON-String (create an array)
- Export several values simultaneously
- Format value lists
- Execute a conditional format (switch-case)
- Tree paths or values from tree elements
- Export value of current attribute
- Multistep formatting
- Send accesslevel of the object
- Send value of a job parameter
- Search for values in several attributes
- Format with PHP Code (deprecated)
- Format Macros
-
Magento Connector
-
- Magento 2.x configuration
- Creating views
- Configuring categories and products
- Stations
- Add and configure a new source data set
- Assigning a Magento website
- Advanced pricing export
- Configurable products
- Bundle products
- country_of_manufacture
- max_sale_qty
- meta_description
- meta_keyword
- min_sale_qty
- msrp
- msrp_display_actual_price_type
- msrp_enabled
- news_from_date
- news_to_date
- special_from_date
- special_price
- special_to_date
- _links_crosssell_sku
- _links_related_sku
- _links_upsell_sku
- _media_image
- available_sort_by
- default_sort_by
- image
- include_in_menu
- is_active
- is_anchor
- is_in_stock
- meta_title
- name
- price
- small_image
- status
- tax_class_id
- thumbnail
- visibility
- weight
- description
- qty
- short_description
- sku
- Adding Jobs
- Show all articles ( 32 ) Collapse Articles
-
-
- Send value of a PIM reference
- Loop values for CS PIM references
- Send value of a Channel (view) reference
- Loop values for CS Channel (Views) references
- Send value of a MAM reference
- Loop values for CS MAM references
- Send value of an attribute reference
- Send value of a user reference
- Loop values for user references
- Send value of a reference (deprecated)
- Merge reference values
-
- Loops explained
- Loop values for several attributes simultaneously
- Loop values for child elements
- Loop values for CS PIM references
- Loop values for CS Channel (Views) references
- Loop values for CS MAM references
- Loop values for user references
- Loop values for SC::Prices
- Loop values for SC::Stocktable entries
- Loop values for SC::Complex products
- Loop values for a CS table
- Loop values for CS type reference
- Loop value for simple data record
-
- Create a JSON-String (create an array)
- Export several values simultaneously
- Format value lists
- Execute a conditional format (switch-case)
- Tree paths or values from tree elements
- Export value of current attribute
- Multistep formatting
- Send accesslevel of the object
- Send value of a job parameter
- Search for values in several attributes
- Format with PHP Code (deprecated)
- Format Macros
-
Shopware 5 Connector
-
- Configuration Shopware
- Configuration PIM
- Shopware attribute setting
- Configuration SAWSConnector
- Station configuration
- Source data set configuration
- Configuring categories and products
- Price table configuration for Shopware
- Result in Shopware
- Subshops and the SAWSConnector Shopware
- ean
- Custom Fields (attribute)
- highlight
- purchaseSteps
- stockMin
- supplierNumber
- notification
- shippingFree
- length
- height
- width
- weight
- shippingTime
- metaKeywords
- added
- blog
- descriptionLong
- hidefilter
- hideTop
- inStock
- keywords
- lastStock
- maxPurchase
- metaDescription
- minPurchase
- noViewSelect
- pseudoSales
- related
- releaseDate
- showFilterGroups
- similar
- tax
- template
- cmsHeadline
- cmsText
- description
- metaTitle
- name
- number
- supplier
- Show all articles ( 35 ) Collapse Articles
-
-
- Send value of a PIM reference
- Loop values for CS PIM references
- Send value of a Channel (view) reference
- Loop values for CS Channel (Views) references
- Send value of a MAM reference
- Loop values for CS MAM references
- Send value of an attribute reference
- Send value of a user reference
- Loop values for user references
- Send value of a reference (deprecated)
- Merge reference values
-
- Loops explained
- Loop values for several attributes simultaneously
- Loop values for child elements
- Loop values for CS PIM references
- Loop values for CS Channel (Views) references
- Loop values for CS MAM references
- Loop values for user references
- Loop values for SC::Prices
- Loop values for SC::Stocktable entries
- Loop values for SC::Complex products
- Loop values for a CS table
- Loop values for CS type reference
- Loop value for simple data record
-
- Create a JSON-String (create an array)
- Export several values simultaneously
- Format value lists
- Execute a conditional format (switch-case)
- Tree paths or values from tree elements
- Export value of current attribute
- Multistep formatting
- Send accesslevel of the object
- Send value of a job parameter
- Search for values in several attributes
- Format with PHP Code (deprecated)
- Format Macros
-
Shopware 6 Connector
-
- Tutorial Video
- First steps
- Import Shopware settings
- Export categories
- Export media files
- Export simple products
- Export multiple languages
- Export variant products
- Export product properties
- Export custom fields
- Export product cross-selling relationships
- Export prices
- Export stocks
- Export into any other Shopware field
- How to address multiple Shopware 6 websites
- How to address different Shopware 6 Sale-Channels from one Contentserv System
- Useful Links
- Export via RabbitMQ
- Sales Channel Maintenance via Excel Cross-Reference
- Show all articles ( 4 ) Collapse Articles
-
-
- Send value of a PIM reference
- Loop values for CS PIM references
- Send value of a MAM reference
- Loop values for CS MAM references
- Send value of a Channel (view) reference
- Loop values for CS Channel (Views) references
- Send value of an attribute reference
- Send value of a user reference
- Loop values for user references
- Send value of a reference (deprecated)
- Merge reference values
-
- Loops explained
- Loop values for several attributes simultaneously
- Loop values for child elements
- Loop values for CS PIM references
- Loop values for CS Channel (Views) references
- Loop values for CS MAM references
- Loop values for user references
- Loop values for SC::Prices
- Loop values for SC::Stocktable entries
- Loop values for SC::Complex products
- Loop values for a CS table
- Loop values for CS type reference
- Loop value for simple data record
-
- Create a JSON-String (create an array)
- Export several values simultaneously
- Format value lists
- Execute a conditional format (switch-case)
- Tree paths or values from tree elements
- Export value of current attribute
- Multistep formatting
- Send accesslevel of the object
- Send value of a job parameter
- Search for values in several attributes
- Format with PHP Code (deprecated)
- Format Macros
-
OXID Connector
-
-
- Send value of a PIM reference
- Loop values for CS PIM references
- Send value of a MAM reference
- Loop values for CS MAM references
- Send value of a Channel (view) reference
- Loop values for CS Channel (Views) references
- Send value of an attribute reference
- Send value of a user reference
- Loop values for user references
- Send value of a reference (deprecated)
- Merge reference values
-
- Loops explained
- Loop values for several attributes simultaneously
- Loop values for child elements
- Loop values for CS PIM references
- Loop values for CS Channel (Views) references
- Loop values for CS MAM references
- Loop values for user references
- Loop values for SC::Prices
- Loop values for SC::Stocktable entries
- Loop values for SC::Complex products
- Loop values for a CS table
- Loop values for CS type reference
- Loop value for simple data record
-
- Create a JSON-String (create an array)
- Export several values simultaneously
- Format value lists
- Execute a conditional format (switch-case)
- Tree paths or values from tree elements
- Export value of current attribute
- Multistep formatting
- Send accesslevel of the object
- Send value of a job parameter
- Search for values in several attributes
- Format with PHP Code (deprecated)
- Format Macros
-
Typo3 Connector
-
-
- Send value of a PIM reference
- Loop values for CS PIM references
- Send value of a Channel (view) reference
- Loop values for CS Channel (Views) references
- Send value of a MAM reference
- Loop values for CS MAM references
- Send value of an attribute reference
- Send value of a user reference
- Loop values for user references
- Send value of a reference (deprecated)
- Merge reference values
-
- Loops explained
- Loop values for several attributes simultaneously
- Loop values for child elements
- Loop values for CS PIM references
- Loop values for CS Channel (Views) references
- Loop values for CS MAM references
- Loop values for user references
- Loop values for SC::Prices
- Loop values for SC::Stocktable entries
- Loop values for SC::Complex products
- Loop values for a CS table
- Loop values for CS type reference
- Loop value for simple data record
-
- Create a JSON-String (create an array)
- Export several values simultaneously
- Format value lists
- Execute a conditional format (switch-case)
- Tree paths or values from tree elements
- Export value of current attribute
- Multistep formatting
- Send accesslevel of the object
- Send value of a job parameter
- Search for values in several attributes
- Format with PHP Code (deprecated)
- Format Macros
-
WooCommerce Connector
-
-
- Send value of a PIM reference
- Loop values for CS PIM references
- Send value of a Channel (view) reference
- Loop values for CS Channel (Views) references
- Send value of a MAM reference
- Loop values for CS MAM references
- Send value of an attribute reference
- Send value of a user reference
- Loop values for user references
- Send value of a reference (deprecated)
- Merge reference values
-
- Loops explained
- Loop values for several attributes simultaneously
- Loop values for child elements
- Loop values for CS PIM references
- Loop values for CS Channel (Views) references
- Loop values for CS MAM references
- Loop values for user references
- Loop values for SC::Prices
- Loop values for SC::Stocktable entries
- Loop values for SC::Complex products
- Loop values for a CS table
- Loop values for CS type reference
- Loop value for simple data record
-
- Create a JSON-String (create an array)
- Export several values simultaneously
- Format value lists
- Execute a conditional format (switch-case)
- Tree paths or values from tree elements
- Export value of current attribute
- Multistep formatting
- Send accesslevel of the object
- Send value of a job parameter
- Search for values in several attributes
- Format with PHP Code (deprecated)
- Format Macros
-
Other connectors
< Back
Print
REST Service API for SAWS Tables (Prices, Stock, Channels & Complex Articles)
PostedOctober 25, 2023
UpdatedJune 12, 2024
2
0
(Since connector version 1.17.0)
All SAWS tables can be read and altered via a REST Service API in the CRUD schema (Create/Read/Update/Delete). The following page contains all endpoints with example payloads.
This REST endpoint, together with all future REST endpoints, lies below admin/rest/scapiapp/. With that, the admin/rest/scchannelapp/ endpoint is officially deprecated and we recommend migrating your existing implementations to this newer version.
To utilize this REST service to its full extent, set your product number attribute in the SAWS settings.
Prices (admin/rest/scapiapp/price/)
Method | Endpoint | Description |
---|---|---|
POST | price/:productNumber | Creates or updates existing prices of the product |
PUT | price/:productNumber | Replaces all prices of the product with the sent prices |
GET | price/:productNumber | Gets all prices of the product |
DELETE | price/:productNumber | Deletes all prices of the product |
Example payload
[ { "Price": "19.00", "Currency": "EUR", "ValidFrom": "2022-03-02 10:22:39", "ValidTo": "0000-00-00 00:00:00", "PriceTyp": "EK", "PriceSubTyp": "EK2", "ChannelID": "BRITAIN", "AmountFrom": "0", "AmountTo": "0", "PriceUnit": "1.00", "Unit": "", }, ... ]
Special Keys
:productNumber | Product number or external key of the product |
filter | An optional filter can be added in the URL to filter the query e.g. ?filter[PriceTyp]=EK (Only for GET and DELETE) (Since 1.18.0) |
Stock (admin/rest/scapiapp/stock/)
Method | Endpoint | Description |
---|---|---|
POST | stock/:productNumber | Creates or updates existing stock entries of the product |
PUT | stock/:productNumber | Replaces all stock entries of the product with the sent stock entries |
GET | stock/:productNumber | Gets all stock entries of the product |
DELETE | stock/:productNumber | Deletes all stock entries of the product |
Example payload
[ { "ExternalKey": "stock1", "Amount": "417", "VirtuellAmount": "0", "UseVirtuell": "0", "MinAmount": null, "ReserveAmount": null, "SendAmount": null, "OrderAmount": null, "NotifyAmount": null, "Unit": "", "StockKey": "EK_7841", "AreaKey": "EK_10254", }, ... ]
Special Keys
:productNumber | Product number or external key of the product |
StockKey | Product number or external key of the PIM stock object |
AreaKey | Product number or external key of the PIM area object |
filter | An optional filter can be added in the URL to filter the query e.g. ?filter[StockKey]=EK_7841 (Only for GET and DELETE) (Since 1.18.0) |
Sales Channels (admin/rest/scapiapp/sales-channel/)
Method | Endpoint | Description |
---|---|---|
POST | sales-channel/:productNumber | Creates or updates existing sales channels of the product |
PUT | sales-channel/:productNumber | Replaces all sales channels of the product with the sent sales channels |
GET | sales-channel/:productNumber | Gets all sales channels of the product |
DELETE | sales-channel/:productNumber | Deletes all sales channels of the product |
Example payload
[ { "IsTemplate": "0", "ChannelID": "BRITAIN", "ChannelKeys": "EK_2246,EK_2920", "Status": "1", "ValidFrom": "0000-00-00 00:00:00", "ValidTo": "0000-00-00 00:00:00", "FirstDeliveryDate": "0000-00-00 00:00:00", "LastDeliveryDate": "0000-00-00 00:00:00", }, ... ]
Special Keys
:productNumber | Product number or external key of the product |
ChannelKeys | Comma separated list of external keys of the linked Contentserv channels |
filter | An optional filter can be added in the URL to filter the query e.g. ?filter[ChannelID]=BRITAIN (Only for GET and DELETE) (Since 1.18.0) |
Complex Articles (admin/rest/scapiapp/complex-article/)
Method | Endpoint | Description |
---|---|---|
POST | complex-article/:productNumber | Creates or updates existing complex articles of the product |
PUT | complex-article/:productNumber | Replaces all complex articles of the product with the sent complex articles |
GET | complex-article/:productNumber | Gets all complex articles of the product |
DELETE | complex-article/:productNumber | Deletes all complex articles of the product |
Example payload
[ { "VariantNumber": "PN_12764", "Quantity": "1", "ChangeableQuantity": "0", "IsDefault": "0", "IsDisabled": "0", "SortOrder": "0", "LinkTypeKey": "SET_COMPONENT" }, ... ]
Special Keys
:productNumber | Product number or external key of the product |
VariantNumber | Product number or external key of the connected variant product |
LinkTypeKey | External key of the value range entry for the variant link type |
filter | An optional filter can be added in the URL to filter the query e.g. ?filter[LinkTypeKey]=SET_COMPONENT (Only for GET and DELETE) (Since 1.18.0) |
Single Complex Article Connections
Method | Endpoint | Description |
---|---|---|
POST | complex-article/:productNumber/:variantNumber/:linkTypeKey | Creates or updates an existing complex articles entry of the product |
PUT | complex-article/:productNumber/:variantNumber/:linkTypeKey | Replaces a complex articles entry of the product with the sent complex articles entry |
GET | complex-article/:productNumber/:variantNumber/:linkTypeKey | Gets a complex articles entry of the product |
DELETE | complex-article/:productNumber/:variantNumber/:linkTypeKey | Deletes a complex articles entry of the product |
Example payload
{ "Quantity": "888888", "ChangeableQuantity": "0", "IsDefault": "0", "IsDisabled": "0", "SortOrder": "0" }
Special Keys
:productNumber | Product number or external key of the product |
:variantNumber | Product number or external key of the connected variant product |
:linkTypeKey (optional) | External key of the value range entry for the variant link type |
Table of Contents