STORM QUERY
/
Products
/
Schemas
/
Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSku

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
Languages
Servers

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

Schemas

Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductVariantTypeCulture

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.

{
  "ProductId": 0,
  "TypeId": 0,
  "ClientId": 0,
  "CultureCode": "string",
  "Value": "string",
  "Updated": "2019-08-24T14:15:22Z",
  "UpdatedBy": 0
}

Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSku

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.

{
  "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": [
    { … }
  ]
}

Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductRelation

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)
{
  "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": {
    "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": [ … ]
  }
}

Products

Operations