Skip to content

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://customer-slug.api-se.norce.tech/commerce/query/2.0/

Schemas

Schemas

Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuOnHand

PartNostring

PartNo. MaxLength: 50. Key property.

WarehouseIdinteger(int32)

WarehouseId. Key property.

LocationIdinteger(int32)

LocationId. Key property.

ClientIdinteger(int32)

ClientId.

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.

LeadTimeDayCountinteger(int32)

LeadTimeDayCount. Nullable.

OnOrderValuenumber(decimal)

OnOrderValue. Nullable.

MinimumValuenumber(decimal)

MinimumValue. Nullable.

MaximumValuenumber(decimal)

MaximumValue. Nullable.

IsActiveboolean

IsActive.

StoppedDatestring(date-time)

StoppedDate. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ReservationValuenumber(decimal)

ReservationValue.

IsActiveLastUpdatedstring(date-time)

IsActiveLastUpdated. Nullable.

IsActiveLastUpdatedByinteger(int32)

IsActiveLastUpdatedBy. Nullable.

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

Info.

{ "PartNo": "string", "WarehouseId": 0, "LocationId": 0, "ClientId": 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, "OnOrderValue": 0, "MinimumValue": 0, "MaximumValue": 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, "ReservationValue": 0, "IsActiveLastUpdated": "2019-08-24T14:15:22Z", "IsActiveLastUpdatedBy": 0, "Info": [ {} ] }

Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuOnHandInfo

PartNostring

PartNo. MaxLength: 50. Key property.

WarehouseIdinteger(int32)

WarehouseId. Key property.

LocationIdinteger(int32)

LocationId. Key property.

TypeIdinteger(int32)

TypeId. Key property.

Idstring

Id.

ClientIdinteger(int32)

ClientId.

Valuestring

Value. MaxLength: 255. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

{ "PartNo": "string", "WarehouseId": 0, "LocationId": 0, "TypeId": 0, "Id": "string", "ClientId": 0, "Value": "string", "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0 }

Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductRelationCulture

RelationIdinteger(int32)

RelationId. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Key property.

ClientIdinteger(int32)

ClientId.

Namestring

Name. MaxLength: 255. Nullable.

SubHeaderstring

SubHeader. MaxLength: 255. Nullable.

SubDescriptionstring

SubDescription. Nullable.

DescriptionHeaderstring

DescriptionHeader. MaxLength: 255. Nullable.

Descriptionstring

Description. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ProductRelationobject(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductRelation)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductRelation)
{ "RelationId": 0, "CultureCode": "string", "ClientId": 0, "Name": "string", "SubHeader": "string", "SubDescription": "string", "DescriptionHeader": "string", "Description": "string", "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "ProductRelation": { "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": {} } }

Products

Operations