You can optimize your business processes by using the Unleashed Software API to create dashboards and spreadsheets with your inventory and sales data. In this tutorial, we’ll walk through how to get your API ID and key, and then how to use them to export sales orders data.
Get your API ID and key
To keep your inventory management data secret, Unleashed Software uses an API signing mechanism that requires an ID and a key. You can retrieve your key from the Unleashed web application.
- In the sidebar, click
Integrationand thenUnleashed API Access
- You will see your API id and key. Copy these for use in the next step.
Export your Sales Orders
The Unleashed Software API has many endpoints to access the different categories of data stored within it. In this tutorial, we will use the SalesOrders endpoint to retrieve sales orders.
Put your API id and key in the form below to try it now, and get a dataset that you can download or export to Google Sheets.
Get Sales Orders from Unleashed API
Please fill in any necessary fields and click Run.
GET
Preview
View the API data, get a live Google Sheet dashboard
SalesOrderLines | OrderNumber | OrderDate | RequiredDate | CompletedDate | OrderStatus | Customer.CustomerCode | Customer.CustomerName | Customer.CurrencyId | Customer.Guid | Customer.LastModifiedOn | CustomerRef | Comments | Warehouse.WarehouseCode | Warehouse.WarehouseName | Warehouse.IsDefault | Warehouse.StreetNo | Warehouse.AddressLine1 | Warehouse.AddressLine2 | Warehouse.Suburb | Warehouse.City | Warehouse.Region | Warehouse.Country | Warehouse.PostCode | Warehouse.PhoneNumber | Warehouse.FaxNumber | Warehouse.MobileNumber | Warehouse.DDINumber | Warehouse.ContactName | Warehouse.Obsolete | Warehouse.Guid | Warehouse.LastModifiedOn | ReceivedDate | DeliveryContact | DeliveryInstruction | DeliveryName | DeliveryStreetAddress | DeliveryStreetAddress2 | DeliverySuburb | DeliveryCity | DeliveryRegion | DeliveryCountry | DeliveryPostCode | Currency | ExchangeRate | DiscountRate | Tax | TaxRate | XeroTaxCode | SubTotal | TaxTotal | Total | TotalVolume | TotalWeight | BCSubTotal | BCTaxTotal | BCTotal | PaymentDueDate | AllocateProduct | SalesOrderGroup | DeliveryMethod | SalesPerson | SendAccountingJournalOnly | SourceId | CreatedBy | CustomOrderStatus | CreatedOn | LastModifiedBy | Guid | LastModifiedOn |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Get a live Google Sheet
Export your data to a google sheet, with the SyncWith Addon, or download to CSV
Automatically updated
Schedule your data to update hourly or daily
Add data sources
Import additional data from other apps
Build reports & dashboards
Easily build live reports within Google Sheets