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.ProductSkuStructureItem

StructurePartNostring

StructurePartNo. MaxLength: 50. Key property.

PartNostring

PartNo. MaxLength: 50. Key property.

ClientIdinteger(int32)

ClientId.

Qtynumber(decimal)

Qty.

SortOrderinteger(int32)

SortOrder. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

GroupIdinteger(int32)

GroupId. Nullable.

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

PriceLists.

InfoArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuStructureItemInfo)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuStructureItemInfo)

Info.

ItemSkuobject(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSku)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSku)
{
  "StructurePartNo": "string",
  "PartNo": "string",
  "ClientId": 0,
  "Qty": 0,
  "SortOrder": 0,
  "Created": "2019-08-24T14:15:22Z",
  "CreatedBy": 0,
  "Updated": "2019-08-24T14:15:22Z",
  "UpdatedBy": 0,
  "GroupId": 0,
  "PriceLists": [
    { … }
  ],
  "Info": [
    { … }
  ],
  "ItemSku": {
    "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": [ … ]
  }
}

Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuStructureItemInfo

StructurePartNostring

StructurePartNo. MaxLength: 50. Key property.

PartNostring

PartNo. MaxLength: 50. Key property.

Codestring

Code. MaxLength: 50. Key property.

ClientIdinteger(int32)

ClientId.

Valuestring

Value. MaxLength: 255. Nullable.

Updatedstring(date-time)

Updated.

UpdatedByinteger(int32)

UpdatedBy.

{
  "StructurePartNo": "string",
  "PartNo": "string",
  "Code": "string",
  "ClientId": 0,
  "Value": "string",
  "Updated": "2019-08-24T14:15:22Z",
  "UpdatedBy": 0
}

Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuStructureItemPriceList

StructurePartNostring

StructurePartNo. MaxLength: 50. Key property.

PartNostring

PartNo. MaxLength: 50. Key property.

PriceListIdinteger(int32)

PriceListId. Key property.

QtyBreakinteger(int32)

QtyBreak. Key property.

ClientIdinteger(int32)

ClientId.

ItemPriceListIdinteger(int32)

ItemPriceListId.

CurrencyIdinteger(int32)

CurrencyId.

PriceSalenumber(decimal)

PriceSale.

PriceRuleIdinteger(int32)

PriceRuleId. Nullable.

PriceRuleValuenumber(decimal)

PriceRuleValue. Nullable.

CostPurchasenumber(decimal)

CostPurchase.

CostUnitnumber(decimal)

CostUnit.

SupplementChargePercentagenumber(decimal)

SupplementChargePercentage. Nullable.

PriceStandardnumber(decimal)

PriceStandard. Nullable.

PriceRecommendednumber(decimal)

PriceRecommended. Nullable.

MinimumMarginPercentagenumber(decimal)

MinimumMarginPercentage. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

SupplementChargenumber(decimal)

SupplementCharge. Nullable.

LimitToPriceRecommendedboolean

LimitToPriceRecommended. Nullable.

{
  "StructurePartNo": "string",
  "PartNo": "string",
  "PriceListId": 0,
  "QtyBreak": 0,
  "ClientId": 0,
  "ItemPriceListId": 0,
  "CurrencyId": 0,
  "PriceSale": 0,
  "PriceRuleId": 0,
  "PriceRuleValue": 0,
  "CostPurchase": 0,
  "CostUnit": 0,
  "SupplementChargePercentage": 0,
  "PriceStandard": 0,
  "PriceRecommended": 0,
  "MinimumMarginPercentage": 0,
  "IsActive": true,
  "Created": "2019-08-24T14:15:22Z",
  "CreatedBy": 0,
  "Updated": "2019-08-24T14:15:22Z",
  "UpdatedBy": 0,
  "SupplementCharge": 0,
  "LimitToPriceRecommended": true
}

Products

Operations