STORM QUERY

Products

Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSkuOnHand

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

Servers

https://query.storm.io/Query/2.0/

Schemas

Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSkuInfo

PartNostring

PartNo. MaxLength: 50. Key property.

SupplierIdinteger(int32)

SupplierId. Key property.

Codestring

Code. MaxLength: 50. Key property.

Valuestring

Value. MaxLength: 255. Nullable.

Updatedstring(date-time)

Updated.

UpdatedByinteger(int32)

UpdatedBy.

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

Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSkuOnHand

PartNostring

PartNo. MaxLength: 50. Key property.

SupplierIdinteger(int32)

SupplierId. Key property.

WarehouseIdinteger(int32)

WarehouseId. Nullable. Key property.

LocationIdinteger(int32)

LocationId. Key property.

OnHandValuenumber(decimal)

OnHandValue.

OnHandLastCheckedstring(date-time)

OnHandLastChecked. Nullable.

OnHandLastUpdatedstring(date-time)

OnHandLastUpdated. Nullable.

OnHandLastUpdatedByinteger(int32)

OnHandLastUpdatedBy. Nullable.

IncomingValuenumber(decimal)

IncomingValue. Nullable.

IncomingLastCheckedstring(date-time)

IncomingLastChecked. Nullable.

IncomingLastUpdatedstring(date-time)

IncomingLastUpdated. Nullable.

IncomingLastUpdatedByinteger(int32)

IncomingLastUpdatedBy. Nullable.

NextDeliveryDatestring(date-time)

NextDeliveryDate. Nullable.

NextDeliveryLastCheckedstring(date-time)

NextDeliveryLastChecked. Nullable.

NextDeliveryLastUpdatedstring(date-time)

NextDeliveryLastUpdated. Nullable.

NextDeliveryLastUpdatedByinteger(int32)

NextDeliveryLastUpdatedBy. Nullable.

IsReturnableboolean

IsReturnable. Nullable.

LeadTimeDayCountinteger(int32)

LeadTimeDayCount. Nullable.

IsActiveboolean

IsActive.

StoppedDatestring(date-time)

StoppedDate. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ExternalStockValuenumber(decimal)

ExternalStockValue. Nullable.

PackageValuenumber(decimal)

PackageValue.

MinimumOrderValuenumber(decimal)

MinimumOrderValue.

ClientIdinteger(int32)

ClientId. Nullable.

Skuobject(Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSku)(Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSku)

Warehouseobject(ProductService.Warehouse)(ProductService.Warehouse)

Locationsobject(ProductService.WarehouseLocation)(ProductService.WarehouseLocation)

{
  "PartNo": "string",
  "SupplierId": 0,
  "WarehouseId": 0,
  "LocationId": 0,
  "OnHandValue": 0,
  "OnHandLastChecked": "2019-08-24T14:15:22Z",
  "OnHandLastUpdated": "2019-08-24T14:15:22Z",
  "OnHandLastUpdatedBy": 0,
  "IncomingValue": 0,
  "IncomingLastChecked": "2019-08-24T14:15:22Z",
  "IncomingLastUpdated": "2019-08-24T14:15:22Z",
  "IncomingLastUpdatedBy": 0,
  "NextDeliveryDate": "2019-08-24T14:15:22Z",
  "NextDeliveryLastChecked": "2019-08-24T14:15:22Z",
  "NextDeliveryLastUpdated": "2019-08-24T14:15:22Z",
  "NextDeliveryLastUpdatedBy": 0,
  "IsReturnable": true,
  "LeadTimeDayCount": 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,
  "ExternalStockValue": 0,
  "PackageValue": 0,
  "MinimumOrderValue": 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": [ … ]
  },
  "Warehouse": {
    "Id": 0,
    "DefaultName": "string",
    "IsActive": true,
    "Created": "2019-08-24T14:15:22Z",
    "CreatedBy": 0,
    "Updated": "2019-08-24T14:15:22Z",
    "UpdatedBy": 0
  },
  "Locations": {
    "Id": 0,
    "DefaultName": "string",
    "IsActive": true,
    "Created": "2019-08-24T14:15:22Z",
    "CreatedBy": 0,
    "Updated": "2019-08-24T14:15:22Z",
    "UpdatedBy": 0
  }
}

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
  }
}

Products

Operations