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.
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.
curl -i -X GET \ https://query.storm.io/Query/2.0/Products/Products
Success
Skus.
Categories.
Cultures.
SupplierSkus.
Parametrics.
ParametricMultiple.
Flags.
Families.
Accessories.
Upsell.
Crossell.
VariantTypes.
Files.
Popularities.
ProductRelations.
[ { "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": [ … ] } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Products/ProductCategories
[ { "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 } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Products/SupplierProductSkuClient
[ { "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": { … } } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Products/ProductSkus
Success
Cultures.
PriceLists.
SalesAreas.
OnHands.
StructureItems.
[ { "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": [ … ] } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Products/ProductSkuPriceLists
[ { "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": [ … ] } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Products/Variants
Success
Cultures.
Products.
[ { "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": { … } } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Products/ProductAccessories
[ { "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": [ … ] } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Products/ProductCrossell
[ { "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 } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Products/ProductUpsell
[ { "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": [ … ] } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Products/ProductVariantTypes
[ { "ProductId": 0, "TypeId": 0, "ClientId": 0, "DefaultValue": "string", "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "Cultures": [ … ] } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Products/ProductVariantTypeCultures
[ { "ProductId": 0, "TypeId": 0, "ClientId": 0, "CultureCode": "string", "Value": "string", "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0 } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Products/SupplierProductSkus
Success
SupplierProductSkuClient.
OnHands.
PriceLists.
Info.
[ { "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": [ … ] } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Products/ProductRelations
[ { "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": { … } } ]
curl -i -X GET \ 'https://query.storm.io/Query/2.0/Products/GetDeltaProductSkus?offsetInMinutes=0'
curl -i -X GET \ 'https://query.storm.io/Query/2.0/Products/GetDeltaProductSkuOnHands?offsetInMinutes=0'
curl -i -X GET \ 'https://query.storm.io/Query/2.0/Products/GetDeltaProductSkuPriceLists?offsetInMinutes=0'