The NetXL API is a powerful set of tools that allow you to automate key interactions, these include getting real-time pricing and stock availability, requesting quotes, and creating and confirming orders
The API is free and available to all customers, however to create an order you are required to have a credit account, payment via PayPal and Credit/Debit card is not currently supported via the API
The documentation below will show how to get the most out of the API, it includes code samples in several popular programming languages, it also includes guides on using the API with several popular GUI based tools, perfect for customers with less development experience
First things first, in order to use the API you will need to create a key, we use this to identify the requests you make as coming from your account, this ensures we return the correct information to you, and means only you can see your pricing and order data
To create a key, visit the preferences section of the NetXL customer dashboard
Your API key is unique to your account, you should not share it with anyone you do not trust, you can disable it at any time or create a new key from the preferences page
Accessing the API
There are two ways to access the API, the most common is to build an integration using a programming language such as Python or Java, this allows you to automate calls to the API tightly integrating into existing systems
The other way is to use a graphical tool such as Postman or Paw (or even a Web Browser), this method lets you query the API for data on an ad-hoc basis, without any need for computer programming experience
Response Data Formats - JSON & CSV
By default the API will return all responses in JSON format, this is the best format for automated integrations, however, it is also human readable due to its structured layout and key/value structure, an example response for the /customer command is shown on the right
Several API commands support returning the response as a CSV file, this is useful for customers who wish to import the data into a third party such as Microsoft Excel or Google Sheets, how to return a CSV is explained below, additionally, requests made from the Web Browser will return a CSV by default, making it easy for you to add a link to get updated pricing or order information
EXAMPLE JSON RESPONSE
Your First Request
Now we have an API key and have decided how to access the API (programmatically or with a tool) it's time to make our first request.
The NetXL API is a RESTful API, it supports operations on the following object types, Customer, Address, Order, and Quote, the base URL for the API is shown on the right.
For the first request, we'll ask the API to return our customer information, this includes our name and email address, plus details of any credit account we hold.
NetXL API Endpoint
Authenticating your API requests
For every request you need to provide the API key as a form of authentication, there are two ways to do this, you can use either way regardless of how you're accessing the API
- Supply the key as a HTTP Header in the request
- Use a Query String in the URL to provide it
Provide the key as a HTTP header
To provide the API key as an extra HTTP header, include the following header in your HTTP requests
Provide the key using a query string
Providing the API key using a query string is a simple as appending the following key/value to the end of every URL you're making requests to
Query String Example
Selecting the response type
Some API commands support returning the response as a CSV file, useful for importing into third party application such as Microsoft Excel or Google Sheets
To request the response as a CSV file you should set the 'Accept' header on your request to `text/csv` as follows
All other requests should send the `Accept` header as `application/json` if you omit the header you will get JSON responses back by default, it is recommend to set the header on every request however to avoid any confusion if future commands have a different default response format
Making the request
Now that you have everything setup, its time to make the first API request, we have two blog posts that show complete examples of calling the API using a programming language (Python) and a graphical tool (Postman)
- Read the Python API example
- Read the Postman API example
Log in to try the API commands
There are multiple situations where the API might return an error, most errors are caused by invalid data being provide to endpoints when asking to create objects. Consult the returned message to see why the command failed, you should also double check the documentation for the command in question to ensure the right data is being provided.
In rare cases, the API can fail due to an issue such as a issue with a server, or some third party the service relies on. In most of these cases you'll not be able to fix the issue
In all error cases, the response HTTP status code will be set, helping you to better understand the cause of the error
Possible HTTP Error Codes
In the event of an error, the API will return one of the following error codes, in most cases a 4xx error can be fixed by adjust the command, a 5xx error can't
400 Bad Request
Indicates that the API could not complete the request, check the response message for the cause of the error
Your API key is not valid, please check it and try again
402 Payment Required
Insufficient available credit on your account.
404 Not Found
This indicates either the URL was not valid, or the object you requested does not exist, for example trying to query an invalid order reference
The request could not be processed as it would cause duplicated data to be created. Check the response message for details
429 Too Many Requests
Your request to the API have been rate limited, please wait 5 minutes and try your command again
500 Internal Server Error
An unexpected error occurred in the API, you should try your API command again or contact support for assistance
503 Service Unavailable
The API is temporarily unavailable, try your command again in a few minutes
504 Gateway Timeout
A third party service the API relies on is unavailable, try your command again in a few minutes
Error Body Response
Indicates what cause the returned error, especially useful for diagnosing 4xx errors
400 Bad Request
The number of requests you can send to the API is limited, this is to ensure system stability and performance of the service, if you exceed the limit you will receive a 429 HTTP status code response, you should retry your command after a short delay.
Order and Quote commands are not rate limited
Account Details & Addresses
These commands allow you to query your account details, including your credit status and shipping addresses
Contact support if you want to apply for a trade or credit account
Get your account details
Return the basic details of your account
The first name of the account holder.
The surname of the account holder.
Login email address of the account holder.
Account email address that will receive copies of invoices
Is your account flagged as a trade account.
Details of your credit account.
Get your credit details
Return the credit account details of your account, includes your credit limit, total outstanding order value and your available credit. The response will also include details of any open orders
Your current account credit limit.
Total outstanding value of unpaid orders.
Available credit for new orders.
List of outstanding orders, detailing each due date and amount due.
Return a list of all active addresses on the account, the "id" field can be used in the /order command to avoid having to supply full address data every time
ID of the address, provide this in the order command to use this address..
The recipients name.
Name of the recipient company.
The first line of the recipients address.
Second line of the recipients address.
Third line of the recipients address.
Recipients postal code.
The two letter country code of the address, should be a valid country from the ISO 3166-1 alpha-2 list
Contact phone number for the recipient, this will be provided to the courier for delivery.
Create delivery address
Create a delivery address, this command can be used to create a new address, who's ID can then be reused when creating orders
Important! Please ensure the correct country code is provided, incorrect codes (such as GB for Jersey) will result in incorrect shipping estimates and may result in orders being cancelled
For UK addresses, the 'contact_number' field can be provided in either local or international format (e.g. 0330043300 or +44330043300) For all other countries the number should always be provided in international format
One of the key features of the API is the ability to search and filter the product catalogue, products can be filtered by manufacturer, category or attribute, the catalogue can additional be searched using a free text field.
Each product that is returned will include a single, 5+ and 10+ price, these prices reflect any custom pricing or discounts applied to your account.
Real time stock info is returned for each product, the number available at the time of the request is returned in the product object, additionally, trade account customers can see the expected arrival dates of new stock from manufacturers.
By default only a subset of the product data is returned, however, it is possible to request the additional data is returned in the command, this is documented below. Please be aware that requesting additional data may reduce the response speed of the command
The Product Object
The product object provides comprehensive detail about every product available via NetXL
The SKU for the product, used in the order command
The EAN of the product, this is normally a 13 digit EU EAN
Weight of the product (including box) in kilograms
Width of the boxed product in millimeters
Height of the boxed product in millimeters
Length of the boxed product in millimeters
Is this product a reduced/clearance product
A list of the product images
Availability data for the product
The net cost for a single unit based on your account pricing
The net cost for 5 or more units based on your account pricing
The net cost for 10 or more units based on your account pricing
The name of the product
The products manufacturer
Detailed information about the product, this is the same as the copy on the NetXL product pages
A summary of the key features of the product
A link to the product page on NetXL
categorieslist of string
A list of categories this product is in
A list of key/value pairs for the attributes applied to the product
related_productslist of string
A list of related product SKUs for this product
similar_productslist of string
A list of similar product SKUs for this product
Example Product Object
Searching the product catalogue
In order to search and filter the product catalogue, you should build up a query string to append to the end of the API endpoint (https://api.netxl.com/product). This query string allows you to filter the catalogue by manufacturer, category, attributes
Results can also be filtered to only products in stock, or to only include/exclude clearance products
Query String Parameters
Filter results to certain brands, supply a comma delimited list (Grandstream,Ubiquiti,2N)
Free text search of the product name/details
category - Filter results to specific categories, e.g. IP Hardware PBX, voip Adapters
When "true" only return clearance products, When "false" exclude clearance products, when omitted return both regular and clearance products
When "true" only return in stock products (false has no effect)
How to sort the returned results, must be one of - price, availability, sku or name
List of extra fields to return in the response, supports the following fields: description, shortDescription, related, similar
List of attributes to filter by (see attribute filtering)
String attributes can be filtered by equality for example:
Number attributes can be filtered by < <= = => >, for example:
This would query all switches with more than 16 PoE ports
A list of attributes and their types can be obtained using the attribute list command
GET /product?Range (ft)>=300,Range (ft)<=400
Orders and Quotes
The API allows you to query your order history, for credit account customer, you can create orders using your credit limit.
There are two ways to create an order, the first is a two step process, where the order must be confirmed using a secondary API call, the other is a single call, that will create and confirm the order in one go, use this method when you do not require pricing or shipping quotes
The Order Object
The NetXL ID for this order
The NetXL order reference, starts either NXL or DUK depending on your packing choice
Your order reference
The code required to confirm this order, orders can be confirmed for up to 7 days after they are created
A list of items in this order
The net cost of the items in the order (does not including shipping)
The applicable tax for the order
The gross cost of the order
Should this order be automatically confirmed
The total weight of this order for shipping purposes
A list of valid shipping methods for this order, along with a cost for each
The shipping method to use for this order, must be one returned in the shipping_options list
Billing address to use for the order, you can either provide the full address, or the ID of an existing address
Shipping address to use for the order, you can either provide the full address, or the ID of an existing address
Example Order Object
Creating an order
To create an order, you need to provide two key things to the API
- A list of Item SKU's and quantities you wish to order
- The billing and shipping addresses
Additionally, if using auto confirmation, you will be required to provide a shipping method, or set a default method in the NetXL dashboard
Providing the item list
For each item you wish to order, you are required to provide the SKU and a quantity of units required, SKU's can be obtained using the product catalogue search or from the NetXL website
Billing & Shipping Addresses
For the addresses, you can either provide the full address details, or use an existing address by providing it's ID. If you provide both the details and an ID, then the ID will take priority and the details will be ignored
Optional Additional Parameters
You may additionally provide the following additional parameters with your order request
- customer_reference: Your reference for this order
- auto_confirm: Should this order be automatically confirmed
- shipping_method: The shipping method to use for this order
Order Created Successfully
Confirming an Order
Once you have created an order, you can check the pricing and shipping costs, if you're happy with these, you can use the confirmation_code provided to confirm the order. It is at this point that your order will be placed and entered into our fulfilment queue
Confirming the order
To confirm the order, you need to provide a shipping method, alternatively you can use your account default, providing the default method was returned in the shipping_options field when creating the order
Upon confirming your order, the response will include an order ID and reference from NetXL, these can be used to query the order or when contacting NetXL for assistance
Understanding Auto Confirmation
When creating an order, it is possible to skip the confirmation stage by setting `auto_confirm` to true in the original request.
In order to use auto confirmation, you must send a shipping_method parameter in your request, or have set a default shipping method in the NetXL dashboard
Invalid Shipping Method
If the shipping method you provided is not valid for this order, you will receive an error response. You can see the valid shipping methods by disabling auto confirmation and creating and confirming the order as normal.
Auto confirmed orders will use the current live price for each item, this may be more or less than the previous price paid for an item. NetXL will not provide refunds for differences in price where an item has increased when auto confirmation is used, you may however still cancel an order prior to shipping
Requesting a Quote
To request a quote for an order, send your POST request to /quote instead of /order, this will raise a ticket with NetXL customer support who will then create a quote for the requested items.
You will be notified via email once the quote is created, you can confirm the order using the confirmation code as normal, but with the adjusted pricing
Categories & AttributesThese commands can be used to obtain a list of categories and attributes that can then be used to filter the product catalogue.
CategoriesReturns a list of categories that can then be used to filter the product catalogue using the `category` query string parameter
The Cateogry Object
The name of the category, can be used to filter the product catalogue
Subcategories of this category
AttributesReturns a list of attributes and their possible values, these can then be combined into a filter using the 'attribute' query string parameter
The Attribute Object
The name of this attribute, used in the product catalogue search
What type of attribute this is, either Boolean (boolean), String (string) or Number (int), effects which filters can be used in the product catalogue search
list of all possible values for this attribute, can be used to help filter the product catalogue
ManufacturersReturns a list of manufacturer names, these can be used to filter the product catalogue using the `manufacturer` query string parameter
The Manufacturer Object
The manufacturer name