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
Languages
Servers
https://query.storm.io/Query/2.0/

Products

Operations

Get Product

Request

Get Product

curl -i -X GET \
  https://query.storm.io/Query/2.0/Products/Products

Responses

Success

Bodyapplication/jsonArray [
Idinteger(int32)

Id. Key property.

ClientIdinteger(int32)

ClientId.

ManufacturerIdinteger(int32)

ManufacturerId.

ManufacturerPartNostring

ManufacturerPartNo. MaxLength: 50. Nullable.

DefaultNamestring

DefaultName. MaxLength: 255. Nullable.

DefaultSubHeaderstring

DefaultSubHeader. MaxLength: 255. Nullable.

DefaultSubDescriptionstring

DefaultSubDescription. Nullable.

DefaultDescriptionHeaderstring

DefaultDescriptionHeader. MaxLength: 255. Nullable.

DefaultDescriptionstring

DefaultDescription. Nullable.

DefaultImagePathstring

DefaultImagePath. MaxLength: 255. Nullable.

DefaultThumbnailImagePathstring

DefaultThumbnailImagePath. MaxLength: 255. Nullable.

DefaultCampaignImagePathstring

DefaultCampaignImagePath. MaxLength: 255. Nullable.

DefaultLargeImagePathstring

DefaultLargeImagePath. MaxLength: 255. Nullable.

DefaultSynonymsstring

DefaultSynonyms. MaxLength: 500. Nullable.

SortOrderValueinteger(int32)

SortOrderValue. Nullable.

AssortmentIdinteger(int32)

AssortmentId. Nullable.

AssortmentLastUpdatedstring(date-time)

AssortmentLastUpdated. Nullable.

AssortmentLastUpdatedByinteger(int32)

AssortmentLastUpdatedBy. Nullable.

IsVariantboolean

IsVariant.

VariantIdinteger(int32)

VariantId. Nullable.

Aliasstring

Alias. MaxLength: 255. Nullable.

DefaultTitlestring

DefaultTitle. MaxLength: 255. Nullable.

DefaultTagsstring

DefaultTags. Nullable.

DefaultMetaTagsstring

DefaultMetaTags. Nullable.

DefaultMetaDescriptionstring

DefaultMetaDescription. Nullable.

HideInTopListboolean

HideInTopList. Nullable.

IsActiveboolean

IsActive.

StoppedDatestring(date-time)

StoppedDate. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

InsuranceCurrencyIdinteger(int32)

InsuranceCurrencyId. Nullable.

InsuranceStartPricenumber(decimal)

InsuranceStartPrice. Nullable.

InsuranceRunningPercentagenumber(decimal)

InsuranceRunningPercentage. Nullable.

Keystring(guid)

Key.

ManufacturerPartNo2string

ManufacturerPartNo2. MaxLength: 50. Nullable.

ImageKeystring(guid)

ImageKey. Nullable.

DefaultUniqueUrlNamestring

DefaultUniqueUrlName. MaxLength: 500. Nullable.

StockDisplayBreakPointinteger(int32)

StockDisplayBreakPoint. Nullable.

IsDangerousGoodsboolean

IsDangerousGoods.

Codestring

Code. MaxLength: 50. Nullable.

IsRecurringOrderableboolean

IsRecurringOrderable. Nullable.

DefaultExternalDescriptionstring

DefaultExternalDescription. Nullable.

UnspscCodestring

UnspscCode. MaxLength: 50. Nullable.

TranslationRequestedstring(date-time)

TranslationRequested. Nullable.

TranslationRequestedByinteger(int32)

TranslationRequestedBy. Nullable.

SkusArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSku)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSku)

Skus.

CategoriesArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductCategory)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductCategory)

Categories.

CulturesArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductCulture)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductCulture)

Cultures.

SupplierSkusArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSkuClient)(Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSkuClient)

SupplierSkus.

ParametricsArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductParametric)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductParametric)

Parametrics.

ParametricMultipleArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductParametricMultiple)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductParametricMultiple)

ParametricMultiple.

Variantobject(Enferno.Storm.Query.Api.DataContexts.ProductModel.Variant)(Enferno.Storm.Query.Api.DataContexts.ProductModel.Variant)
FlagsArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ClientProductFlag)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ClientProductFlag)

Flags.

FamiliesArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductFamily)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductFamily)

Families.

AccessoriesArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductAccessory)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductAccessory)

Accessories.

UpsellArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductUpsell)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductUpsell)

Upsell.

CrossellArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductCrossell)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductCrossell)

Crossell.

VariantTypesArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductVariantType)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductVariantType)

VariantTypes.

FilesArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductFile)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductFile)

Files.

PopularitiesArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductPopularity)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductPopularity)

Popularities.

ProductRelationsArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductRelation)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductRelation)

ProductRelations.

]
Response
application/json
[ { "Id": 0, "ClientId": 0, "ManufacturerId": 0, "ManufacturerPartNo": "string", "DefaultName": "string", "DefaultSubHeader": "string", "DefaultSubDescription": "string", "DefaultDescriptionHeader": "string", "DefaultDescription": "string", "DefaultImagePath": "string", "DefaultThumbnailImagePath": "string", "DefaultCampaignImagePath": "string", "DefaultLargeImagePath": "string", "DefaultSynonyms": "string", "SortOrderValue": 0, "AssortmentId": 0, "AssortmentLastUpdated": "2019-08-24T14:15:22Z", "AssortmentLastUpdatedBy": 0, "IsVariant": true, "VariantId": 0, "Alias": "string", "DefaultTitle": "string", "DefaultTags": "string", "DefaultMetaTags": "string", "DefaultMetaDescription": "string", "HideInTopList": true, "IsActive": true, "StoppedDate": "2019-08-24T14:15:22Z", "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "InsuranceCurrencyId": 0, "InsuranceStartPrice": 0, "InsuranceRunningPercentage": 0, "Key": "string", "ManufacturerPartNo2": "string", "ImageKey": "string", "DefaultUniqueUrlName": "string", "StockDisplayBreakPoint": 0, "IsDangerousGoods": true, "Code": "string", "IsRecurringOrderable": true, "DefaultExternalDescription": "string", "UnspscCode": "string", "TranslationRequested": "2019-08-24T14:15:22Z", "TranslationRequestedBy": 0, "Skus": [], "Categories": [], "Cultures": [], "SupplierSkus": [], "Parametrics": [], "ParametricMultiple": [], "Variant": {}, "Flags": [], "Families": [], "Accessories": [], "Upsell": [], "Crossell": [], "VariantTypes": [], "Files": [], "Popularities": [], "ProductRelations": [] } ]

Get ProductCategory

Request

Get ProductCategory

curl -i -X GET \
  https://query.storm.io/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://query.storm.io/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://query.storm.io/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": [] } ]

Get ProductSkuPricelist

Request

Get ProductSkuPricelist

curl -i -X GET \
  https://query.storm.io/Query/2.0/Products/ProductSkuPriceLists

Responses

Success

Bodyapplication/jsonArray [
PartNostring

PartNo. MaxLength: 50. Key property.

PriceListIdinteger(int32)

PriceListId. Key property.

QtyBreakinteger(int32)

QtyBreak. Key property.

ClientIdinteger(int32)

ClientId.

CurrencyIdinteger(int32)

CurrencyId.

PriceSalenumber(decimal)

PriceSale.

PriceSaleLastUpdatedstring(date-time)

PriceSaleLastUpdated. Nullable.

PriceSaleLastUpdatedByinteger(int32)

PriceSaleLastUpdatedBy. Nullable.

PriceRuleIdinteger(int32)

PriceRuleId. Nullable.

PriceRuleValuenumber(decimal)

PriceRuleValue. Nullable.

CostPurchasenumber(decimal)

CostPurchase.

CostPurchaseLastUpdatedstring(date-time)

CostPurchaseLastUpdated. Nullable.

CostPurchaseLastUpdatedByinteger(int32)

CostPurchaseLastUpdatedBy. Nullable.

CostUnitnumber(decimal)

CostUnit.

CostUnitLastUpdatedstring(date-time)

CostUnitLastUpdated. Nullable.

CostUnitLastUpdatedByinteger(int32)

CostUnitLastUpdatedBy. Nullable.

SupplementChargePercentagenumber(decimal)

SupplementChargePercentage. Nullable.

PriceStandardnumber(decimal)

PriceStandard. Nullable.

PriceRecommendednumber(decimal)

PriceRecommended. Nullable.

PriceRecommendedLastUpdatedstring(date-time)

PriceRecommendedLastUpdated. Nullable.

PriceRecommendedLastUpdatedByinteger(int32)

PriceRecommendedLastUpdatedBy. Nullable.

PricePreviousnumber(decimal)

PricePrevious. Nullable.

PricePreviousLastUpdatedstring(date-time)

PricePreviousLastUpdated. Nullable.

PricePreviousLastUpdatedByinteger(int32)

PricePreviousLastUpdatedBy. Nullable.

PriceCatalognumber(decimal)

PriceCatalog. Nullable.

PriceCatalogLastUpdatedstring(date-time)

PriceCatalogLastUpdated. Nullable.

PriceCatalogLastUpdatedByinteger(int32)

PriceCatalogLastUpdatedBy. Nullable.

IsPriceDiscountableboolean

IsPriceDiscountable.

ChosenSupplierIdinteger(int32)

ChosenSupplierId. Nullable.

ChosenSupplierPartNostring

ChosenSupplierPartNo. MaxLength: 50. Nullable.

ChosenSupplierPriceListIdinteger(int32)

ChosenSupplierPriceListId. Nullable.

ChosenSupplierQtyBreakinteger(int32)

ChosenSupplierQtyBreak. Nullable.

IsChosenSupplierLockedboolean

IsChosenSupplierLocked.

IsActiveboolean

IsActive.

StoppedDatestring(date-time)

StoppedDate. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

LastCheckedstring(date-time)

LastChecked. Nullable.

MinimumMarginPercentagenumber(decimal)

MinimumMarginPercentage. Nullable.

PriceRuleLastUpdatedstring(date-time)

PriceRuleLastUpdated. Nullable.

PriceRuleLastUpdatedByinteger(int32)

PriceRuleLastUpdatedBy. Nullable.

PricingIdinteger(int32)

PricingId. Nullable.

SupplementChargenumber(decimal)

SupplementCharge. Nullable.

LimitToPriceRecommendedboolean

LimitToPriceRecommended. Nullable.

IsActiveLastUpdatedstring(date-time)

IsActiveLastUpdated. Nullable.

IsActiveLastUpdatedByinteger(int32)

IsActiveLastUpdatedBy. Nullable.

Skuobject(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSku)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSku)
InfoArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuPriceListInfo)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuPriceListInfo)

Info.

]
Response
application/json
[ { "PartNo": "string", "PriceListId": 0, "QtyBreak": 0, "ClientId": 0, "CurrencyId": 0, "PriceSale": 0, "PriceSaleLastUpdated": "2019-08-24T14:15:22Z", "PriceSaleLastUpdatedBy": 0, "PriceRuleId": 0, "PriceRuleValue": 0, "CostPurchase": 0, "CostPurchaseLastUpdated": "2019-08-24T14:15:22Z", "CostPurchaseLastUpdatedBy": 0, "CostUnit": 0, "CostUnitLastUpdated": "2019-08-24T14:15:22Z", "CostUnitLastUpdatedBy": 0, "SupplementChargePercentage": 0, "PriceStandard": 0, "PriceRecommended": 0, "PriceRecommendedLastUpdated": "2019-08-24T14:15:22Z", "PriceRecommendedLastUpdatedBy": 0, "PricePrevious": 0, "PricePreviousLastUpdated": "2019-08-24T14:15:22Z", "PricePreviousLastUpdatedBy": 0, "PriceCatalog": 0, "PriceCatalogLastUpdated": "2019-08-24T14:15:22Z", "PriceCatalogLastUpdatedBy": 0, "IsPriceDiscountable": true, "ChosenSupplierId": 0, "ChosenSupplierPartNo": "string", "ChosenSupplierPriceListId": 0, "ChosenSupplierQtyBreak": 0, "IsChosenSupplierLocked": true, "IsActive": true, "StoppedDate": "2019-08-24T14:15:22Z", "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "LastChecked": "2019-08-24T14:15:22Z", "MinimumMarginPercentage": 0, "PriceRuleLastUpdated": "2019-08-24T14:15:22Z", "PriceRuleLastUpdatedBy": 0, "PricingId": 0, "SupplementCharge": 0, "LimitToPriceRecommended": true, "IsActiveLastUpdated": "2019-08-24T14:15:22Z", "IsActiveLastUpdatedBy": 0, "Sku": {}, "Info": [] } ]

Get Variant

Request

Get Variant

curl -i -X GET \
  https://query.storm.io/Query/2.0/Products/Variants

Responses

Success

Bodyapplication/jsonArray [
Idinteger(int32)

Id. Key property.

ClientIdinteger(int32)

ClientId.

DefaultNamestring

DefaultName. MaxLength: 255. Nullable.

DefaultImagePathstring

DefaultImagePath. MaxLength: 255. Nullable.

DefaultThumbnailImagePathstring

DefaultThumbnailImagePath. MaxLength: 255. Nullable.

DefaultCampaignImagePathstring

DefaultCampaignImagePath. MaxLength: 255. Nullable.

DefaultLargeImagePathstring

DefaultLargeImagePath. MaxLength: 255. Nullable.

GroupIdinteger(int32)

GroupId. Nullable.

Aliasstring

Alias. MaxLength: 255. Nullable.

DefaultTitlestring

DefaultTitle. MaxLength: 255. Nullable.

DefaultTagsstring

DefaultTags. Nullable.

DefaultMetaTagsstring

DefaultMetaTags. Nullable.

DefaultMetaDescriptionstring

DefaultMetaDescription. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ImageKeystring(guid)

ImageKey. Nullable.

Codestring

Code. MaxLength: 50. Nullable.

DefaultUniqueUrlNamestring

DefaultUniqueUrlName. MaxLength: 500. Nullable.

Keystring(guid)

Key.

CulturesArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.VariantCulture)(Enferno.Storm.Query.Api.DataContexts.ProductModel.VariantCulture)

Cultures.

ProductsArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.Product)(Enferno.Storm.Query.Api.DataContexts.ProductModel.Product)

Products.

VariantGroupobject(ProductService.ProductVariantGroup)(ProductService.ProductVariantGroup)
]
Response
application/json
[ { "Id": 0, "ClientId": 0, "DefaultName": "string", "DefaultImagePath": "string", "DefaultThumbnailImagePath": "string", "DefaultCampaignImagePath": "string", "DefaultLargeImagePath": "string", "GroupId": 0, "Alias": "string", "DefaultTitle": "string", "DefaultTags": "string", "DefaultMetaTags": "string", "DefaultMetaDescription": "string", "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "ImageKey": "string", "Code": "string", "DefaultUniqueUrlName": "string", "Key": "string", "Cultures": [], "Products": [], "VariantGroup": {} } ]

Get ProductAccessory

Request

Get ProductAccessory

curl -i -X GET \
  https://query.storm.io/Query/2.0/Products/ProductAccessories

Responses

Success

Bodyapplication/jsonArray [
ProductIdinteger(int32)

ProductId. Key property.

ClientIdinteger(int32)

ClientId.

AccessoryProductIdinteger(int32)

AccessoryProductId.

TypeIdinteger(int32)

TypeId.

SortOrderinteger(int32)

SortOrder. Nullable.

PopulationRuleIdinteger(int32)

PopulationRuleId. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

IsProductVariantUniqueboolean

IsProductVariantUnique.

IsAccessoryProductVariantUniqueboolean

IsAccessoryProductVariantUnique.

CulturesArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductAccessoryCulture)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductAccessoryCulture)

Cultures.

]
Response
application/json
[ { "ProductId": 0, "ClientId": 0, "AccessoryProductId": 0, "TypeId": 0, "SortOrder": 0, "PopulationRuleId": 0, "IsActive": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "IsProductVariantUnique": true, "IsAccessoryProductVariantUnique": true, "Cultures": [] } ]

Get ProductCrossell

Request

Get ProductCrossell

curl -i -X GET \
  https://query.storm.io/Query/2.0/Products/ProductCrossell

Responses

Success

Bodyapplication/jsonArray [
ProductIdinteger(int32)

ProductId. Key property.

ClientIdinteger(int32)

ClientId.

CrossellProductIdinteger(int32)

CrossellProductId.

SortOrderinteger(int32)

SortOrder. Nullable.

PopulationRuleIdinteger(int32)

PopulationRuleId. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

IsProductVariantUniqueboolean

IsProductVariantUnique.

IsCrossellProductVariantUniqueboolean

IsCrossellProductVariantUnique.

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

Get ProductUpsell

Request

Get ProductUpsell

curl -i -X GET \
  https://query.storm.io/Query/2.0/Products/ProductUpsell

Responses

Success

Bodyapplication/jsonArray [
ProductIdinteger(int32)

ProductId. Key property.

ClientIdinteger(int32)

ClientId.

UpsellProductIdinteger(int32)

UpsellProductId.

DefaultDescriptionstring

DefaultDescription. Nullable.

SortOrderinteger(int32)

SortOrder. Nullable.

PopulationRuleIdinteger(int32)

PopulationRuleId. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

IsProductVariantUniqueboolean

IsProductVariantUnique.

IsUpsellProductVariantUniqueboolean

IsUpsellProductVariantUnique.

CulturesArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductUpsellCulture)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductUpsellCulture)

Cultures.

]
Response
application/json
[ { "ProductId": 0, "ClientId": 0, "UpsellProductId": 0, "DefaultDescription": "string", "SortOrder": 0, "PopulationRuleId": 0, "IsActive": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "IsProductVariantUnique": true, "IsUpsellProductVariantUnique": true, "Cultures": [] } ]

Get ProductVariantType

Request

Get ProductVariantType

curl -i -X GET \
  https://query.storm.io/Query/2.0/Products/ProductVariantTypes

Responses

Success

Bodyapplication/jsonArray [
ProductIdinteger(int32)

ProductId. Key property.

TypeIdinteger(int32)

TypeId. Key property.

ClientIdinteger(int32)

ClientId.

DefaultValuestring

DefaultValue. MaxLength: 50. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

CulturesArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductVariantTypeCulture)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductVariantTypeCulture)

Cultures.

]
Response
application/json
[ { "ProductId": 0, "TypeId": 0, "ClientId": 0, "DefaultValue": "string", "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "Cultures": [] } ]

Get ProductVariantTypeCulture

Request

Get ProductVariantTypeCulture

curl -i -X GET \
  https://query.storm.io/Query/2.0/Products/ProductVariantTypeCultures

Responses

Success

Bodyapplication/jsonArray [
ProductIdinteger(int32)

ProductId. Key property.

TypeIdinteger(int32)

TypeId. Key property.

ClientIdinteger(int32)

ClientId.

CultureCodestring

CultureCode. MaxLength: 16. Nullable.

Valuestring

Value. MaxLength: 50. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

]
Response
application/json
[ { "ProductId": 0, "TypeId": 0, "ClientId": 0, "CultureCode": "string", "Value": "string", "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0 } ]

Get SupplierProductSku

Request

Get SupplierProductSku

curl -i -X GET \
  https://query.storm.io/Query/2.0/Products/SupplierProductSkus

Responses

Success

Bodyapplication/jsonArray [
PartNostring

PartNo. MaxLength: 50. Key property.

SupplierIdinteger(int32)

SupplierId. Key property.

Namestring

Name. MaxLength: 500. Nullable.

ManufacturerIdinteger(int32)

ManufacturerId. Nullable.

ManufacturerCodestring

ManufacturerCode. MaxLength: 50. Nullable.

ManufacturerPartNostring

ManufacturerPartNo. MaxLength: 50. Nullable.

CategoryIdinteger(int32)

CategoryId. Nullable.

CategoryCodestring

CategoryCode. MaxLength: 255. Nullable.

CommodityCodestring

CommodityCode. MaxLength: 50. Nullable.

EanCodestring

EanCode. MaxLength: 50. Nullable.

GrossWeightnumber(decimal)

GrossWeight. Nullable.

NetWeightnumber(decimal)

NetWeight. Nullable.

VatCodeIdinteger(int32)

VatCodeId. Nullable.

UnitOfMeasurementIdinteger(int32)

UnitOfMeasurementId.

UnitOfMeasurementCountnumber(decimal)

UnitOfMeasurementCount.

Urlstring

Url. MaxLength: 255. Nullable.

ImagePathstring

ImagePath. MaxLength: 255. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ImagePathLastUpdatedstring(date-time)

ImagePathLastUpdated. Nullable.

IsUsedboolean

IsUsed.

LogisticWidthnumber(decimal)

LogisticWidth. Nullable.

LogisticHeightnumber(decimal)

LogisticHeight. Nullable.

LogisticDepthnumber(decimal)

LogisticDepth. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

ProductIdinteger(int32)

ProductId. Nullable.

SupplierProductSkuClientArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSkuClient)(Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSkuClient)

SupplierProductSkuClient.

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

OnHands.

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

PriceLists.

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

Info.

]
Response
application/json
[ { "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": [] } ]

Get ProductRelation

Request

Get ProductRelation

curl -i -X GET \
  https://query.storm.io/Query/2.0/Products/ProductRelations

Responses

Success

Bodyapplication/jsonArray [
Idinteger(int32)

Id. Key property.

ClientIdinteger(int32)

ClientId.

ProductIdinteger(int32)

ProductId. Nullable.

RelatedProductIdinteger(int32)

RelatedProductId.

TypeIdinteger(int32)

TypeId.

SortOrderinteger(int32)

SortOrder. Nullable.

PopulationRuleIdinteger(int32)

PopulationRuleId. Nullable.

IsProductVariantUniqueboolean

IsProductVariantUnique.

IsRelatedProductVariantUniqueboolean

IsRelatedProductVariantUnique.

DefaultNamestring

DefaultName. MaxLength: 255. Nullable.

DefaultSubHeaderstring

DefaultSubHeader. MaxLength: 255. Nullable.

DefaultSubDescriptionstring

DefaultSubDescription. Nullable.

DefaultDescriptionHeaderstring

DefaultDescriptionHeader. MaxLength: 255. Nullable.

DefaultDescriptionstring

DefaultDescription. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

CulturesArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductRelationCulture)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductRelationCulture)

Cultures.

Productobject(Enferno.Storm.Query.Api.DataContexts.ProductModel.Product)(Enferno.Storm.Query.Api.DataContexts.ProductModel.Product)
]
Response
application/json
[ { "Id": 0, "ClientId": 0, "ProductId": 0, "RelatedProductId": 0, "TypeId": 0, "SortOrder": 0, "PopulationRuleId": 0, "IsProductVariantUnique": true, "IsRelatedProductVariantUnique": true, "DefaultName": "string", "DefaultSubHeader": "string", "DefaultSubDescription": "string", "DefaultDescriptionHeader": "string", "DefaultDescription": "string", "IsActive": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "Cultures": [], "Product": {} } ]

Get ProductSkuBestPrice

Request

Get ProductSkuBestPrice

curl -i -X GET \
  https://query.storm.io/Query/2.0/Products/ProductBestPrices

Responses

Success

Bodyapplication/jsonArray [
PartNostring

PartNo. MaxLength: 50. Key property.

ApplicationIdinteger(int32)

ApplicationId. Key property.

Idinteger(int32)

Id.

QtyBreakinteger(int32)

QtyBreak.

ClientIdinteger(int32)

ClientId.

PriceListIdinteger(int32)

PriceListId.

CurrencyIdinteger(int32)

CurrencyId.

PriceSalenumber(decimal)

PriceSale.

TimeStampstring(date-time)

TimeStamp.

]
Response
application/json
[ { "PartNo": "string", "ApplicationId": 0, "Id": 0, "QtyBreak": 0, "ClientId": 0, "PriceListId": 0, "CurrencyId": 0, "PriceSale": 0, "TimeStamp": "2019-08-24T14:15:22Z" } ]

GetDeltaProductSkus

Request

GetDeltaProductSkus

Query
bindingParameterstring
offsetInMinutesinteger(int32)required
curl -i -X GET \
  'https://query.storm.io/Query/2.0/Products/GetDeltaProductSkus?offsetInMinutes=0'

Responses

Success

Bodyapplication/json
string
Response
application/json
"string"

GetDeltaProductSkuOnHands

Request

GetDeltaProductSkuOnHands

Query
bindingParameterstring
offsetInMinutesinteger(int32)required
curl -i -X GET \
  'https://query.storm.io/Query/2.0/Products/GetDeltaProductSkuOnHands?offsetInMinutes=0'

Responses

Success

Bodyapplication/json
string
Response
application/json
"string"

GetDeltaProductSkuPriceLists

Request

GetDeltaProductSkuPriceLists

Query
bindingParameterstring
offsetInMinutesinteger(int32)required
curl -i -X GET \
  'https://query.storm.io/Query/2.0/Products/GetDeltaProductSkuPriceLists?offsetInMinutes=0'

Responses

Success

Bodyapplication/json
string
Response
application/json
"string"