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/Application/ApplicationCountries
[ { "ApplicationId": 0, "CountryId": 0, "IsPrimary": true, "IsActive": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "ClientId": 0 } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/ApplicationCultures
[ { "ApplicationId": 0, "CultureCode": "string", "IsPrimary": true, "IsActive": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "ClientId": 0 } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/ApplicationPriceLists
[ { "ApplicationId": 0, "PriceListId": 0, "IsPrimary": true, "IsActive": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "IsEditable": true, "ClientId": 0, "IsFavorite": true, "PriceList": { … } } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/ApplicationSalesAreas
[ { "ApplicationId": 0, "SalesAreaId": 0, "IsPrimary": true, "IsActive": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "ClientId": 0 } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/ApplicationRoles
[ { "Id": 0, "ApplicationId": 0, "ClientId": 0, "DefaultName": "string", "DefaultDescription": "string", "ReplacesApplicationRoleId": 0, "IsActive": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "IsDefault": true, "Code": "string", "Cultures": [ … ] } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/Categories
Success
Cultures.
SalesAreas.
Parametrics.
[ { "Id": 0, "ClientId": 0, "Code": "string", "DefaultName": "string", "DefaultDescription": "string", "DefaultSynonyms": "string", "DefaultImagePath": "string", "UnspcCode": "string", "BusinessArea": "string", "DefaultCommodityCode": "string", "DefaultIntegrationPartNo": "string", "DefaultTrackingCodeTypeId": 0, "FreightClassId": 0, "DefaultGrossWeight": 0, "DefaultNetWeight": 0, "DefaultUnitOfMeasurementId": 0, "DefaultPackageId": 0, "DefaultIsReturnable": true, "DefaultIsDropShipOnly": true, "InsuranceCurrencyId": 0, "InsuranceStartPrice": 0, "InsuranceRunningPercentage": 0, "PopulationRuleId": 0, "HideInTopList": true, "PhoneNumber": "string", "IsActive": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "CompetitivePricingMinPercentage": 0, "CompetitivePricingTargetPercentage": 0, "DefaultVariantGroupId": 0, "DefaultRecommendedSalesQty": 0, "ImageKey": "string", "DefaultFullName": "string", "StructureSortOrder": "string", "DefaultStockDisplayBreakPoint": 0, "DefaultIsRecommendedSalesQtyFixed": true, "DefaultIsRecurringOrderable": true, "Cultures": [ … ], "SalesAreas": [ … ], "Parametrics": [ … ] } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/CategoryHierarchy
[ { "CategoryId": 0, "ParentCategoryId": 0, "Hierarchy": 0, "Category": { … }, "ParentCategory": { … } } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/CategoryStructures
[ { "Id": 0, "DefaultName": "string", "DefaultDescription": "string", "TypeId": 0, "IsPrimary": true, "IsActive": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "Items": [ … ] } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/CategoryStructureItems
[ { "Id": 0, "StructureId": 0, "UseCategoryName": true, "CategoryId": 0, "StructureLevel": 0, "ParentItemId": 0, "IsParent": true, "IsDisplayOnly": true, "SortOrder": 0, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "Key": "string", "Category": { … }, "Structure": { … } } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/ClientCultures
[ { "CultureCode": "string", "ClientId": 0, "IsPrimary": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "Collation": "string" } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/ClientManufacturers
[ { "ManufacturerId": 0, "ClientId": 0, "ManufacturerCode": "string", "Name": "string", "IsActive": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "UniqueUrlName": "string", "IsUniqueUrlNameManuallyMaintained": true, "Manufacturer": { … }, "Info": { … } } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/SalesAreas
[ { "SalesAreaId": 0, "ClientId": 0, "IsPrimary": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "Code": "string" } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/ClientSuppliers
Success
Warehouses.
WarehouseLocations.
Infos.
[ { "SupplierId": 0, "ClientId": 0, "SupplierCodePrefix": "string", "SupplierCode": "string", "Name": "string", "IsActive": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "Supplier": { … }, "Warehouses": [ … ], "WarehouseLocations": [ … ], "Info": { … }, "Infos": [ … ] } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/ClientCurrencies
[ { "CurrencyId": 0, "ClientId": 0, "ExchangeRate": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0 } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/CustomerInfoTypes
[ { "Id": 0, "ClientId": 0, "GroupId": 0, "DefaultName": "string", "DefaultDescription": "string", "SortOrder": 0, "IsActive": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "Code": "string", "Cultures": [ … ] } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/Families
[ { "Id": 0, "ClientId": 0, "Code": "string", "DefaultName": "string", "DefaultDescription": "string", "DefaultImagePath": "string", "DefaultThumbnailImagePath": "string", "DefaultCampaignImagePath": "string", "DefaultLargeImagePath": "string", "IsActive": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "ImageKey": "string", "Cultures": [ … ] } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/FileInfos
[ { "FileId": 0, "ClientId": 0, "Code": "string", "SortOrder": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0 } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/OrderInfoTypes
[ { "Id": 0, "ClientId": 0, "ApplicationId": 0, "Code": "string", "DefaultName": "string", "DefaultDescription": "string", "SortOrder": 0, "IsActive": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "GroupId": 0, "Cultures": [ … ] } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/Parametrics
[ { "Id": 0, "ClientId": 0, "DefaultName": "string", "DefaultDescription": "string", "DefaultUom": "string", "TypeId": 0, "HasListValues": true, "HasMultipleValues": true, "IsVariantType": true, "IsRequired": true, "IsHidden": true, "IsActive": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "Code": "string", "CodeListKey": "string", "IsReadOnly": true, "Editor": "string", "IsFavorite": true, "Cultures": [ … ] } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/ParametricListValues
[ { "Id": 0, "ParametricId": 0, "DefaultVarcharValue": "string", "DefaultDescription": "string", "SortOrder": 0, "IsActive": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "Code": "string", "ImageKey": "string", "ImagePath": "string", "ClientId": 0, "Cultures": [ … ] } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/ParametricMultipleValues
[ { "Id": 0, "ParametricId": 0, "DefaultValue": "string", "DefaultDescription": "string", "SortOrder": 0, "IsActive": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "Code": "string", "ImageKey": "string", "ImagePath": "string", "ClientId": 0, "Cultures": [ … ] } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/ShoppingInfoTypes
[ { "Id": 0, "ClientId": 0, "GroupId": 0, "DefaultName": "string", "DefaultDescription": "string", "DataType": "string", "DefaultValue": "string", "SortOrder": 0, "IsActive": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "Code": "string", "Cultures": [ … ] } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/VariantGroups
Success
Cultures.
GroupTypes.
[ { "Id": 0, "ClientId": 0, "DefaultName": "string", "DefaultDescription": "string", "IsActive": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "Code": "string", "Cultures": [ … ], "GroupTypes": [ … ] } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/VariantTypes
[ { "Id": 0, "ClientId": 0, "DefaultName": "string", "DefaultDescription": "string", "ParametricId": 0, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "Code": "string", "Cultures": [ … ] } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/VariantGroupTypes
[ { "GroupId": 0, "TypeId": 0, "SortOrder": 0, "IsActive": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "ClientId": 0, "Type": { … } } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/ProductFlags
[ { "Id": 0, "ClientId": 0, "TypeId": 0, "GroupId": 0, "DefaultName": "string", "DefaultDescription": "string", "IsManuallyEditable": true, "SortOrder": 0, "IsActive": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "Code": "string", "Cultures": [ … ], "Group": { … } } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/ClientPriceLists
[ { "PriceListId": 0, "ClientId": 0, "Name": "string", "Description": "string", "ImagePath": "string", "Agreement": "string", "StartDate": "2019-08-24T14:15:22Z", "EndDate": "2019-08-24T14:15:22Z", "CurrencyId": 0, "DefaultPriceRuleId": 0, "DefaultPriceRuleValue": 0, "DefaultSupplementChargePercentage": 0, "DefaultKickbackPercentage": 0, "DefaultMinimumProductMarginPercentage": 0, "ParentPriceListId": 0, "PopulationRuleId": 0, "ChosenWarehouseId": 0, "ChosenLocationId": 0, "IsErpUpdateable": true, "IsErpIntegrated": true, "IsPrimary": true, "IsPublic": true, "IsLimitedToStock": true, "IsBid": true, "IsStako": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "ImageKey": "string", "TypeId": 0, "ImageExtension": "string", "DefaultSupplementCharge": 0, "DefaultLimitToPriceRecommended": true, "IsVirtual": true, "SalesAreaId": 0, "InheritStructureCalculationRule": 0, "PriceList": { … } } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/ClientWarehouses
[ { "WarehouseId": 0, "ClientId": 0, "TypeId": 0, "Code": "string", "Name": "string", "IsStandard": true, "StandardLeadTimeDayCount": 0, "FreightCost": 0, "CostBlock": 0, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "Locations": [ … ] } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/ProductRelationTypes
[ { "Id": 0, "ClientId": 0, "Code": "string", "DefaultName": "string", "DefaultDescription": "string", "IsBidirectional": true, "IsActive": true, "SortOrder": 0, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "Cultures": [ … ] } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/ProductInfoTypes
[ { "Id": 0, "ClientId": 0, "GroupId": 0, "DefaultName": "string", "DefaultDescription": "string", "SortOrder": 0, "IsActive": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "Code": "string", "Cultures": [ … ] } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/SupplierCategoryMappings
[ { "CategorySupplierId": 0, "Code": "string", "CategoryId": 0, "CategoryName": "string", "ProductCount": 0, "IsMapped": true, "ClientId": 0, "SupplierId": 0, "IsActive": true } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/SupplierManufacturerMappings
[ { "ManufacturerSupplierId": 0, "ClientId": 0, "SupplierId": 0, "Code": "string", "ProductCount": 0, "IsActive": true } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Application/ClientDivisions
Success
Applications.
Infos.
PriceLists.
Warehouses.
Cultures.
[ { "Id": 0, "ClientId": 0, "DivisionCode": "string", "DefaultName": "string", "DefaultGroupName": "string", "DefaultSubGroupName": "string", "DefaultDescription": "string", "DefaultImagePath": "string", "IsPublic": true, "IsActive": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "Key": "string", "ImageKey": "string", "DefaultUniqueUrlName": "string", "Latitude": "string", "Longitude": "string", "EmailAddress": "string", "PhoneNumber": "string", "FaxNumber": "string", "AddressLine1": "string", "AddressLine2": "string", "ZipCode": "string", "City": "string", "Region": "string", "CountryId": 0, "OpenHoursWeekday": "string", "OpenHoursSaturday": "string", "OpenHoursSunday": "string", "Applications": [ … ], "Infos": [ … ], "PriceLists": [ … ], "Warehouses": [ … ], "Cultures": [ … ] } ]