STORM QUERY

Orders

OrderService.QuotationItem

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

Servers

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

Schemas

OrderService.InvoiceItem

Idstring

Id. Key property.

InvoiceIdstring

InvoiceId.

LineNumbernumber(decimal)

LineNumber. Nullable.

StatusIdinteger(int32)

StatusId. Nullable.

PartNostring

PartNo. MaxLength: 50. Nullable.

ExternalPartNostring

ExternalPartNo. MaxLength: 50. Nullable.

ProductNamestring

ProductName. MaxLength: 255. Nullable.

StockUnitOfMeasurementCountnumber(decimal)

StockUnitOfMeasurementCount.

PriceUnitOfMeasurementCountnumber(decimal)

PriceUnitOfMeasurementCount.

WarehouseIdinteger(int32)

WarehouseId. Nullable.

LocationIdinteger(int32)

LocationId. Nullable.

Quantityinteger(int32)

Quantity.

CurrencyIdinteger(int32)

CurrencyId.

VatRatenumber(decimal)

VatRate.

CostUnitnumber(decimal)

CostUnit.

PriceSalenumber(decimal)

PriceSale.

DiscountPercentagenumber(decimal)

DiscountPercentage.

DiscountAmountnumber(decimal)

DiscountAmount.

LineAmountnumber(decimal)

LineAmount.

DeliveryModestring

DeliveryMode. MaxLength: 50. Nullable.

IsPartDeliveryboolean

IsPartDelivery.

DeliveryDatestring(date-time)

DeliveryDate. Nullable.

SalesRepContactIdinteger(int32)

SalesRepContactId. Nullable.

LedgerAccountstring

LedgerAccount. MaxLength: 50. Nullable.

Departmentstring

Department. MaxLength: 10. Nullable.

Centrestring

Centre. MaxLength: 10. Nullable.

TransIdstring

TransId.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

OrderItemIdstring

OrderItemId. Nullable.

PurchaseOrderItemIdstring

PurchaseOrderItemId. Nullable.

LineNumberStringstring

LineNumberString. MaxLength: 50. Nullable.

PriceUnitnumber(decimal)

PriceUnit. Nullable.

Quantity2number(decimal)

Quantity2. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

OrderItemobject(Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderItem)(Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderItem)

{
  "Id": "string",
  "InvoiceId": "string",
  "LineNumber": 0,
  "StatusId": 0,
  "PartNo": "string",
  "ExternalPartNo": "string",
  "ProductName": "string",
  "StockUnitOfMeasurementCount": 0,
  "PriceUnitOfMeasurementCount": 0,
  "WarehouseId": 0,
  "LocationId": 0,
  "Quantity": 0,
  "CurrencyId": 0,
  "VatRate": 0,
  "CostUnit": 0,
  "PriceSale": 0,
  "DiscountPercentage": 0,
  "DiscountAmount": 0,
  "LineAmount": 0,
  "DeliveryMode": "string",
  "IsPartDelivery": true,
  "DeliveryDate": "2019-08-24T14:15:22Z",
  "SalesRepContactId": 0,
  "LedgerAccount": "string",
  "Department": "string",
  "Centre": "string",
  "TransId": "string",
  "Created": "2019-08-24T14:15:22Z",
  "CreatedBy": 0,
  "Updated": "2019-08-24T14:15:22Z",
  "UpdatedBy": 0,
  "OrderItemId": "string",
  "PurchaseOrderItemId": "string",
  "LineNumberString": "string",
  "PriceUnit": 0,
  "Quantity2": 0,
  "ClientId": 0,
  "OrderItem": {
    "Id": "string",
    "OrderId": "string",
    "LineNumber": 0,
    "ParentLineNumber": 0,
    "StatusId": 0,
    "PartNo": "string",
    "ExternalPartNo": "string",
    "ProductName": "string",
    "StockUnitOfMeasurementCount": 0,
    "PriceUnitOfMeasurementCount": 0,
    "WarehouseId": 0,
    "LocationId": 0,
    "QtyOrdered": 0,
    "CurrencyId": 0,
    "VatRate": 0,
    "CostUnit": 0,
    "PriceSale": 0,
    "DiscountPercentage": 0,
    "DiscountAmount": 0,
    "LineAmount": 0,
    "DeliveryMode": "string",
    "IsPartDelivery": true,
    "ExpectedDeliveryDate": "2019-08-24T14:15:22Z",
    "ConfirmedDeliveryDate": "2019-08-24T14:15:22Z",
    "SalesRepContactId": 0,
    "LedgerAccount": "string",
    "Department": "string",
    "Centre": "string",
    "TransId": "string",
    "ExternalStatusText": "string",
    "Created": "2019-08-24T14:15:22Z",
    "CreatedBy": 0,
    "Updated": "2019-08-24T14:15:22Z",
    "UpdatedBy": 0,
    "LineNumberString": "string",
    "PriceRecommended": 0,
    "PriceCatalog": 0,
    "PriceStandard": 0,
    "ClientId": 0,
    "InvoiceItem": [ … ],
    "Infos": [ … ]
  }
}

OrderService.QuotationItem

Idinteger(int32)

Id. Key property.

QuotationIdinteger(int32)

QuotationId.

LineNumberinteger(int32)

LineNumber.

CustomerLineCodestring

CustomerLineCode. MaxLength: 50. Nullable.

StatusIdinteger(int32)

StatusId.

PartNostring

PartNo. MaxLength: 50. Nullable.

ProductNameWhenCreatedstring

ProductNameWhenCreated. MaxLength: 255. Nullable.

BundlePartnostring

BundlePartno. MaxLength: 50. Nullable.

BundleTypeIdinteger(int32)

BundleTypeId. Nullable.

Qtyinteger(int32)

Qty.

OnHandWhenCreatedinteger(int32)

OnHandWhenCreated. Nullable.

PriceSalenumber(decimal)

PriceSale. Nullable.

PriceSaleWhenCreatednumber(decimal)

PriceSaleWhenCreated. Nullable.

PriceListIdinteger(int32)

PriceListId.

PatternIdinteger(int32)

PatternId. Nullable.

VatCodeinteger(int32)

VatCode. Nullable.

VatValuenumber(decimal)

VatValue. Nullable.

PromotionIdSeedstring

PromotionIdSeed. MaxLength: 50. Nullable.

CampaignIdinteger(int32)

CampaignId. Nullable.

SearchStringstring

SearchString. MaxLength: 50. Nullable.

CategoryItemIdinteger(int32)

CategoryItemId. Nullable.

ParentPartnoIdstring

ParentPartnoId. MaxLength: 50. Nullable.

ParentLineNumberinteger(int32)

ParentLineNumber. Nullable.

Commentstring

Comment. MaxLength: 255. Nullable.

ExternalDatastring

ExternalData. Nullable.

RefererIdinteger(int32)

RefererId. Nullable.

RefererUrlstring

RefererUrl. MaxLength: 255. Nullable.

PriceResellernumber(decimal)

PriceReseller. Nullable.

IsLockedboolean

IsLocked. Nullable.

TotalPriceSaleExVatnumber(decimal)

TotalPriceSaleExVat. Nullable.

TotalPriceSaleIncVatnumber(decimal)

TotalPriceSaleIncVat. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy. Nullable.

Updatedstring(date-time)

Updated. Nullable.

ExpectedDeliveryDatestring(date-time)

ExpectedDeliveryDate. Nullable.

RequirementPromotionIdSeedstring

RequirementPromotionIdSeed. MaxLength: 255. Nullable.

IsPriceManualboolean

IsPriceManual. Nullable.

Qty2number(decimal)

Qty2. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

InfosArray of objects(OrderService.QuotationItemInfo)(OrderService.QuotationItemInfo)

Infos.

{
  "Id": 0,
  "QuotationId": 0,
  "LineNumber": 0,
  "CustomerLineCode": "string",
  "StatusId": 0,
  "PartNo": "string",
  "ProductNameWhenCreated": "string",
  "BundlePartno": "string",
  "BundleTypeId": 0,
  "Qty": 0,
  "OnHandWhenCreated": 0,
  "PriceSale": 0,
  "PriceSaleWhenCreated": 0,
  "PriceListId": 0,
  "PatternId": 0,
  "VatCode": 0,
  "VatValue": 0,
  "PromotionIdSeed": "string",
  "CampaignId": 0,
  "SearchString": "string",
  "CategoryItemId": 0,
  "ParentPartnoId": "string",
  "ParentLineNumber": 0,
  "Comment": "string",
  "ExternalData": "string",
  "RefererId": 0,
  "RefererUrl": "string",
  "PriceReseller": 0,
  "IsLocked": true,
  "TotalPriceSaleExVat": 0,
  "TotalPriceSaleIncVat": 0,
  "Created": "2019-08-24T14:15:22Z",
  "CreatedBy": 0,
  "Updated": "2019-08-24T14:15:22Z",
  "ExpectedDeliveryDate": "2019-08-24T14:15:22Z",
  "RequirementPromotionIdSeed": "string",
  "IsPriceManual": true,
  "Qty2": 0,
  "ClientId": 0,
  "Infos": [
    { … }
  ]
}

OrderService.QuotationItemInfo

Idstring

Id. Key property.

QuotationItemIdinteger(int32)

QuotationItemId.

TypeIdinteger(int32)

TypeId.

Valuestring

Value. Nullable.

Updatedstring(date-time)

Updated.

UpdatedByinteger(int32)

UpdatedBy.

ClientIdinteger(int32)

ClientId. Nullable.

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

Orders

Operations