Skip to content
COMMERCE QUERY
/
Products
/
/
Enferno.Storm.Query.Api.D...

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/

Schemas

Schemas

Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSkuPriceList

PartNostring

PartNo. MaxLength: 50. Key property.

SupplierIdinteger(int32)

SupplierId. Key property.

SupplierPriceListIdinteger(int32)

SupplierPriceListId. Nullable. Key property.

QtyBreakinteger(int32)

QtyBreak. Key property.

CurrencyIdinteger(int32)

CurrencyId.

CostPurchasenumber(decimal)

CostPurchase.

CostPurchaseLastCheckedstring(date-time)

CostPurchaseLastChecked. Nullable.

CostPurchaseLastUpdatedstring(date-time)

CostPurchaseLastUpdated. Nullable.

CostPurchaseLastUpdatedByinteger(int32)

CostPurchaseLastUpdatedBy. Nullable.

CostPurchaseValidTostring(date-time)

CostPurchaseValidTo. Nullable.

PriceRecommendednumber(decimal)

PriceRecommended. Nullable.

PriceRecommendedLastUpdatedstring(date-time)

PriceRecommendedLastUpdated. Nullable.

PriceRecommendedLastUpdatedByinteger(int32)

PriceRecommendedLastUpdatedBy. Nullable.

PriceMaxnumber(decimal)

PriceMax. Nullable.

PriceMaxLastUpdatedstring(date-time)

PriceMaxLastUpdated. Nullable.

PriceMaxLastUpdatedByinteger(int32)

PriceMaxLastUpdatedBy. Nullable.

PriceDealernumber(decimal)

PriceDealer. Nullable.

PriceDealerLastUpdatedstring(date-time)

PriceDealerLastUpdated. Nullable.

PriceDealerLastUpdatedByinteger(int32)

PriceDealerLastUpdatedBy. Nullable.

IsActiveboolean

IsActive.

IsActiveLastUpdatedstring(date-time)

IsActiveLastUpdated. Nullable.

StoppedDatestring(date-time)

StoppedDate. Nullable.

IsPromotionboolean

IsPromotion. Nullable.

IsFocusboolean

IsFocus. Nullable.

PriceRankinginteger(int32)

PriceRanking. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

FreightCostnumber(decimal)

FreightCost. Nullable.

CostFeenumber(decimal)

CostFee. Nullable.

CostFeeLastUpdatedstring(date-time)

CostFeeLastUpdated. Nullable.

CostFeeLastUpdatedByinteger(int32)

CostFeeLastUpdatedBy. Nullable.

DiscountPctnumber(decimal)

DiscountPct. Nullable.

DiscountPctLastUpdatedstring(date-time)

DiscountPctLastUpdated. Nullable.

DiscountPctLastUpdatedByinteger(int32)

DiscountPctLastUpdatedBy. Nullable.

PriceCatalognumber(decimal)

PriceCatalog. Nullable.

PriceCatalogLastUpdatedstring(date-time)

PriceCatalogLastUpdated. Nullable.

PriceCatalogLastUpdatedByinteger(int32)

PriceCatalogLastUpdatedBy. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

Skuobject(Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSku)(Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSku)
PriceListobject(ProductService.SupplierPriceList)(ProductService.SupplierPriceList)
{
  "PartNo": "string",
  "SupplierId": 0,
  "SupplierPriceListId": 0,
  "QtyBreak": 0,
  "CurrencyId": 0,
  "CostPurchase": 0,
  "CostPurchaseLastChecked": "2019-08-24T14:15:22Z",
  "CostPurchaseLastUpdated": "2019-08-24T14:15:22Z",
  "CostPurchaseLastUpdatedBy": 0,
  "CostPurchaseValidTo": "2019-08-24T14:15:22Z",
  "PriceRecommended": 0,
  "PriceRecommendedLastUpdated": "2019-08-24T14:15:22Z",
  "PriceRecommendedLastUpdatedBy": 0,
  "PriceMax": 0,
  "PriceMaxLastUpdated": "2019-08-24T14:15:22Z",
  "PriceMaxLastUpdatedBy": 0,
  "PriceDealer": 0,
  "PriceDealerLastUpdated": "2019-08-24T14:15:22Z",
  "PriceDealerLastUpdatedBy": 0,
  "IsActive": true,
  "IsActiveLastUpdated": "2019-08-24T14:15:22Z",
  "StoppedDate": "2019-08-24T14:15:22Z",
  "IsPromotion": true,
  "IsFocus": true,
  "PriceRanking": 0,
  "Created": "2019-08-24T14:15:22Z",
  "CreatedBy": 0,
  "Updated": "2019-08-24T14:15:22Z",
  "UpdatedBy": 0,
  "FreightCost": 0,
  "CostFee": 0,
  "CostFeeLastUpdated": "2019-08-24T14:15:22Z",
  "CostFeeLastUpdatedBy": 0,
  "DiscountPct": 0,
  "DiscountPctLastUpdated": "2019-08-24T14:15:22Z",
  "DiscountPctLastUpdatedBy": 0,
  "PriceCatalog": 0,
  "PriceCatalogLastUpdated": "2019-08-24T14:15:22Z",
  "PriceCatalogLastUpdatedBy": 0,
  "ClientId": 0,
  "Sku": {
    "PartNo": "string",
    "SupplierId": 0,
    "Name": "string",
    "ManufacturerId": 0,
    "ManufacturerCode": "string",
    "ManufacturerPartNo": "string",
    "CategoryId": 0,
    "CategoryCode": "string",
    "CommodityCode": "string",
    "EanCode": "string",
    "GrossWeight": 0,
    "NetWeight": 0,
    "VatCodeId": 0,
    "UnitOfMeasurementId": 0,
    "UnitOfMeasurementCount": 0,
    "Url": "string",
    "ImagePath": "string",
    "Created": "2019-08-24T14:15:22Z",
    "CreatedBy": 0,
    "Updated": "2019-08-24T14:15:22Z",
    "UpdatedBy": 0,
    "ImagePathLastUpdated": "2019-08-24T14:15:22Z",
    "IsUsed": true,
    "LogisticWidth": 0,
    "LogisticHeight": 0,
    "LogisticDepth": 0,
    "ClientId": 0,
    "ProductId": 0,
    "SupplierProductSkuClient": [ … ],
    "OnHands": [ … ],
    "PriceLists": [ … ],
    "Info": [ … ]
  },
  "PriceList": {
    "Id": 0,
    "SupplierId": 0,
    "ManufacturerId": 0,
    "ManufacturerCode": "string",
    "DefaultName": "string",
    "Code": "string",
    "Description": "string",
    "EndCustomer": "string",
    "StartDate": "2019-08-24T14:15:22Z",
    "EndDate": "2019-08-24T14:15:22Z",
    "TransferMethodId": 0,
    "TransferMethodValue": "string",
    "LastImported": "2019-08-24T14:15:22Z",
    "NextExpectedDate": "2019-08-24T14:15:22Z",
    "IsPrimary": true,
    "ParentSupplierPriceListId": 0,
    "Contact": "string",
    "Comment": "string",
    "IsSpecialTerms": true,
    "IsManuallyMaintained": true,
    "IgniteSourceId": 0,
    "IgniteSourceLastImported": "2019-08-24T14:15:22Z",
    "Created": "2019-08-24T14:15:22Z",
    "CreatedBy": 0,
    "Updated": "2019-08-24T14:15:22Z",
    "UpdatedBy": 0,
    "CurrencyId": 0,
    "TraderaStockCodeSeed": "string",
    "TraderaExternalStockCodeSeed": "string",
    "ClientId": 0
  }
}

Enferno.Storm.Query.Api.DataContexts.ProductModel.VariantCulture

VariantIdinteger(int32)

VariantId. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Key property.

ClientIdinteger(int32)

ClientId. Key property.

Namestring

Name. MaxLength: 255. Nullable.

ImagePathstring

ImagePath. MaxLength: 255. Nullable.

ThumbnailImagePathstring

ThumbnailImagePath. MaxLength: 255. Nullable.

CampaignImagePathstring

CampaignImagePath. MaxLength: 255. Nullable.

LargeImagePathstring

LargeImagePath. MaxLength: 255. Nullable.

Titlestring

Title. MaxLength: 255. Nullable.

Tagsstring

Tags. Nullable.

MetaTagsstring

MetaTags. Nullable.

MetaDescriptionstring

MetaDescription. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

UniqueUrlNamestring

UniqueUrlName. MaxLength: 500. Nullable.

IsUniqueUrlNameManuallyMaintainedboolean

IsUniqueUrlNameManuallyMaintained.

ImageKeystring(guid)

ImageKey. Nullable.

NameLastUpdatedstring(date-time)

NameLastUpdated. Nullable.

NameLastUpdatedByinteger(int32)

NameLastUpdatedBy. Nullable.

{
  "VariantId": 0,
  "CultureCode": "string",
  "ClientId": 0,
  "Name": "string",
  "ImagePath": "string",
  "ThumbnailImagePath": "string",
  "CampaignImagePath": "string",
  "LargeImagePath": "string",
  "Title": "string",
  "Tags": "string",
  "MetaTags": "string",
  "MetaDescription": "string",
  "Updated": "2019-08-24T14:15:22Z",
  "UpdatedBy": 0,
  "UniqueUrlName": "string",
  "IsUniqueUrlNameManuallyMaintained": true,
  "ImageKey": "string",
  "NameLastUpdated": "2019-08-24T14:15:22Z",
  "NameLastUpdatedBy": 0
}

Enferno.Storm.Query.Api.DataContexts.ProductModel.ClientProductFlag

ProductIdinteger(int32)

ProductId. Key property.

FlagIdinteger(int32)

FlagId. Key property.

ClientIdinteger(int32)

ClientId.

IsActiveboolean

IsActive.

StoppedDatestring(date-time)

StoppedDate. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

{
  "ProductId": 0,
  "FlagId": 0,
  "ClientId": 0,
  "IsActive": true,
  "StoppedDate": "2019-08-24T14:15:22Z",
  "Created": "2019-08-24T14:15:22Z",
  "CreatedBy": 0,
  "Updated": "2019-08-24T14:15:22Z",
  "UpdatedBy": 0
}

Products

Operations