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

OrderService.DeliveryNoteItem

Idstring

Id. Key property.

DeliveryNoteIdstring

DeliveryNoteId.

LineNumbernumber(decimal)

LineNumber. Nullable.

PartNostring

PartNo. MaxLength: 50. Nullable.

ExternalPartNostring

ExternalPartNo. MaxLength: 50. Nullable.

ProductNamestring

ProductName. MaxLength: 255. Nullable.

StockUnitOfMeasurementCountnumber(decimal)

StockUnitOfMeasurementCount.

PriceUnitOfMeasurementCountnumber(decimal)

PriceUnitOfMeasurementCount.

QtyOrderednumber(decimal)

QtyOrdered.

Quantitynumber(decimal)

Quantity.

QtyBackOrderednumber(decimal)

QtyBackOrdered.

IsPartDeliveryboolean

IsPartDelivery.

SalesRepContactIdinteger(int32)

SalesRepContactId. Nullable.

VatRatenumber(decimal)

VatRate.

ValueMstnumber(decimal)

ValueMst.

NoteTextstring

NoteText. MaxLength: 255. Nullable.

Departmentstring

Department. MaxLength: 10. Nullable.

Centrestring

Centre. MaxLength: 10. Nullable.

TransIdinteger(int32)

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.

ClientIdinteger(int32)

ClientId. Nullable.

PurchaseOrderItemobject(OrderService.PurchaseOrderItem)(OrderService.PurchaseOrderItem)
{ "Id": "string", "DeliveryNoteId": "string", "LineNumber": 0, "PartNo": "string", "ExternalPartNo": "string", "ProductName": "string", "StockUnitOfMeasurementCount": 0, "PriceUnitOfMeasurementCount": 0, "QtyOrdered": 0, "Quantity": 0, "QtyBackOrdered": 0, "IsPartDelivery": true, "SalesRepContactId": 0, "VatRate": 0, "ValueMst": 0, "NoteText": "string", "Department": "string", "Centre": "string", "TransId": 0, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "OrderItemId": "string", "PurchaseOrderItemId": "string", "LineNumberString": "string", "ClientId": 0, "PurchaseOrderItem": { "Id": "string", "PurchaseOrderId": "string", "LineNumber": 0, "StatusId": 0, "PartNo": "string", "ExternalPartNo": "string", "ProductName": "string", "StockUnitOfMeasurementCount": 0, "PriceUnitOfMeasurementCount": 0, "WarehouseId": 0, "LocationId": 0, "QtyOrdered": 0, "CurrencyId": 0, "VatCodeId": 0, "PriceSale": 0, "LineAmount": 0, "DeliveryMode": "string", "IsPartDelivery": true, "ExpectedDeliveryDate": "2019-08-24T14:15:22Z", "ConfirmedDeliveryDate": "2019-08-24T14:15:22Z", "LedgerAccount": "string", "Department": "string", "Centre": "string", "SupplierLineReference": "string", "OrderTransId": "string", "TransId": "string", "Comment": "string", "DeliveryMark": "string", "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "RowId": "string", "QtyOriginallyOrdered": 0, "QtyDelivered": 0, "RequestedDeliveryDate": "2019-08-24T14:15:22Z", "OrderItemId": "string", "LineNumberString": "string", "ClientProductSkuTypeId": 0, "EndUserCode": "string", "AgreementCode": "string", "InternalComment": "string", "SupplierStatusId": 0, "ClientId": 0, "DeliveryNoteItem": [] } }

OrderService.Address

Idstring

Id. Key property.

TypeIdinteger(int32)

TypeId. Nullable.

Namestring

Name. MaxLength: 100. Nullable.

Attentionstring

Attention. MaxLength: 100. Nullable.

CareOfstring

CareOf. MaxLength: 100. Nullable.

Line1string

Line1. MaxLength: 255. Nullable.

Line2string

Line2. MaxLength: 255. Nullable.

ZipCodestring

ZipCode. MaxLength: 50. Nullable.

Citystring

City. MaxLength: 50. Nullable.

Regionstring

Region. MaxLength: 50. Nullable.

CountryIdinteger(int32)

CountryId. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

RowIdstring

RowId. MaxLength: 8. Nullable.

EmailAddressstring

EmailAddress. MaxLength: 255. Nullable.

PhoneNumberstring

PhoneNumber. MaxLength: 50. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

ShippingPhoneNumberstring

ShippingPhoneNumber. MaxLength: 50. Nullable.

Glnstring

Gln. MaxLength: 50. Nullable.

{ "Id": "string", "TypeId": 0, "Name": "string", "Attention": "string", "CareOf": "string", "Line1": "string", "Line2": "string", "ZipCode": "string", "City": "string", "Region": "string", "CountryId": 0, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "RowId": "string", "EmailAddress": "string", "PhoneNumber": "string", "ClientId": 0, "ShippingPhoneNumber": "string", "Gln": "string" }

OrderService.DeliveryNotePackage

Idstring

Id. Key property.

DeliveryNoteIdstring

DeliveryNoteId.

ShippingNostring

ShippingNo. MaxLength: 255. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

StatusIdinteger(int32)

StatusId.

ClientIdinteger(int32)

ClientId. Nullable.

{ "Id": "string", "DeliveryNoteId": "string", "ShippingNo": "string", "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "StatusId": 0, "ClientId": 0 }

Orders

Operations