Skip to content
COMMERCE QUERY
/
Products
/
/
Get SupplierProductSkuCli...

Storm Query API Documentation (2.0)

Storm Query API is an API based on OData V4. It is an API to fill the need for data from Storm in integration services that do not have direct access to Storm’s data and data models.

Download OpenAPI description
openapi.json
openapi.yaml
Languages
Servers

https://customer-slug.api-se.norce.tech/commerce/query/2.0/

Products

Operations

Get ProductCategory

Request

Get ProductCategory

curl -i -X GET \
  https://customer-slug.api-se.norce.tech/commerce/query/2.0/Products/ProductCategories

Responses

Success

Bodyapplication/jsonArray [
ProductIdinteger(int32)

ProductId. Key property.

CategoryIdinteger(int32)

CategoryId. Key property.

ClientIdinteger(int32)

ClientId.

IsPrimaryboolean

IsPrimary.

SortOrderinteger(int32)

SortOrder. Nullable.

ProductSortOrderinteger(int32)

ProductSortOrder. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

]
Response
application/json
[
  {
    "ProductId": 0,
    "CategoryId": 0,
    "ClientId": 0,
    "IsPrimary": true,
    "SortOrder": 0,
    "ProductSortOrder": 0,
    "IsActive": true,
    "Created": "2019-08-24T14:15:22Z",
    "CreatedBy": 0,
    "Updated": "2019-08-24T14:15:22Z",
    "UpdatedBy": 0
  }
]

Get SupplierProductSkuClient

Request

Get SupplierProductSkuClient

curl -i -X GET \
  https://customer-slug.api-se.norce.tech/commerce/query/2.0/Products/SupplierProductSkuClient

Responses

Success

Bodyapplication/jsonArray [
PartNostring

PartNo. MaxLength: 50. Key property.

SupplierIdinteger(int32)

SupplierId. Key property.

ClientIdinteger(int32)

ClientId.

ProductIdinteger(int32)

ProductId. Nullable.

ManufacturerIdinteger(int32)

ManufacturerId. Nullable.

CategoryIdinteger(int32)

CategoryId. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

Skuobject(Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSku)(Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSku)
Productobject(Enferno.Storm.Query.Api.DataContexts.ProductModel.Product)(Enferno.Storm.Query.Api.DataContexts.ProductModel.Product)
]
Response
application/json
[
  {
    "PartNo": "string",
    "SupplierId": 0,
    "ClientId": 0,
    "ProductId": 0,
    "ManufacturerId": 0,
    "CategoryId": 0,
    "Created": "2019-08-24T14:15:22Z",
    "CreatedBy": 0,
    "Updated": "2019-08-24T14:15:22Z",
    "UpdatedBy": 0,
    "Sku": { … },
    "Product": { … }
  }
]

Get ProductSku

Request

Get ProductSku

curl -i -X GET \
  https://customer-slug.api-se.norce.tech/commerce/query/2.0/Products/ProductSkus

Responses

Success

Bodyapplication/jsonArray [
PartNostring

PartNo. MaxLength: 50. Key property.

ProductIdinteger(int32)

ProductId.

ClientIdinteger(int32)

ClientId.

StatusIdinteger(int32)

StatusId.

StatusLastUpdatedstring(date-time)

StatusLastUpdated. Nullable.

StatusLastUpdatedByinteger(int32)

StatusLastUpdatedBy. Nullable.

TypeIdinteger(int32)

TypeId.

IntegrationPartNostring

IntegrationPartNo. MaxLength: 50. Nullable.

ErpNamestring

ErpName. MaxLength: 255. Nullable.

DefaultCommentstring

DefaultComment. MaxLength: 255. Nullable.

CommodityCodestring

CommodityCode. MaxLength: 50. Nullable.

EanCodestring

EanCode. MaxLength: 50. Nullable.

TrackingCodestring

TrackingCode. MaxLength: 50. Nullable.

GrossWeightnumber(decimal)

GrossWeight. Nullable.

NetWeightnumber(decimal)

NetWeight. Nullable.

FreightClassIdinteger(int32)

FreightClassId. Nullable.

UnitOfMeasurementIdinteger(int32)

UnitOfMeasurementId. Nullable.

UnitOfMeasurementCountnumber(decimal)

UnitOfMeasurementCount.

PackageIdinteger(int32)

PackageId. Nullable.

TrackingCodeTypeIdinteger(int32)

TrackingCodeTypeId. Nullable.

Urlstring

Url. MaxLength: 255. Nullable.

ImagePathstring

ImagePath. MaxLength: 255. Nullable.

IsDropShipOnlyboolean

IsDropShipOnly. Nullable.

IsPublishedboolean

IsPublished.

PublishedLastUpdatedstring(date-time)

PublishedLastUpdated. Nullable.

PublishedLastUpdatedByinteger(int32)

PublishedLastUpdatedBy. Nullable.

IsBlockedboolean

IsBlocked.

BlockedLastUpdatedstring(date-time)

BlockedLastUpdated. Nullable.

BlockedLastUpdatedByinteger(int32)

BlockedLastUpdatedBy. Nullable.

PopulationRuleIdinteger(int32)

PopulationRuleId. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

LastCheckedstring(date-time)

LastChecked. Nullable.

TrackingModeTypeIdinteger(int32)

TrackingModeTypeId. Nullable.

IsStatusLockedboolean

IsStatusLocked.

StatusLockedDatestring(date-time)

StatusLockedDate. Nullable.

StatusLockedByinteger(int32)

StatusLockedBy. Nullable.

RecommendedSalesQtynumber(decimal)

RecommendedSalesQty. Nullable.

LogisticWidthnumber(decimal)

LogisticWidth. Nullable.

LogisticHeightnumber(decimal)

LogisticHeight. Nullable.

LogisticDepthnumber(decimal)

LogisticDepth. Nullable.

IsBuyableboolean

IsBuyable.

BuyableLastUpdatedstring(date-time)

BuyableLastUpdated. Nullable.

BuyableLastUpdatedByinteger(int32)

BuyableLastUpdatedBy. Nullable.

DiscountClassstring

DiscountClass. MaxLength: 50. Nullable.

IsRecommendedSalesQtyFixedboolean

IsRecommendedSalesQtyFixed. Nullable.

StartDatestring(date-time)

StartDate. Nullable.

EndDatestring(date-time)

EndDate. Nullable.

Productobject(Enferno.Storm.Query.Api.DataContexts.ProductModel.Product)(Enferno.Storm.Query.Api.DataContexts.ProductModel.Product)
CulturesArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuCulture)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuCulture)

Cultures.

PriceListsArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuPricelist)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuPricelist)

PriceLists.

SalesAreasArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuSalesArea)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuSalesArea)

SalesAreas.

OnHandsArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuOnHand)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuOnHand)

OnHands.

StructureItemsArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuStructureItem)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuStructureItem)

StructureItems.

BestPricesArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuBestPrice)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuBestPrice)

BestPrices.

]
Response
application/json
[
  {
    "PartNo": "string",
    "ProductId": 0,
    "ClientId": 0,
    "StatusId": 0,
    "StatusLastUpdated": "2019-08-24T14:15:22Z",
    "StatusLastUpdatedBy": 0,
    "TypeId": 0,
    "IntegrationPartNo": "string",
    "ErpName": "string",
    "DefaultComment": "string",
    "CommodityCode": "string",
    "EanCode": "string",
    "TrackingCode": "string",
    "GrossWeight": 0,
    "NetWeight": 0,
    "FreightClassId": 0,
    "UnitOfMeasurementId": 0,
    "UnitOfMeasurementCount": 0,
    "PackageId": 0,
    "TrackingCodeTypeId": 0,
    "Url": "string",
    "ImagePath": "string",
    "IsDropShipOnly": true,
    "IsPublished": true,
    "PublishedLastUpdated": "2019-08-24T14:15:22Z",
    "PublishedLastUpdatedBy": 0,
    "IsBlocked": true,
    "BlockedLastUpdated": "2019-08-24T14:15:22Z",
    "BlockedLastUpdatedBy": 0,
    "PopulationRuleId": 0,
    "Created": "2019-08-24T14:15:22Z",
    "CreatedBy": 0,
    "Updated": "2019-08-24T14:15:22Z",
    "UpdatedBy": 0,
    "LastChecked": "2019-08-24T14:15:22Z",
    "TrackingModeTypeId": 0,
    "IsStatusLocked": true,
    "StatusLockedDate": "2019-08-24T14:15:22Z",
    "StatusLockedBy": 0,
    "RecommendedSalesQty": 0,
    "LogisticWidth": 0,
    "LogisticHeight": 0,
    "LogisticDepth": 0,
    "IsBuyable": true,
    "BuyableLastUpdated": "2019-08-24T14:15:22Z",
    "BuyableLastUpdatedBy": 0,
    "DiscountClass": "string",
    "IsRecommendedSalesQtyFixed": true,
    "StartDate": "2019-08-24T14:15:22Z",
    "EndDate": "2019-08-24T14:15:22Z",
    "Product": { … },
    "Cultures": [ … ],
    "PriceLists": [ … ],
    "SalesAreas": [ … ],
    "OnHands": [ … ],
    "StructureItems": [ … ],
    "BestPrices": [ … ]
  }
]