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/Reporting/OrderSummaryByDay
[ { "Client": "string", "Application": "string", "Year": 0, "Month": 0, "Day": 0, "OrderQty": 0, "FreightCostExVat": 0, "FreightCostIncVat": 0, "OrderFeeExVat": 0, "OrderFeeIncVat": 0, "ItemQty": 0, "ItemAmountExVat": 0, "ItemAmountIncVat": 0, "OrderSumExVat": 0, "OrderSumIncVat": 0 } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Reporting/OrderSummaryByMonth
[ { "Client": "string", "Application": "string", "Year": 0, "Month": 0, "OrderQty": 0, "FreightCostExVat": 0, "FreightCostIncVat": 0, "OrderFeeExVat": 0, "OrderFeeIncVat": 0, "ItemQty": 0, "ItemAmountExVat": 0, "ItemAmountIncVat": 0, "OrderSumExVat": 0, "OrderSumIncVat": 0 } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Reporting/OrderSummaryByPaymentAndMonth
[ { "Client": "string", "Application": "string", "PaymentService": "string", "PaymentMethodType": "string", "PaymentMethod": "string", "Year": 0, "Month": 0, "OrderQty": 0, "FreightCostExVat": 0, "FreightCostIncVat": 0, "OrderFeeExVat": 0, "OrderFeeIncVat": 0, "ItemQty": 0, "ItemAmountExVat": 0, "ItemAmountIncVat": 0, "OrderSumExVat": 0, "OrderSumIncVat": 0 } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Reporting/OrderSummaryByWeek
[ { "Client": "string", "Application": "string", "Year": 0, "Week": 0, "OrderQty": 0, "FreightCostExVat": 0, "FreightCostIncVat": 0, "OrderFeeExVat": 0, "OrderFeeIncVat": 0, "ItemQty": 0, "ItemAmountExVat": 0, "ItemAmountIncVat": 0, "OrderSumExVat": 0, "OrderSumIncVat": 0 } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Reporting/OrderSummaryRolling
[ { "Client": "string", "Application": "string", "OrderQty": 0, "ItemQty": 0, "OrderSumExVat": 0, "OrderSumIncVat": 0 } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Reporting/Subscriptions
[ { "Id": 0, "ClientId": 0, "SourceId": 0, "DestinationId": 0, "WarningMinuteCount": 0, "IsActive": true, "IsTest": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "Publications": [ … ] } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Reporting/SubscriptionDestinations
[ { "Id": 0, "DefaultName": "string", "DefaultDescription": "string", "IsActive": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "Subscriptions": [ … ], "Cultures": { … } } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Reporting/SubscriptionSources
Success
Cultures.
Subscriptions.
[ { "Id": 0, "DefaultName": "string", "DefaultDescription": "string", "GroupId": 0, "TypeId": 0, "IsActive": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "Cultures": [ … ], "Subscriptions": [ … ] } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Reporting/SubscriptionSourceTypes
[ { "Id": 0, "DefaultName": "string", "DefaultDescription": "string", "IsActive": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "Cultures": { … }, "Sources": [ … ] } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Reporting/SubscriptionSourceGroups
[ { "Id": 0, "DefaultName": "string", "DefaultDescription": "string", "IsActive": true, "Created": "2019-08-24T14:15:22Z", "CreatedBy": 0, "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "Cultures": { … }, "Sources": [ … ] } ]
curl -i -X GET \ https://query.storm.io/Query/2.0/Reporting/Tasks
[ { "Id": 0, "Key": "string", "ClientKey": "string", "SupplierKey": "string", "Name": "string", "Description": "string", "IsActive": true, "SecretKey": "string", "Updated": "2019-08-24T14:15:22Z", "UpdatedBy": 0, "RowId": "string", "History": [ … ] } ]