Import-pipeline table provider that links products to categories, inserting, updating or deleting ProductInCategory rows as an import pipeline runs. Registered under the provider id "productCategory" and looked up by a DatabaseUpdateStep or DatabaseSourceStep configured with that id. Each row must carry a productName (the product's SKU) and a categoryName identifying the category to associate it with; both are resolved against the organisation given in the row's org value, or the pipeline's own organisation if none is given.
Implements: DatabaseTableProvider
Properties
| Property | Returns | Description |
|---|---|---|
| providerId | String | Provider id this class is registered under. Used to select it from a DatabaseUpdateStep or DatabaseSourceStep configuration. |
| queryParameters | List<TableParameter> | Query parameters this provider accepts when building its source criteria. |
| tableFields | List<TableParameter> | Describes the row columns this provider accepts for insert, update, delete and updateOrInsert: productName (the product's SKU), categoryName (the category to link it to), and an optional org used to resolve both. |
Methods
getProviderId()
Returns: String
Provider id this class is registered under. Used to select it from a DatabaseUpdateStep or DatabaseSourceStep configuration.
getQueryParameters()
Returns: List<TableParameter>
Query parameters this provider accepts when building its source criteria.
getTableFields()
Returns: List<TableParameter>
Describes the row columns this provider accepts for insert, update, delete and updateOrInsert: productName (the product's SKU), categoryName (the category to link it to), and an optional org used to resolve both.