e-commerce

Export Sales Orders from Unleashed

Colin Dellow

Colin Dellow

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.
  1. Visit https://go.unleashedsoftware.com/v2
  1. In the sidebar, click Integration and then Unleashed API Access
    1. notion image
  1. You will see your API id and key. Copy these for use in the next step.
    1. notion image

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

Add data sources

Build reports & dashboards