Catalogs
The catalogs belonging to the shop.
Table-Specific Information
Select
The add-in processes all filters client-side within the add-in. The following query is the only one processed server side:
SELECT * FROM Catalogs
Insert
The following columns can be used to create a new record:
Status, Title, PriceListId, PublicationId
The following pseudo-column can be used to create a new record:
CompanyLocationIds
Update
The following columns can be updated:
Status, Title, PriceListId, PublicationId
The following pseudo-column can be updated:
CompanyLocationIds
Delete
You can delete entries by specifying the following column:
Id
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
A globally-unique ID. | |
| Status | String | False |
The status of the catalog. | |
| Title | String | False |
The name of the catalog. | |
| PriceListId | String | False |
A globally-unique ID. | |
| PublicationId | String | False |
A globally-unique ID. | |
| OperationId | String | True |
A globally-unique ID. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements, to offer a more granular control over the tuples that are returned from the data source, or as parameters in INSERT statements.
| Name | Type | Description |
| CompanyLocationIds | String |
The IDs of the company locations to associate to the catalog. |