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/Orders/OrderItems
[ { "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": [ … ] } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Orders/Orders
Success
Items.
Infos.
[ { "Id": "string", "ClientId": 0, "ApplicationId": 0, "QuotationId": 0, "OrderNo": "string", "OrderDate": "2019-08-24T14:15:22Z", "BuyerCompanyCode": "string", "BuyerCompanyId": 0, "BuyerCustomerCode": "string", "BuyerCustomerId": 0, "PayerCompanyCode": "string", "PayerCompanyId": 0, "PayerCustomerCode": "string", "PayerCustomerId": 0, "ResellerCompanyCode": "string", "ResellerCompanyId": 0, "ResellerCustomerCode": "string", "ResellerCustomerId": 0, "GroupCode": "string", "StatusId": 0, "SalesRepContactId": 0, "Source": "string", "DeliveryTerms": "string", "DeliveryMode": "string", "DeliveryDate": "2019-08-24T14:15:22Z", "IsPartDelivery": true, "PaymentTerms": "string", "CurrencyId": 0, "VatRate": 0, "CashDiscount": 0, "LineDiscount": 0, "FreightCost": 0, "OrderFee": 0, "DeliveryAttention": "string", "DeliveryCareOf": "string", "DeliveryAddressLine1": "string", "DeliveryAddressLine2": "string", "DeliveryZipCode": "string", "DeliveryCity": "string", "DeliveryRegion": "string", "DeliveryCountryId": 0, "LedgerAccount": "string", "Department": "string", "Centre": "string", "ExternalPurchaseNo": "string", "SalesCode": "string", "DeliveryMark": "string", "InvoiceMark": "string", "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "PayerCustomerInfoId": "string", "EstimatedDeliveryTime": "2019-08-24T14:15:22Z", "DeliveryTime": "2019-08-24T14:15:22Z", "BuyerCustomerInfoId": "string", "ShipToCustomerInfoId": "string", "ExternalRef": "string", "PaymentMethodId": 0, "DeliveryMethodId": 0, "OrderTypeId": 0, "IsForgotten": true, "ForgottenBy": 0, "ForgottenDate": "2019-08-24T14:15:22Z", "DropPointCustomerInfoId": "string", "DropPointCode": "string", "Quotation": { … }, "Items": [ … ], "Infos": [ … ], "Payer": { … }, "Buyer": { … }, "ShipTo": { … }, "DropPoint": { … } } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Orders/Quotations
Success
Infos.
Addresses.
[ { "Id": 0, "ApplicationId": 0, "SalesContactId": 0, "BuyerAccountKey": "string", "BuyerAccountId": 0, "PayerAccountId": 0, "PayerAccountKey": "string", "StatusId": 0, "IsPrimary": true, "Name": "string", "ValidTo": "2019-08-24T14:15:22Z", "IsDeletable": true, "DeleteDate": "2019-08-24T14:15:22Z", "Comment": "string", "RejectionReasonId": 0, "Modified": "2019-08-24T14:15:22Z", "Browsed": "2019-08-24T14:15:22Z", "PaymentMethodId": 0, "DeliveryMethodId": 0, "IpAddress": "string", "PayerFirstName": "string", "PayerMiddleName": "string", "PayerLastName": "string", "PayerCellPhoneNumber": "string", "PayerEmail": "string", "CurrencyId": 0, "ResellerCustomerId": 0, "IsLocked": true, "DiscountCode": "string", "IsActive": true, "ParentQuotationId": 0, "ClientId": 0, "BuyerCompanyId": 0, "PayerCompanyId": 0, "HasPaymentTransaction": true, "BuyerFirstName": "string", "BuyerMiddleName": "string", "BuyerLastName": "string", "BuyerCellPhoneNumber": "string", "BuyerEmail": "string", "CustomerOrderReference": "string", "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "ReferId": 0, "ReferUrl": "string", "PayerSocialSecurityNumber": "string", "BuyerCustomerId": 0, "PayerCustomerId": 0, "ShipToCustomerId": 0, "RowId": "string", "PickupCode": "string", "AttestedBy": 0, "ModifiedBy": 0, "TypeId": 0, "DoHold": true, "DeliveryMethodCode": "string", "FreightPrice": 0, "Infos": [ … ], "Items": [ … ], "Addresses": [ … ] } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Orders/PurchaseOrders
[ { "Id": "string", "ClientId": 0, "ApplicationId": 0, "PurchaseOrderNo": "string", "PurchaseOrderDate": "2019-08-24T14:15:22Z", "SupplierId": 0, "SupplierCode": "string", "StatusId": 0, "PurchaseRepContactId": 0, "PurchaseRepContactCode": "string", "Source": "string", "DeliveryTerms": "string", "DeliveryMode": "string", "DeliveryDate": "2019-08-24T14:15:22Z", "IsPartDelivery": true, "PaymentTerms": "string", "CurrencyId": 0, "VatCodeId": 0, "CashDiscount": 0, "LineDiscount": 0, "FreightCost": 0, "OrderFee": 0, "DeliveryAttention": "string", "DeliveryCareOf": "string", "DeliveryAddressLine1": "string", "DeliveryAddressLine2": "string", "DeliveryZipCode": "string", "DeliveryCity": "string", "DeliveryRegion": "string", "DeliveryCountryId": 0, "LedgerAccount": "string", "Department": "string", "Centre": "string", "ExternalPurchaseNo": "string", "SalesCode": "string", "DeliveryMark": "string", "InvoiceMark": "string", "Comment": "string", "SellToCustomerCode": "string", "SellToSupplierCustomerCode": "string", "SellToAddressId": "string", "BillToCustomerCode": "string", "BillToSupplierCustomerCode": "string", "BillToAddressId": "string", "ShipToCustomerCode": "string", "ShipToSupplierCustomerCode": "string", "ShipToAddressId": "string", "ShipToEmail": "string", "ShipToPhone": "string", "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "RowId": "string", "BillToCustomerInfoId": "string", "CurrencyCode": "string", "FreightTerms": "string", "InternalComment": "string", "SupplierStatusId": 0, "IsForgotten": true, "ForgottenBy": 0, "ForgottenDate": "2019-08-24T14:15:22Z", "Items": [ … ], "ShipToAddress": { … }, "SellToAddress": { … }, "BillToAddress": { … } } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Orders/DeliveryNotes
[ { "Id": "string", "ClientId": 0, "NoteNo": "string", "SupplierId": 0, "TypeId": 0, "ReferenceOrderId": "string", "BuyerCompanyId": 0, "BuyerCompanyCode": "string", "BuyerCustomerId": 0, "BuyerCustomerCode": "string", "PayerCompanyId": 0, "PayerCompanyCode": "string", "PayerCustomerId": 0, "PayerCustomerCode": "string", "ResellerCompanyId": 0, "ResellerCompanyCode": "string", "ResellerCustomerId": 0, "ResellerCustomerCode": "string", "GroupCode": "string", "DeliveryName": "string", "DeliveryAttention": "string", "DeliveryCareOf": "string", "DeliveryAddressLine1": "string", "DeliveryAddressLine2": "string", "DeliveryZipCode": "string", "DeliveryCity": "string", "DeliveryRegion": "string", "DeliveryCountryId": 0, "DeliveryDate": "2019-08-24T14:15:22Z", "Quantity": 0, "Volume": 0, "Weight": 0, "IsPrinted": true, "DeliveryTerms": "string", "DeliveryMode": "string", "Source": "string", "DeliveryMark": "string", "NoteText": "string", "Department": "string", "Centre": "string", "ShippingNo": "string", "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "DeliveryAddressId": "string", "DivisionCode": "string", "StatusId": 0, "IsForgotten": true, "ForgottenBy": 0, "ForgottenDate": "2019-08-24T14:15:22Z", "Items": [ … ], "Packages": [ … ] } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Orders/Invoices
[ { "Id": "string", "ClientId": 0, "InvoiceNo": "string", "TypeId": 0, "ReferenceOrderId": "string", "BuyerCompanyId": 0, "BuyerCustomerId": 0, "PayerCompanyId": 0, "PayerCustomerId": 0, "ResellerCompanyId": 0, "ResellerCustomerId": 0, "GroupCode": "string", "DeliveryDate": "2019-08-24T14:15:22Z", "InvoiceDate": "2019-08-24T14:15:22Z", "InvoiceDueDate": "2019-08-24T14:15:22Z", "SalesRepContactId": 0, "Source": "string", "Quantity": 0, "Volume": 0, "Weight": 0, "CurrencyId": 0, "CurrencyRate": 0, "CashDiscount": 0, "CashDiscountDate": "2019-08-24T14:15:22Z", "SumLineDiscount": 0, "FreightCost": 0, "InvoiceFee": 0, "CostValue": 0, "SalesBalance": 0, "InvoiceAmount": 0, "InvoiceRoundOff": 0, "VatDutiable1": 0, "VatDutiable2": 0, "VatDutiable3": 0, "Vat1": 0, "Vat2": 0, "Vat3": 0, "VatRoundOff": 0, "Vat": 0, "InvoiceName": "string", "InvoiceAttention": "string", "InvoiceCareOf": "string", "InvoiceAddressLine1": "string", "InvoiceAddressLine2": "string", "InvoiceZipCode": "string", "InvoiceCity": "string", "InvoiceRegion": "string", "InvoiceCountryId": 0, "LedgerVoucher": "string", "Department": "string", "Centre": "string", "NoteText": "string", "LastInvoiceForOrder": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "InvoiceAddressId": "string", "ReferenceNoPsp": "string", "PaymentMethodId": 0, "DeliveryMethodId": 0, "IsDebit": true, "CreditedInvoiceId": "string", "Comment": "string", "IsForgotten": true, "ForgottenBy": 0, "ForgottenDate": "2019-08-24T14:15:22Z", "AggregatedInvoiceCode": "string", "PaymentMethodCode": "string", "PaymentMethodName": "string", "Items": [ … ], "Address": { … } } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Orders/WarehouseTransactions
[ { "TransactionNo": "string", "Id": "string", "TransactionDate": "2019-08-24T14:15:22Z", "WarehouseCode": "string", "LocationCode": "string", "Type": "string", "OrderNo": "string", "PurchaseOrderNo": "string", "DeliveryNoteNo": "string", "ExternalReference": "string", "ReasonCode": "string", "Comment": "string", "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Items": [ … ] } ]