Skip to main content

Sage 200 Component

Sage 200 is an online business management solution designed to help businesses manage their finances, customers, and business insight in one solution.

Component key: sage-200

Description

Sage 200 is an online business management solution designed to help businesses manage their finances, customers, and business insight in one solution.

Use the Sage 200 component to manage Customers, Products, and Pricing.

API Documentation

This component is built to the Sage 200 Professional/Extra Online API Reference.

Connections

Sage 200 OAuth 2.0 Connection

Connection and Authentication

To generate a token, your application requires a Client ID and Client Secret please contact the Sage Developer Services team by emailing developers.programme@sage.com along with the following information:

  • Application name.
  • Application description.
  • Description of use i.e. In-house or publication for resale.
  • Type of application i.e. Public Client (Desktop, Mobile application) or Confidential (Web Server). If the type is a Confidential Client application you must supply your "Redirect Url".

Sage will then confirm your request and have you submit the following form. Once completed, It may take Sage a few days to process the request but you will eventually receive credentials for the integration connection configuration.

Native API access via Microsoft Entra ID/Active Directory Tunnelling

Some instances may require tunnelling their Sage 200 server to a Microsoft 365 account in order to run Native API calls for local servers. Please refer to the Set up the Sage 200 Native API using Microsoft Entra ID Azure Active Directory Tunnelling for detailed instruction. Additionally, the following onboarding video details the steps of the setup process.

InputDefaultNotes
Authorize URL
string
/ Required
Hidden Field
authorizeUrl
https://id.sage.com/authorize?audience=s200ukipd/sage200
The OAuth 2.0 Authorization URL for Sage 200
Client ID
string
/ Required
clientId
Client Secret
password
/ Required
clientSecret
Ocp Apim Subscription Key
string
/ Required
ocp-apim-subscription-key
You can get your subscription key following the steps at 'Obtain Developer Subscription Keys' here: https://developer.sage.com/200/api/get-started/
Sage 200 Edition
string
/ Required
sage200edition
The Sage 200 Edition you are connecting to.
Scopes
string
/ Required
scopes
openid profile email offline_access
A space-delimited set of one or more scopes to get the user's permission to access.
Token URL
string
/ Required
Hidden Field
tokenUrl
https://id.sage.com/oauth/token
The OAuth 2.0 Token URL for Sage 200

Data Sources

Select Customer

Select a customer from a dropdown list | key: selectCustomer | type: picklist

InputNotesExample
Company
string
/ Required
company
The company ID. You can get and reference this value from the 'Get Site and Company Information' action.
14123
Connection
connection
/ Required
connection
 
 
Site
string
/ Required
site
The site ID. You can get and reference this value from the 'Get Site and Company Information' action.
9e12a1b-caa9-ca01-dcca-08dc12dd123a

{
"result": [
{
"label": "A1 Design Services",
"key": "27825"
}
]
}

Select Product Group

Select a product group from a dropdown list | key: selectProductGroup | type: picklist

InputNotesExample
Company
string
/ Required
company
The company ID. You can get and reference this value from the 'Get Site and Company Information' action.
14123
Connection
connection
/ Required
connection
 
 
Site
string
/ Required
site
The site ID. You can get and reference this value from the 'Get Site and Company Information' action.
9e12a1b-caa9-ca01-dcca-08dc12dd123a

{
"result": [
{
"label": "Paper Products",
"key": "34634"
}
]
}

Select Tax Code

Select a tax code from a dropdown list | key: selectTaxCode | type: picklist

InputNotesExample
Company
string
/ Required
company
The company ID. You can get and reference this value from the 'Get Site and Company Information' action.
14123
Connection
connection
/ Required
connection
 
 
Site
string
/ Required
site
The site ID. You can get and reference this value from the 'Get Site and Company Information' action.
9e12a1b-caa9-ca01-dcca-08dc12dd123a

{
"result": [
{
"label": "Purchase Services ROW (Reverse Charge)",
"key": "16"
}
]
}

Actions

Create Customer

Create a new customer | key: createCustomer

InputDefaultNotesExample
Account Status Type
string
accountStatusType
The status of the customer account (Sage 200 Standard and versions of Professional released after July 2017). See https://developer.columbus.sage.com/docs#/uk/sage200extra/accounts/v1/account_status_types
AccountStatusActive
Additional Fields
code
additionalFields
Additional fields that are not covered by the standard inputs. See https://developer.columbus.sage.com/docs#/uk/sage200extra/accounts/v1/customers
Company
string
/ Required
company
The company ID. You can get and reference this value from the 'Get Site and Company Information' action.
14123
Connection
connection
/ Required
connection
 
 
 
Currency ID
string
currencyId
Currency record Id. This defaults to the base currency Id. See https://developer.columbus.sage.com/docs#/uk/sage200extra/accounts/v1/currencies
2103
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Exchange Rate Type
string
exchangeRateType
The type of exchange rate used on the customer account. See https://developer.columbus.sage.com/docs#/uk/sage200extra/accounts/v1/exchange_rate_types
ExchangeRateSingle
Fax Area Code
string
faxAreaCode
Fax area code.
806
Fax Country Code
string
faxCountryCode
Fax country code.
+1
Fax Subscriber Number
string
faxSubscriberNumber
Fax subscriber number.
123-4567
Name
string
/ Required
name
Customer name.
John Doe
On Hold
boolean
onHold
false
True if customer account is on hold, else False.
 
Reference
string
reference
Customer account reference. Note: For Sage 200 Professional this is not required if customer reference is set to 'generate automatically' inside the Sage 200 application settings.
ref-1234
Short Name
string
shortName
Customer short name.
John
Site
string
/ Required
site
The site ID. You can get and reference this value from the 'Get Site and Company Information' action.
9e12a1b-caa9-ca01-dcca-08dc12dd123a
Status Reason
string
statusReason
Reason for change in account status.
Suspended due to non-payment
Telephone Area Code
string
telephoneAreaCode
Telephone area code.
806
Telephone Country Code
string
telephoneCountryCode
Telephone country code.
+1
Telephone Subscriber Number
string
telephoneSubscriberNumber
Telephone subscriber number.
123-4567
Website
string
website
Website address.
https://www.example.com

{
"data": {
"reference": "ABCDE",
"name": "John",
"short_name": "John",
"balance": 0,
"on_hold": false,
"account_status_type": "AccountStatusActive",
"status_reason": "",
"currency_id": 2103,
"exchange_rate_type": "ExchangeRateSingle",
"telephone_country_code": "",
"telephone_area_code": "",
"telephone_subscriber_number": "",
"fax_country_code": "",
"fax_area_code": "",
"fax_subscriber_number": "",
"website": "",
"credit_limit": 0,
"country_code_id": 13,
"default_tax_code_id": 1729,
"vat_number": "",
"account_type": "TradingAccountTypeOpenItem",
"early_settlement_discount_percent": 0,
"early_settlement_discount_days": 0,
"payment_terms_days": 0,
"payment_terms_basis": "PaymentDueFromCalendarMonth",
"credit_bureau_id": 2135,
"credit_position_id": 1,
"trading_terms": "",
"credit_reference": "",
"account_opened": "2024-05-23T00:00:00Z",
"terms_agreed": false,
"order_priority": "",
"months_to_keep_transactions": 36,
"default_nominal_code_reference": "4000",
"default_nominal_code_cost_centre": "",
"default_nominal_code_department": "",
"analysis_code_1": "",
"analysis_code_2": "",
"analysis_code_3": "",
"analysis_code_4": "",
"analysis_code_5": "",
"analysis_code_6": "",
"analysis_code_7": "",
"analysis_code_8": "",
"analysis_code_9": "",
"analysis_code_10": "",
"analysis_code_11": "",
"analysis_code_12": "",
"analysis_code_13": "",
"analysis_code_14": "",
"analysis_code_15": "",
"analysis_code_16": "",
"analysis_code_17": "",
"analysis_code_18": "",
"analysis_code_19": "",
"analysis_code_20": "",
"spare_text_1": "",
"spare_text_2": "",
"spare_text_3": "",
"spare_text_4": "",
"spare_text_5": "",
"spare_text_6": "",
"spare_text_7": "",
"spare_text_8": "",
"spare_text_9": "",
"spare_text_10": "",
"spare_number_1": 0,
"spare_number_2": 0,
"spare_number_3": 0,
"spare_number_4": 0,
"spare_number_5": 0,
"spare_number_6": 0,
"spare_number_7": 0,
"spare_number_8": 0,
"spare_number_9": 0,
"spare_number_10": 0,
"spare_bool_1": false,
"spare_bool_2": false,
"spare_bool_3": false,
"spare_bool_4": false,
"spare_bool_5": false,
"value_of_current_orders_in_sop": 0,
"duns_code": "",
"average_time_to_pay": 0,
"finance_charge_id": 0,
"office_type": "Independent",
"associated_head_office_id": 0,
"produce_statements_for_customer": false,
"use_consolidated_billing": false,
"use_tax_code_as_default": false,
"invoice_discount_percent": 0,
"invoice_line_discount_percent": 0,
"customer_discount_group_id": 0,
"order_value_discount_id": 0,
"price_band_id": 0,
"id": 82660
}
}

Create Customer Delivery Address

Create a new customer delivery address | key: createCustomerDeliveryAddress

InputDefaultNotesExample
Address 1
string
address1
Address line 1.
1 High Street
Address 2
string
address2
Address line 2.
2 Low Street
Address 3
string
address3
Address line 3.
3 Middle Street
Address 4
string
address4
Address line 4.
4 Side Street
Address Country Code Id
string
addressCountryCodeId
Country code Id. See https://developer.columbus.sage.com/docs#/uk/sage200extra/accounts/v1/country_codes
0
City
string
city
City (if using segmented addresses in Sage 200 Professional).
Albany
Company
string
/ Required
company
The company ID. You can get and reference this value from the 'Get Site and Company Information' action.
14123
Connection
connection
/ Required
connection
 
 
 
Contact
string
contact
The contact associated with the customer delivery address.
Peter Young
Country Code Id
string
countryCodeId
VAT details Country code Id. See https://developer.columbus.sage.com/docs#/uk/sage200extra/accounts/v1/country_codes
13
County
string
county
County (if using segmented addresses in Sage 200 Professional).
Brown County
Customer Id
string
/ Required
customerId
Unique Id of the customer account the customer delivery address is associated with.
27912
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Description
string
/ Required
description
The description of the customer delivery address.
Home Address
Email
string
email
The email address associated with the customer delivery address.
pyoung@hobotmail.com
Fax
string
fax
The fax number associated with the customer delivery address.
08976 656 878
Is Default
boolean
isDefault
false
Flag to indicate if this is the default customer delivery address for the parent customer.
 
Postal Name
string
postalName
Postal name is the name of the person or company who the invoice or sales order is addressed to.
Peter Young
Postcode
string
postcode
Postcode.
12345
Site
string
/ Required
site
The site ID. You can get and reference this value from the 'Get Site and Company Information' action.
9e12a1b-caa9-ca01-dcca-08dc12dd123a
Tax Code Id
string
/ Required
taxCodeId
The tax code record Id.
1729
Tax Number
string
taxNumber
The tax number.
9NN-NN-NNNN
Telephone
string
telephone
The telephone number associated with the customer delivery address.
08976 656 878

{
"data": {
"contact": "",
"country": "",
"customer_id": 27825,
"description": "Home Address 4",
"email": "",
"fax": "",
"is_default": false,
"postal_name": "Peter Young",
"tax_code_id": 1729,
"tax_number": "GB238 3839 38",
"telephone": "",
"country_code_id": 13,
"address_1": "1 High Street",
"address_2": "",
"address_3": "",
"address_4": "",
"city": "",
"county": "",
"postcode": "",
"address_country_code_id": 0,
"id": 82790
}
}

Create Product

Create a new product | key: createProduct

InputDefaultNotesExample
Additional Fields
code
additionalFields
Additional fields that are not covered by the standard inputs. See https://developer.columbus.sage.com/docs#/uk/sage200extra/accounts/v1/products
Allow Duplicate Numbers
boolean
allowDuplicateNumbers
false
Indicates whether the product allows duplicate numbers. (Sage 200 Professional only).
 
Allow Sales Order
boolean
allowSalesOrder
true
Indicates whether the product is allowed on sales orders and invoicing.
 
Product Barcode
string
barcode
Product bar code.
1234567890123
Product Code
string
/ Required
code
Product code.
VID003
Company
string
/ Required
company
The company ID. You can get and reference this value from the 'Get Site and Company Information' action.
14123
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Product Description
string
description
Product description.
32mb PCI Video Card
Fulfilment Method Type
string
fulfilmentMethodType
The fulfilment method type of the product. See https://developer.columbus.sage.com/docs#/uk/sage200extra/accounts/v1/fulfilment_method_types
EnumFulfilmentFromStock
Fulfilment Sequence Type
string
fulfilmentSequenceType
The fulfilment sequence type of the product. See https://developer.columbus.sage.com/docs#/uk/sage200extra/accounts/v1/fulfilment_sequence_types
EnumBinPriority
Inactivation Date
string
inactivationDate
If the product was made inactive, the date on which the product was made inactive.
2024-02-28T14:06:51.697Z
Label Printing Option Type
string
labelPrintingOptionType
The label printing option type. (Sage 200 Professional only). See https://developer.columbus.sage.com/docs#/uk/sage200extra/accounts/v1/label_printing_option_types
EnumNotRequired
Manufacturer
string
manufacturer
The product manufacturer.
Nvidia
Product Name
string
/ Required
name
Product name.
32mb PCI Video Card
Part Number
string
partNumber
The product part number.
VI6874
Product Group ID
string
/ Required
productGroupId
Product group record Id. See https://developer.columbus.sage.com/docs#/uk/sage200extra/accounts/v1/product_groups
34646
Product Status Type
string
productStatusType
The product status type. See https://developer.columbus.sage.com/docs#/uk/sage200extra/accounts/v1/product_status_types
EnumStockItemStatusTypeActive
Sale From Single Batch
boolean
saleFromSingleBatch
false
Indicates whether the product is sold from a single batch. (Sage 200 Professional only).
 
Shelf Life
string
shelfLife
The shelf life of the product. (Sage 200 Professional only).
Shelf Life Type
string
shelfLifeType
The shelf life type of the product. (Sage 200 Professional only). See https://developer.columbus.sage.com/docs#/uk/sage200extra/accounts/v1/time_unit_types
EnumTimeUnitDay
Site
string
/ Required
site
The site ID. You can get and reference this value from the 'Get Site and Company Information' action.
9e12a1b-caa9-ca01-dcca-08dc12dd123a
Tax Code ID
string
taxCodeId
Tax code record Id. See https://developer.columbus.sage.com/docs#/uk/sage200extra/accounts/v1/tax_codes
1729
Traceable Type
string
traceableType
The traceable type of the product. (Sage 200 Professional only). See https://developer.columbus.sage.com/docs#/uk/sage200extra/accounts/v1/traceable_types
EnumTraceableTypeNone
Use Description On Documents
boolean
useDescriptionOnDocuments
false
Whether to use the product description on order and invoice documents.
 
Uses Alternative Reference
boolean
usesAlternativeRef
false
Indicates whether the product uses alternative references. (Sage 200 Professional only).
 
Uses Sell By Date
boolean
usesSellByDate
false
Indicates whether the product uses sell by dates. (Sage 200 Professional only).
 
Uses Use By Date
boolean
usesUseByDate
false
Indicates whether the product uses use by dates. (Sage 200 Professional only).
 

{
"data": {
"code": "PAPERA4",
"name": "Paper - A4 (500 sheets)",
"description": "",
"use_description_on_documents": false,
"barcode": "",
"allow_sales_order": true,
"free_stock_quantity": 0,
"product_group_id": 34634,
"tax_code_id": 16,
"product_status_type": "EnumStockItemStatusTypeActive",
"fulfilment_method_type": "EnumFulfilmentFromStock",
"fulfilment_sequence_type": "EnumBinPriority",
"manufacturer": "",
"part_number": "",
"label_printing_option_type": "EnumNotRequired",
"traceable_type": "EnumTraceableTypeNone",
"sale_from_single_batch": false,
"allow_duplicate_numbers": false,
"uses_alternative_ref": false,
"uses_sell_by_date": false,
"uses_use_by_date": false,
"shelf_life": 0,
"shelf_life_type": "EnumTimeUnitDay",
"record_nos_on_goods_received": false,
"include_nos_on_count_sheets": false,
"auto_generate_option_type": "EnumDoNotGenerate",
"auto_generate_separator_id": 1,
"auto_generate_prefix": "",
"auto_generate_next_number": 0,
"auto_generate_padding": 0,
"stocktake_cycle_period": 0,
"standard_cost": 0,
"average_buying_price": 0,
"default_picking_list_comment": "",
"default_despatch_note_comment": "",
"commodity_code": "",
"country_of_origin_id": 0,
"weight": 0,
"suppress_mass_on_declaration": false,
"is_weee_item": false,
"use_supplementary_units": false,
"supplementary_unit_conversion_ratio": 1,
"use_reverse_charge_vat_rules": false,
"analysis_code_1": "",
"analysis_code_2": "",
"analysis_code_3": "",
"analysis_code_4": "",
"analysis_code_5": "",
"analysis_code_6": "",
"analysis_code_7": "",
"analysis_code_8": "",
"analysis_code_9": "",
"analysis_code_10": "",
"analysis_code_11": "",
"analysis_code_12": "",
"analysis_code_13": "",
"analysis_code_14": "",
"analysis_code_15": "",
"analysis_code_16": "",
"analysis_code_17": "",
"analysis_code_18": "",
"analysis_code_19": "",
"analysis_code_20": "",
"spare_text_1": "",
"spare_text_2": "",
"spare_text_3": "",
"spare_text_4": "",
"spare_text_5": "",
"spare_text_6": "",
"spare_text_7": "",
"spare_text_8": "",
"spare_text_9": "",
"spare_text_10": "",
"spare_number_1": 0,
"spare_number_2": 0,
"spare_number_3": 0,
"spare_number_4": 0,
"spare_number_5": 0,
"spare_number_6": 0,
"spare_number_7": 0,
"spare_number_8": 0,
"spare_number_9": 0,
"spare_number_10": 0,
"spare_bool_1": false,
"spare_bool_2": false,
"spare_bool_3": false,
"spare_bool_4": false,
"spare_bool_5": false,
"landed_costs_type": "EnumNotApplicable",
"landed_costs_percentage": 0,
"landed_costs_per_item": 0,
"bom_item_type": "EnumBOMItemTypeComponent",
"warehouse_holdings": [
{
"warehouse_id": 34627,
"product_id": 84250,
"reorder_level": 1,
"minimum_level": 1,
"maximum_level": 1,
"quantity_reserved": 0,
"confirmed_qty_in_stock": 0,
"unconfirmed_qty_in_stock": 0,
"quantity_in_stock": 0,
"quantity_in_stock_less_reserved": 0,
"quantity_on_order": 0,
"quantity_allocated_stock": 0,
"quantity_allocated_sop": 0,
"quantity_allocated_bom": 0,
"quantity_allocated": 0,
"free_stock_available": 0,
"free_stock_available_less_reserved": 0,
"warehouse_name": "Warehouse",
"is_default_manufacturing_warehouse": true,
"bin_holdings": [
{
"warehouse_holding_id": 84263,
"product_id": 84250,
"name": "Unspecified",
"allocation_priority": 9,
"quantity_reserved": 0,
"unconfirmed_qty_in_stock": 0,
"confirmed_qty_in_stock": 0,
"quantity_allocated_sop": 0,
"quantity_allocated_stock": 0,
"quantity_allocated_bom": 0,
"quantity_in_stock": 0,
"quantity_in_stock_less_reserved": 0,
"quantity_allocated": 0,
"free_stock_available": 0,
"free_stock_available_less_reserved": 0,
"spare_text_1": "",
"spare_text_2": "",
"spare_text_3": "",
"spare_text_4": "",
"spare_text_5": "",
"spare_text_6": "",
"spare_text_7": "",
"spare_text_8": "",
"spare_text_9": "",
"spare_text_10": "",
"spare_number_1": 0,
"spare_number_2": 0,
"spare_number_3": 0,
"spare_number_4": 0,
"spare_number_5": 0,
"spare_number_6": 0,
"spare_number_7": 0,
"spare_number_8": 0,
"spare_number_9": 0,
"spare_number_10": 0,
"spare_bool_1": false,
"spare_bool_2": false,
"spare_bool_3": false,
"spare_bool_4": false,
"spare_bool_5": false,
"id": 84264
}
],
"id": 84263
}
],
"id": 84250
}
}

Create Sales Invoice

Create a new sales invoice. Note: Posting a sales invoice does not actually create a 'sales invoice' entity, but a Posted Transaction of type 'TradingAccountEntryTypeInvoice', therefore it is not possible to 'get' a sales invoice using the same API endpoint after it has been posted. | key: createSalesInvoice

InputDefaultNotesExample
Company
string
/ Required
company
The company ID. You can get and reference this value from the 'Get Site and Company Information' action.
14123
Connection
connection
/ Required
connection
 
 
 
Customer ID
string
/ Required
customerId
Customer record ID to record a sale against. See https://developer.columbus.sage.com/docs#/uk/sage200extra/accounts/v1/customers
27825
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Discount Days
string
discountDays
Number of days to pay to qualify for the settlement discount. This defaults to the settlement days from the customer record.
3
Discount Percent
string
discountPercent
Percentage discount. This defaults to the settlement discount from the customer record.
15.00
Document Discount Value
string
documentDiscountValue
Discount value.
4.00
Document Goods Value
string
documentGoodsValue
Value of goods.
10.00
Document Tax Discount Value
string
documentTaxDiscountValue
Amount VAT is discounted when a settlement discount is applied.
5.00
Document Tax Value
string
documentTaxValue
Tax value.
2.00
Due Date
string
dueDate
Date the invoice is due to be paid.
2023-01-02T00:00:00Z
Exchange Rate
string
exchangeRate
Exchange rate for the invoice. This defaults to the customer exchange rate.
ExchangeRateSingle
Nominal Analysis Items
code
nominalAnalysisItems
Nominal analysis lines. See https://developer.columbus.sage.com/docs#/uk/sage200extra/accounts/v1/sales_invoices_nominal_analysis_items
Reference
string
reference
Invoice reference.
ABCDE
Second Reference
string
secondReference
Invoice second reference.
FGHIJ
Settled Immediately
boolean
settledImmediately
false
When set to True this indicates that the invoice has been paid and any settlement discount has been applied.
 
Site
string
/ Required
site
The site ID. You can get and reference this value from the 'Get Site and Company Information' action.
9e12a1b-caa9-ca01-dcca-08dc12dd123a
Tax Analysis Items
code
taxAnalysisItems
Tax analysis lines. See https://developer.columbus.sage.com/docs#/uk/sage200extra/accounts/v1/sales_invoices_tax_analysis_items
Transaction Date
string
transactionDate
Transaction date. This defaults to the current system date.
2023-01-02T00:00:00Z
Triangular Transaction
boolean
triangularTransaction
false
Indicates whether the transaction is triangluted.
 

{
"data": {
"urn": 1327
}
}

Create Sales Order

Create a new sales order | key: createSalesOrder

InputDefaultNotesExample
Additional Fields
code
additionalFields
Additional fields that are not covered by the standard inputs. See https://developer.columbus.sage.com/docs#/uk/sage200extra/accounts/v1/sop_orders
Apply Available Document Discount Percent
boolean
applyAvailableDocumentDiscountPercent
false
This should be passed within to apply the 'available_document_discount_percent' to the sales order only if the 'available_document_discount_percent' is greater than a positive 'Document Discount Percent'.
 
Company
string
/ Required
company
The company ID. You can get and reference this value from the 'Get Site and Company Information' action.
14123
Connection
connection
/ Required
connection
 
 
 
Customer Delivery Address ID
string
customerDeliveryAddressId
The Id of the customer delivery address to copy details to the sales order delivery address and resets 'Use Invoice Address'. See https://developer.columbus.sage.com/docs#/uk/sage200extra/accounts/v1/customer_delivery_addresses
27912
Customer Document Number
string
customerDocumentNo
Customer document number.
0000000001
Customer ID
string
/ Required
customerId
Customer record ID to create the sales order for.
27903
Customer Type
string
customerType
SOP customer type. See https://developer.columbus.sage.com/docs#/uk/sage200extra/accounts/v1/sop_customer_types
EnumCustomerTypeCredit
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Document Created By
string
documentCreatedBy
The person who created the sales order.
John Doe
Document Date
string
documentDate
Sales order document date.
2023-01-02T00:00:00Z
Document Discount Percent
string
documentDiscountPercent
Document discount percent value, between -99.99 and 99.99. A negative value is treated as a surcharge (e.g. -10 is a 10% surcharge), and a positive value is treated as a discount.
0
Document Number
string
documentNo
Sales order document number. If the SOP setting in Sage 200 Professional is to NOT automatically generate numbers, then this property MUST be set. If the SOP setting in Sage 200 Professional is to automatically generate numbers, or you are using Sage 200 Standard (which doesn't allow you to set this option), then setting this will be ignored.
123
Exchange Rate
string
exchangeRate
Exchange rate.
1
Is Editing
boolean
isEditing
false
If this is set to true, and the order is still a draft order, the order will remain as a draft order, otherwise the order is made a confirmed order.
 
Is To Sequence Lines
boolean
isToSequenceLines
false
If this is set to true, then the order of the line objects in the lines collection will determine the line number (print sequence number) for each line.
 
Is Triangulated
boolean
isTriangulated
false
Whether this order is triangulated and applies only to an EU customer with a different country code to that set in the company details.
 
Order Priority
string
orderPriority
Order priority.
2
Override On Hold
boolean
overrideOnHold
false
Allows a user that has the permissions to override the order's On Hold status, applied when a customer's account balance is over its credit limit.
 
Promised Delivery Date
string
promisedDeliveryDate
Promised delivery date.
2024-02-28T14:06:55.723Z
Quotation Expiry Date
string
quotationExpiryDate
Quotation expiry date (only used for quotations).
2024-02-28T14:06:55.723Z
Recalculate Prices
boolean
recalculatePrices
false
Allows recalculation of the prices for the order when the exchange rate has changed.
 
Requested Delivery Date
string
requestedDeliveryDate
Requested delivery date.
2024-02-28T14:06:55.723Z
Settlement Discount Days
string
settlementDiscountDays
Settlement discount days.
30
Settlement Discount Percent
string
settlementDiscountPercent
Settlement discount percent.
2.5
Site
string
/ Required
site
The site ID. You can get and reference this value from the 'Get Site and Company Information' action.
9e12a1b-caa9-ca01-dcca-08dc12dd123a
Suppress Warnings
boolean
suppressWarnings
false
If this is set to true, we will suppress warnings specifically for payment with order and this is also the case if 'Is Editing' is false.
 
Use Invoice Address
boolean
useInvoiceAddress
false
True if this order uses the customer invoice address, else False.
 

{
"data": {
"is_credit_limit_exceeded": true,
"payment_with_order": false,
"invoice_payment_with_order_immediately": false,
"payment_value": 0,
"payment_reference": "",
"payment_method_id": 0,
"payment_method": {
"name": "",
"description": "",
"bank_account_id": 0,
"currency_id": 0,
"card_processing_method": false,
"id": 0
},
"payment_declared": 0,
"payment_undeclared": 0,
"declared_payment_remaining": 0,
"payment_status": {
"is_partially_invoiced": false,
"is_amendable": true,
"is_reference_amendable": true,
"is_payment_method_amendable": true
},
"document_no": "TBA",
"document_date": "2024-05-24T00:00:00Z",
"document_status": "EnumDocumentStatusLive",
"despatch_receipt_status": "EnumDocumentProcessStatusNone",
"invoice_credit_status": "EnumDocumentProcessStatusNone",
"cancelled_status": "EnumDocumentProcessStatusNone",
"customer_type": "EnumCustomerTypeCredit",
"customer_id": 27867,
"currency_id": 2103,
"is_draft": true,
"exchange_rate": 1,
"subtotal_goods_value": 0,
"subtotal_charge_net_value": 0,
"subtotal_charge_tax_value": 0,
"subtotal_discount_value": 0,
"total_net_value": 0,
"total_tax_value": 0,
"total_gross_value": 0,
"customer_document_no": "",
"use_invoice_address": true,
"is_triangulated": false,
"settlement_discount_days": 30,
"settlement_discount_percent": 2.5,
"document_discount_percent": 0,
"available_document_discount_percent": 0,
"document_created_by": "",
"requested_delivery_date": "2024-05-24T00:00:00Z",
"promised_delivery_date": "2024-05-24T00:00:00Z",
"order_priority": "",
"analysis_code_1": "",
"analysis_code_2": "",
"analysis_code_3": "",
"analysis_code_4": "",
"analysis_code_5": "",
"analysis_code_6": "",
"analysis_code_7": "",
"analysis_code_8": "",
"analysis_code_9": "",
"analysis_code_10": "",
"analysis_code_11": "",
"analysis_code_12": "",
"analysis_code_13": "",
"analysis_code_14": "",
"analysis_code_15": "",
"analysis_code_16": "",
"analysis_code_17": "",
"analysis_code_18": "",
"analysis_code_19": "",
"analysis_code_20": "",
"spare_text_1": "",
"spare_text_2": "",
"spare_text_3": "",
"spare_text_4": "",
"spare_text_5": "",
"spare_text_6": "",
"spare_text_7": "",
"spare_text_8": "",
"spare_text_9": "",
"spare_text_10": "",
"spare_number_1": 0,
"spare_number_2": 0,
"spare_number_3": 0,
"spare_number_4": 0,
"spare_number_5": 0,
"spare_number_6": 0,
"spare_number_7": 0,
"spare_number_8": 0,
"spare_number_9": 0,
"spare_number_10": 0,
"spare_bool_1": false,
"spare_bool_2": false,
"spare_bool_3": false,
"spare_bool_4": false,
"spare_bool_5": false,
"external_reference": "",
"customer": {
"reference": "KIN001",
"name": "Kinghorn & French",
"short_name": "Kinghorn",
"balance": 7398.35,
"on_hold": false,
"account_status_type": "AccountStatusActive",
"status_reason": "",
"currency_id": 2103,
"exchange_rate_type": "ExchangeRateSingle",
"telephone_country_code": "44",
"telephone_area_code": "0191",
"telephone_subscriber_number": "676 5656",
"fax_country_code": "44",
"fax_area_code": "0191",
"fax_subscriber_number": "676 5657",
"website": "www.sage.co.uk",
"credit_limit": 6000,
"country_code_id": 13,
"default_tax_code_id": 1729,
"vat_number": "GB958 5455 12",
"account_type": "TradingAccountTypeOpenItem",
"early_settlement_discount_percent": 2.5,
"early_settlement_discount_days": 30,
"payment_terms_days": 30,
"payment_terms_basis": "PaymentDueFromDocumentDate",
"credit_bureau_id": 2135,
"credit_position_id": 1,
"trading_terms": "30 Days",
"credit_reference": "BCS34367",
"account_opened": "2018-10-12T00:00:00Z",
"last_credit_review": "2024-03-03T00:00:00Z",
"next_credit_review": "2025-03-03T00:00:00Z",
"application_date": "2018-10-10T00:00:00Z",
"date_received": "2018-10-12T00:00:00Z",
"terms_agreed": true,
"order_priority": "",
"months_to_keep_transactions": 36,
"default_nominal_code_reference": "4002",
"default_nominal_code_cost_centre": "",
"default_nominal_code_department": "",
"analysis_code_1": "Trade",
"analysis_code_2": "George",
"analysis_code_3": "Tyne & Wear",
"analysis_code_4": "",
"analysis_code_5": "",
"analysis_code_6": "",
"analysis_code_7": "",
"analysis_code_8": "",
"analysis_code_9": "",
"analysis_code_10": "",
"analysis_code_11": "",
"analysis_code_12": "",
"analysis_code_13": "",
"analysis_code_14": "",
"analysis_code_15": "",
"analysis_code_16": "",
"analysis_code_17": "",
"analysis_code_18": "",
"analysis_code_19": "",
"analysis_code_20": "",
"spare_text_1": "",
"spare_text_2": "",
"spare_text_3": "",
"spare_text_4": "",
"spare_text_5": "",
"spare_text_6": "",
"spare_text_7": "",
"spare_text_8": "",
"spare_text_9": "",
"spare_text_10": "",
"spare_number_1": 0,
"spare_number_2": 0,
"spare_number_3": 0,
"spare_number_4": 0,
"spare_number_5": 0,
"spare_number_6": 0,
"spare_number_7": 0,
"spare_number_8": 0,
"spare_number_9": 0,
"spare_number_10": 0,
"spare_bool_1": false,
"spare_bool_2": false,
"spare_bool_3": false,
"spare_bool_4": false,
"spare_bool_5": false,
"value_of_current_orders_in_sop": 0,
"duns_code": "",
"average_time_to_pay": 0,
"finance_charge_id": 0,
"office_type": "Independent",
"associated_head_office_id": 0,
"produce_statements_for_customer": false,
"use_consolidated_billing": false,
"use_tax_code_as_default": false,
"invoice_discount_percent": 0,
"invoice_line_discount_percent": 0,
"customer_discount_group_id": 0,
"order_value_discount_id": 0,
"price_band_id": 37419,
"main_address": {
"customer_id": 27867,
"country": "Great Britain",
"contact_name": "John Bell",
"address_1": "98 Cathedral Gardens",
"address_2": "Benfield Rd",
"address_3": "Newcastle upon Tyne",
"address_4": "Tyne & Wear",
"city": "",
"county": "",
"postcode": "NE19 1GH",
"address_country_code_id": 13,
"id": 27868,
"date_time_created": "2024-02-28T14:06:36.62Z",
"date_time_updated": "2024-02-28T14:23:45.963Z"
},
"default_tax_code": {
"code": 1,
"name": "Standard rate",
"tax_rate": 20,
"terms": "EcTermsNotApplicable",
"terms_description": "Not Applicable",
"is_notional_acquisition_tax": false,
"id": 1729,
"date_time_created": "2024-02-28T14:03:24.59Z",
"date_time_updated": "2024-02-28T14:23:46.133Z"
},
"country_code": {
"code": "GB",
"name": "Great Britain",
"eu_member": false,
"id": 13,
"date_time_created": "2024-02-28T13:38:48.637Z",
"date_time_updated": "2024-02-28T14:23:46.173Z"
},
"currency": {
"symbol": "£",
"name": "Pound Sterling",
"core_currency_rate": 1,
"euro_currency_rate": 0.714285,
"currency_iso_code_id": 49,
"is_base_currency": true,
"is_euro_currency": false,
"use_for_new_accounts": true,
"exchange_rate_type": "ExchangeRateSingle",
"exchange_rate_amendability_type": "ExchangeAmendabilityAllTransactions",
"id": 2103,
"date_time_created": "2024-02-28T14:03:36.533Z",
"date_time_updated": "2024-02-28T14:23:46.243Z"
},
"alerts": [],
"id": 27867,
"date_time_created": "2024-02-28T14:06:36.61Z",
"date_time_updated": "2024-02-28T14:23:45.697Z"
},
"currency": {
"symbol": "£",
"name": "Pound Sterling",
"core_currency_rate": 1,
"euro_currency_rate": 0.714285,
"currency_iso_code_id": 49,
"is_base_currency": true,
"is_euro_currency": false,
"use_for_new_accounts": true,
"exchange_rate_type": "ExchangeRateSingle",
"exchange_rate_amendability_type": "ExchangeAmendabilityAllTransactions",
"id": 2103,
"date_time_created": "2024-02-28T14:03:36.533Z",
"date_time_updated": "2024-02-28T14:23:46.243Z"
},
"lines": [],
"memos": [],
"profitability": {
"sop_order_return_id": 82900,
"estimated_cost_value": 0,
"estimated_profit_percent_on_revenue": 0,
"estimated_profit_percent_on_cost": 0,
"estimated_profit_value": 0,
"issue_value": 0,
"realised_cost_value": 0,
"realised_issue_value": 0,
"realised_profit_percent_on_revenue": 0,
"realised_profit_percent_on_cost": 0,
"realised_profit_value": 0,
"simple_profit_calculation_only": false,
"id": 82901
},
"id": 82900
}
}

Delete Customer

Delete a customer by ID | key: deleteCustomer

InputDefaultNotesExample
Company
string
/ Required
company
The company ID. You can get and reference this value from the 'Get Site and Company Information' action.
14123
Connection
connection
/ Required
connection
 
 
 
Customer ID
string
/ Required
customerId
The ID of the customer to delete.
82060
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Site
string
/ Required
site
The site ID. You can get and reference this value from the 'Get Site and Company Information' action.
9e12a1b-caa9-ca01-dcca-08dc12dd123a

{
"data": {}
}

Delete Customer Contact

Delete a customer contact | key: deleteCustomerContact

InputDefaultNotesExample
Company
string
/ Required
company
The company ID. You can get and reference this value from the 'Get Site and Company Information' action.
14123
Connection
connection
/ Required
connection
 
 
 
Customer Contact ID
string
/ Required
customerContactId
The ID of the customer contact to delete
27914
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Site
string
/ Required
site
The site ID. You can get and reference this value from the 'Get Site and Company Information' action.
9e12a1b-caa9-ca01-dcca-08dc12dd123a

{
"data": {}
}

Delete Customer Delivery Address

Delete a customer delivery address by ID | key: deleteCustomerDeliveryAddress

InputDefaultNotesExample
Company
string
/ Required
company
The company ID. You can get and reference this value from the 'Get Site and Company Information' action.
14123
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Delivery Address ID
string
/ Required
deliveryAddressId
The ID of the customer delivery addresses to delete.
82780
Site
string
/ Required
site
The site ID. You can get and reference this value from the 'Get Site and Company Information' action.
9e12a1b-caa9-ca01-dcca-08dc12dd123a

{
"data": {}
}

Delete Product

Delete a product by ID | key: deleteProduct

InputDefaultNotesExample
Company
string
/ Required
company
The company ID. You can get and reference this value from the 'Get Site and Company Information' action.
14123
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Product ID
string
/ Required
productId
The ID of the product to delete.
35738
Site
string
/ Required
site
The site ID. You can get and reference this value from the 'Get Site and Company Information' action.
9e12a1b-caa9-ca01-dcca-08dc12dd123a

{
"data": {}
}

Delete Sales Order

Delete an existing sales order by ID | key: deleteSalesOrder

InputDefaultNotesExample
Company
string
/ Required
company
The company ID. You can get and reference this value from the 'Get Site and Company Information' action.
14123
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Sales Order ID
string
/ Required
salesOrderId
Sales order ID to delete
81390
Site
string
/ Required
site
The site ID. You can get and reference this value from the 'Get Site and Company Information' action.
9e12a1b-caa9-ca01-dcca-08dc12dd123a

{
"data": {}
}

Get Customer

Retrieve a customer by ID | key: getCustomer

InputDefaultNotesExample
Company
string
/ Required
company
The company ID. You can get and reference this value from the 'Get Site and Company Information' action.
14123
Connection
connection
/ Required
connection
 
 
 
Customer ID
string
/ Required
customerId
The ID of the customer to retrieve.
82060
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Site
string
/ Required
site
The site ID. You can get and reference this value from the 'Get Site and Company Information' action.
9e12a1b-caa9-ca01-dcca-08dc12dd123a

{
"data": {
"reference": "ABCDE",
"name": "John",
"short_name": "John",
"balance": 0,
"on_hold": false,
"account_status_type": "AccountStatusActive",
"status_reason": "",
"currency_id": 2103,
"exchange_rate_type": "ExchangeRateSingle",
"telephone_country_code": "",
"telephone_area_code": "",
"telephone_subscriber_number": "",
"fax_country_code": "",
"fax_area_code": "",
"fax_subscriber_number": "",
"website": "",
"credit_limit": 0,
"country_code_id": 13,
"default_tax_code_id": 1729,
"vat_number": "",
"account_type": "TradingAccountTypeOpenItem",
"early_settlement_discount_percent": 0,
"early_settlement_discount_days": 0,
"payment_terms_days": 0,
"payment_terms_basis": "PaymentDueFromCalendarMonth",
"credit_bureau_id": 2135,
"credit_position_id": 1,
"trading_terms": "",
"credit_reference": "",
"account_opened": "2024-05-23T00:00:00Z",
"terms_agreed": false,
"order_priority": "",
"months_to_keep_transactions": 36,
"default_nominal_code_reference": "4000",
"default_nominal_code_cost_centre": "",
"default_nominal_code_department": "",
"analysis_code_1": "",
"analysis_code_2": "",
"analysis_code_3": "",
"analysis_code_4": "",
"analysis_code_5": "",
"analysis_code_6": "",
"analysis_code_7": "",
"analysis_code_8": "",
"analysis_code_9": "",
"analysis_code_10": "",
"analysis_code_11": "",
"analysis_code_12": "",
"analysis_code_13": "",
"analysis_code_14": "",
"analysis_code_15": "",
"analysis_code_16": "",
"analysis_code_17": "",
"analysis_code_18": "",
"analysis_code_19": "",
"analysis_code_20": "",
"spare_text_1": "",
"spare_text_2": "",
"spare_text_3": "",
"spare_text_4": "",
"spare_text_5": "",
"spare_text_6": "",
"spare_text_7": "",
"spare_text_8": "",
"spare_text_9": "",
"spare_text_10": "",
"spare_number_1": 0,
"spare_number_2": 0,
"spare_number_3": 0,
"spare_number_4": 0,
"spare_number_5": 0,
"spare_number_6": 0,
"spare_number_7": 0,
"spare_number_8": 0,
"spare_number_9": 0,
"spare_number_10": 0,
"spare_bool_1": false,
"spare_bool_2": false,
"spare_bool_3": false,
"spare_bool_4": false,
"spare_bool_5": false,
"value_of_current_orders_in_sop": 0,
"duns_code": "",
"average_time_to_pay": 0,
"finance_charge_id": 0,
"office_type": "Independent",
"associated_head_office_id": 0,
"produce_statements_for_customer": false,
"use_consolidated_billing": false,
"use_tax_code_as_default": false,
"invoice_discount_percent": 0,
"invoice_line_discount_percent": 0,
"customer_discount_group_id": 0,
"order_value_discount_id": 0,
"price_band_id": 1064,
"id": 82660,
"date_time_created": "2024-05-23T22:04:20.567Z",
"date_time_updated": "2024-05-23T22:04:22.863Z"
}
}

Get Customer Contact

Retrieve a customer contact by ID | key: getCustomerContact

InputDefaultNotesExample
Company
string
/ Required
company
The company ID. You can get and reference this value from the 'Get Site and Company Information' action.
14123
Connection
connection
/ Required
connection
 
 
 
Customer Contact ID
string
/ Required
customerContactId
The ID of the customer contact to retrieve
27914
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Site
string
/ Required
site
The site ID. You can get and reference this value from the 'Get Site and Company Information' action.
9e12a1b-caa9-ca01-dcca-08dc12dd123a

{
"data": {
"customer_id": 27825,
"salutation_id": 0,
"name": "Art Vandelay Dalkin",
"first_name": "Art",
"middle_name": "Vandelay",
"last_name": "Dalkin",
"is_default": true,
"default_telephone": "01742 876 234",
"default_email": "newbusinessadvice@sage.com",
"id": 27914,
"date_time_created": "2024-02-28T14:06:36.887Z",
"date_time_updated": "2024-05-23T09:25:16.827Z"
}
}

Get Customer Delivery Address

Retrieve customer delivery address by ID | key: getCustomerDeliveryAddress

InputDefaultNotesExample
Company
string
/ Required
company
The company ID. You can get and reference this value from the 'Get Site and Company Information' action.
14123
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Delivery Address ID
string
/ Required
deliveryAddressId
The ID of the customer delivery addresses to retrieve.
82780
Site
string
/ Required
site
The site ID. You can get and reference this value from the 'Get Site and Company Information' action.
9e12a1b-caa9-ca01-dcca-08dc12dd123a

{
"data": {
"contact": "Lee Dalkin",
"country": "",
"customer_id": 27825,
"description": "Registered address",
"email": "newbusinessadvice@sage.com",
"fax": "01742 876 236",
"is_default": false,
"postal_name": "A1 Design Services",
"tax_code_id": 1729,
"tax_number": "GB238 3839 38",
"telephone": "01742 876 234",
"country_code_id": 13,
"address_1": "67a Station Road",
"address_2": "",
"address_3": "Blackpool",
"address_4": "Lancashire",
"city": "",
"county": "",
"postcode": "BP12 7HT",
"address_country_code_id": 0,
"id": 27927,
"date_time_created": "2024-02-28T14:06:36.983Z",
"date_time_updated": "2024-02-28T14:23:46.867Z"
}
}

Get Customer Price Band

Retrieve a customer price band by ID | key: getCustomerPriceBand

InputDefaultNotesExample
Company
string
/ Required
company
The company ID. You can get and reference this value from the 'Get Site and Company Information' action.
14123
Connection
connection
/ Required
connection
 
 
 
Customer Price Band ID
string
/ Required
customerPriceBandId
The ID of the customer price band to retrieve
1064
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Site
string
/ Required
site
The site ID. You can get and reference this value from the 'Get Site and Company Information' action.
9e12a1b-caa9-ca01-dcca-08dc12dd123a

{
"data": {
"customer_id": 27828,
"price_band_id": 37419,
"id": 44501,
"date_time_created": "2024-07-22T09:31:04.257Z",
"date_time_updated": "2024-02-28T14:23:46.01Z"
}
}

Get Items on a Sales Order

Retrieve a list of items attached to a sales order | key: getItemsOnSalesOrder

InputDefaultNotesExample
Company
string
/ Required
company
The company ID. You can get and reference this value from the 'Get Site and Company Information' action.
14123
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Order Line ID
string
/ Required
orderLineId
The Sales Order Line ID. This can be found in the Sales Order Line 'lines' array attribute.
38292
Site
string
/ Required
site
The site ID. You can get and reference this value from the 'Get Site and Company Information' action.
9e12a1b-caa9-ca01-dcca-08dc12dd123a

{
"data": {
"sop_order_id": 84180,
"line_number": 1,
"line_type": "EnumLineTypeStandard",
"code": "BOARD001",
"description": "Whiteboard - Drywipe (900 x 1200)",
"use_description": false,
"tax_code_id": 1729,
"nominal_reference": "4000",
"nominal_cost_centre": "",
"nominal_department": "",
"line_quantity": 1,
"to_allocate_quantity": 1,
"allocated_quantity": 1,
"despatch_receipt_quantity": 0,
"invoice_credit_quantity": 0,
"posted_invoice_credit_quantity": 0,
"available_for_despatch": 1,
"stock_unit_line_quantity": 1,
"stock_unit_to_allocate_quantity": 1,
"stock_unit_allocated_quantity": 1,
"stock_unit_despatch_receipt_quantity": 0,
"stock_unit_invoice_credit_quantity": 0,
"stock_unit_posted_invoice_credit_quantity": 0,
"stock_unit_available_for_despatch": 1,
"stock_unit_available_quantity": 106,
"allocation_status": "EnumLineStatusFully",
"despatch_receipt_status": "EnumLineStatusNone",
"invoice_credit_status": "EnumLineStatusNone",
"selling_unit_description": "Each",
"pricing_unit_description": "Each",
"line_unit_precision": 0.00001,
"stock_unit_precision": 0.00001,
"selling_unit_multiple": 1,
"stock_unit_multiple": 1,
"selling_unit_price": 20,
"unit_discount_percent": 0,
"unit_discount_value": 0,
"discounted_unit_price": 20,
"cost_price": 13.2,
"discount_percent_specified": false,
"selling_unit_price_overridden": false,
"unit_discount_overridden": false,
"retain_manual_prices": false,
"fulfilment_method": "EnumFulfilmentFromStock",
"picking_list_comment": "",
"despatch_note_comment": "",
"show_on_customer_docs": true,
"show_on_picking_list_type": "Show",
"confirmation_intent_type": "ConfirmOnDespatch",
"has_pop_order": false,
"back_to_back_status": "EnumBackToBackStatusPONotReq",
"is_complete": false,
"is_line_deletable": true,
"line_total_value": 20,
"line_tax_value": 4,
"requested_delivery_date": "2024-05-24T00:00:00Z",
"promised_delivery_date": "2024-05-24T00:00:00Z",
"analysis_code_1": "",
"analysis_code_2": "",
"analysis_code_3": "",
"analysis_code_4": "",
"analysis_code_5": "",
"analysis_code_6": "",
"analysis_code_7": "",
"analysis_code_8": "",
"analysis_code_9": "",
"analysis_code_10": "",
"analysis_code_11": "",
"analysis_code_12": "",
"analysis_code_13": "",
"analysis_code_14": "",
"analysis_code_15": "",
"analysis_code_16": "",
"analysis_code_17": "",
"analysis_code_18": "",
"analysis_code_19": "",
"analysis_code_20": "",
"spare_text_1": "",
"spare_text_2": "",
"spare_text_3": "",
"spare_text_4": "",
"spare_text_5": "",
"spare_text_6": "",
"spare_text_7": "",
"spare_text_8": "",
"spare_text_9": "",
"spare_text_10": "",
"spare_number_1": 0,
"spare_number_2": 0,
"spare_number_3": 0,
"spare_number_4": 0,
"spare_number_5": 0,
"spare_number_6": 0,
"spare_number_7": 0,
"spare_number_8": 0,
"spare_number_9": 0,
"spare_number_10": 0,
"spare_bool_1": false,
"spare_bool_2": false,
"spare_bool_3": false,
"spare_bool_4": false,
"spare_bool_5": false,
"product_id": 34751,
"warehouse_id": 34627,
"id": 84181,
"date_time_created": "2024-05-24T08:51:22.257Z",
"date_time_updated": "2024-05-24T08:51:22.883Z"
}
}

Get Price Band

Retrieve a price band by ID | key: getPriceBand

InputDefaultNotesExample
Company
string
/ Required
company
The company ID. You can get and reference this value from the 'Get Site and Company Information' action.
14123
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Price Band ID
string
/ Required
priceBandId
The ID of the price band to retrieve
1064
Site
string
/ Required
site
The site ID. You can get and reference this value from the 'Get Site and Company Information' action.
9e12a1b-caa9-ca01-dcca-08dc12dd123a

{
"data": {
"name": "Standard",
"description": "Standard",
"is_standard_band": true,
"currency_id": 2103,
"price_band_type_id": 0,
"price_band_type": "Universal",
"is_active": true,
"is_time_based": false,
"id": 1064,
"date_time_created": "2024-02-28T14:03:39.973Z",
"date_time_updated": "2024-02-28T14:23:46.183Z"
}
}

Get Product

Retrieve a product by ID | key: getProduct

InputDefaultNotesExample
Company
string
/ Required
company
The company ID. You can get and reference this value from the 'Get Site and Company Information' action.
14123
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Product ID
string
/ Required
productId
The ID of the product to retrieve.
35738
Site
string
/ Required
site
The site ID. You can get and reference this value from the 'Get Site and Company Information' action.
9e12a1b-caa9-ca01-dcca-08dc12dd123a

{
"data": {
"code": "BOARD001",
"name": "Whiteboard - Drywipe (900 x 1200)",
"description": "Whiteboard - Drywipe (900 x 1200) Updated",
"use_description_on_documents": false,
"barcode": "",
"allow_sales_order": true,
"free_stock_quantity": 107,
"product_group_id": 34640,
"tax_code_id": 1729,
"product_status_type": "EnumStockItemStatusTypeActive",
"fulfilment_method_type": "EnumFulfilmentFromStock",
"fulfilment_sequence_type": "EnumBinPriority",
"manufacturer": "",
"part_number": "WB/U143-78243/2437032ALX4/24369/DW1200X900",
"label_printing_option_type": "EnumNotRequired",
"traceable_type": "EnumTraceableTypeNone",
"sale_from_single_batch": false,
"allow_duplicate_numbers": false,
"uses_alternative_ref": false,
"uses_sell_by_date": false,
"uses_use_by_date": false,
"shelf_life": 0,
"shelf_life_type": "EnumTimeUnitDay",
"record_nos_on_goods_received": false,
"include_nos_on_count_sheets": true,
"auto_generate_option_type": "EnumDoNotGenerate",
"auto_generate_separator_id": 1,
"auto_generate_prefix": "",
"auto_generate_next_number": 1,
"auto_generate_padding": 0,
"stocktake_cycle_period": 0,
"standard_cost": 15,
"average_buying_price": 13.2,
"default_picking_list_comment": "",
"default_despatch_note_comment": "",
"commodity_code": "",
"country_of_origin_id": 0,
"weight": 0,
"suppress_mass_on_declaration": false,
"is_weee_item": false,
"use_supplementary_units": false,
"supplementary_unit_conversion_ratio": 1,
"use_reverse_charge_vat_rules": false,
"analysis_code_1": "",
"analysis_code_2": "",
"analysis_code_3": "",
"analysis_code_4": "",
"analysis_code_5": "",
"analysis_code_6": "",
"analysis_code_7": "",
"analysis_code_8": "",
"analysis_code_9": "",
"analysis_code_10": "",
"analysis_code_11": "",
"analysis_code_12": "",
"analysis_code_13": "",
"analysis_code_14": "",
"analysis_code_15": "",
"analysis_code_16": "",
"analysis_code_17": "",
"analysis_code_18": "",
"analysis_code_19": "",
"analysis_code_20": "",
"spare_text_1": "",
"spare_text_2": "",
"spare_text_3": "",
"spare_text_4": "",
"spare_text_5": "",
"spare_text_6": "",
"spare_text_7": "",
"spare_text_8": "",
"spare_text_9": "",
"spare_text_10": "",
"spare_number_1": 0,
"spare_number_2": 0,
"spare_number_3": 0,
"spare_number_4": 0,
"spare_number_5": 0,
"spare_number_6": 0,
"spare_number_7": 0,
"spare_number_8": 0,
"spare_number_9": 0,
"spare_number_10": 0,
"spare_bool_1": false,
"spare_bool_2": false,
"spare_bool_3": false,
"spare_bool_4": false,
"spare_bool_5": false,
"landed_costs_type": "EnumNotApplicable",
"landed_costs_percentage": 0,
"landed_costs_per_item": 0,
"bom_item_type": "EnumBOMItemTypeComponent",
"id": 34751,
"date_time_created": "2024-02-28T14:06:51.043Z",
"date_time_updated": "2024-05-24T00:27:17.897Z"
}
}

Get Product Group

Retrieve a product group by ID | key: getProductGroup

InputDefaultNotesExample
Company
string
/ Required
company
The company ID. You can get and reference this value from the 'Get Site and Company Information' action.
14123
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Product Group ID
string
/ Required
productGroupId
The ID of the product group to retrieve.
34634
Site
string
/ Required
site
The site ID. You can get and reference this value from the 'Get Site and Company Information' action.
9e12a1b-caa9-ca01-dcca-08dc12dd123a

{
"data": {
"code": "0001",
"description": "Paper Products",
"product_type": "EnumStockItemTypeStock",
"costing_method": "EnumCostingMethodTypeFIFO",
"stocktake_cycle_period": 0,
"label_printing_option_type": "EnumNotRequired",
"keep_movement_history": true,
"can_levels_go_negative": true,
"can_over_allocate_negative_stock": false,
"use_description_on_documents": false,
"use_reverse_charge_vat_rules": false,
"do_items_use_units": false,
"selling_quantities_use_multiple_units": false,
"selling_prices_use_multiple_units": false,
"buying_quantities_use_multiple_units": false,
"buying_prices_use_multiple_units": false,
"do_items_use_markup": false,
"use_landed_costs": false,
"landed_costs_type": "EnumNotApplicable",
"landed_costs_percentage": 0,
"landed_costs_per_item": 0,
"this_is_the_sop_product_group": false,
"traceable_type": "EnumTraceableTypeNone",
"sale_from_single_batch": false,
"allow_duplicate_numbers": false,
"uses_alternative_ref": false,
"uses_sell_by_date": false,
"uses_use_by_date": false,
"id": 34634,
"date_time_created": "2024-02-28T14:06:50.347Z",
"date_time_updated": "2024-02-28T14:23:46.31Z"
}
}

Get Product Price Views

Returns the selling prices of your products. A price is returned for each price band associated with a product. | key: getProductPriceViews

InputDefaultNotesExample
Company
string
/ Required
company
The company ID. You can get and reference this value from the 'Get Site and Company Information' action.
14123
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Site
string
/ Required
site
The site ID. You can get and reference this value from the 'Get Site and Company Information' action.
9e12a1b-caa9-ca01-dcca-08dc12dd123a

{
"data": [
{
"product_price_id": 34760,
"product_id": 34751,
"product_code": "BOARD001",
"product_name": "Whiteboard - Drywipe (900 x 1200)",
"product_stock_unit_name": "Each",
"price_band_id": 1064,
"price_band_name": "Standard",
"product_price_use_standard": true,
"product_price_price": 20,
"currency_id": 2103,
"currency_name": "Pound Sterling",
"currency_symbol": "£",
"date_time_updated": "2024-02-28T14:23:46.787Z"
}
]
}

Get Sales Invoice, Return, and Credit Views

Retrieve a view of sales orders and returns and invoices and credit notes. | key: getSalesInvoiceReturnCreditViews

InputDefaultNotesExample
Company
string
/ Required
company
The company ID. You can get and reference this value from the 'Get Site and Company Information' action.
14123
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Site
string
/ Required
site
The site ID. You can get and reference this value from the 'Get Site and Company Information' action.
9e12a1b-caa9-ca01-dcca-08dc12dd123a

{
"data": [
{
"customer_id": 27906,
"customer_reference": "SWA001",
"customer_name": "Swan Leisure Centre",
"sop_invoice_credit_id": 80700,
"sop_invoice_credit_type": "EnumInvoiceCreditTypeCredit",
"sop_invoice_credit_document_no": "0000000102",
"sop_invoice_credit_document_date": "2024-03-05T00:00:00Z",
"sop_invoice_credit_document_status": "EnumDocumentStatusDraft",
"sop_invoice_credit_exchange_rate": 1,
"sop_invoice_credit_date_time_updated": "2024-03-05T10:27:25.87Z",
"sop_invoice_credit_line_id": 80701,
"sop_invoice_credit_line_invoice_credit_date": "2024-03-05T00:00:00Z",
"sop_invoice_credit_line_total_value": 75,
"sop_invoice_credit_line_tax_value": 15,
"sop_invoice_credit_line_date_time_updated": "2024-03-05T10:27:25.863Z",
"product_id": 35092,
"product_code": "LAM001",
"product_name": "Laminator - A4",
"product_description": "Laminator - A4",
"product_date_time_updated": "2025-08-01T16:00:33.14Z",
"product_group_id": 34641,
"product_group_code": "0007_MISC",
"product_group_description": "Business Machines_MISC",
"product_group_date_time_updated": "2024-02-28T14:23:46.31Z"
}
]
}

Get Sales Order

Retrieve an existing sales order by ID | key: getSalesOrder

InputDefaultNotesExample
Company
string
/ Required
company
The company ID. You can get and reference this value from the 'Get Site and Company Information' action.
14123
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Sales Order ID
string
/ Required
salesOrderId
Sales order ID to retrieve
38294
Site
string
/ Required
site
The site ID. You can get and reference this value from the 'Get Site and Company Information' action.
9e12a1b-caa9-ca01-dcca-08dc12dd123a

{
"data": {
"is_credit_limit_exceeded": true,
"payment_with_order": false,
"invoice_payment_with_order_immediately": false,
"payment_value": 0,
"payment_reference": "",
"payment_method_id": 0,
"payment_declared": 0,
"payment_undeclared": 0,
"declared_payment_remaining": 0,
"document_no": "0000000001",
"document_date": "2023-01-02T00:00:00Z",
"document_status": "EnumDocumentStatusComplete",
"despatch_receipt_status": "EnumDocumentProcessStatusFull",
"invoice_credit_status": "EnumDocumentProcessStatusFull",
"cancelled_status": "EnumDocumentProcessStatusNone",
"customer_type": "EnumCustomerTypeCredit",
"customer_id": 27867,
"currency_id": 2103,
"is_draft": false,
"exchange_rate": 1,
"subtotal_goods_value": 9583.2,
"subtotal_charge_net_value": 0,
"subtotal_charge_tax_value": 0,
"subtotal_discount_value": 0,
"total_net_value": 9583.2,
"total_tax_value": 1635.13,
"total_gross_value": 11218.33,
"customer_document_no": "",
"use_invoice_address": false,
"is_triangulated": false,
"settlement_discount_days": 30,
"settlement_discount_percent": 2.5,
"document_discount_percent": 0,
"document_created_by": "",
"order_priority": "",
"analysis_code_1": "",
"analysis_code_2": "",
"analysis_code_3": "",
"analysis_code_4": "",
"analysis_code_5": "",
"analysis_code_6": "",
"analysis_code_7": "",
"analysis_code_8": "",
"analysis_code_9": "",
"analysis_code_10": "",
"analysis_code_11": "",
"analysis_code_12": "",
"analysis_code_13": "",
"analysis_code_14": "",
"analysis_code_15": "",
"analysis_code_16": "",
"analysis_code_17": "",
"analysis_code_18": "",
"analysis_code_19": "",
"analysis_code_20": "",
"spare_text_1": "",
"spare_text_2": "",
"spare_text_3": "",
"spare_text_4": "",
"spare_text_5": "",
"spare_text_6": "",
"spare_text_7": "",
"spare_text_8": "",
"spare_text_9": "",
"spare_text_10": "",
"spare_number_1": 0,
"spare_number_2": 0,
"spare_number_3": 0,
"spare_number_4": 0,
"spare_number_5": 0,
"spare_number_6": 0,
"spare_number_7": 0,
"spare_number_8": 0,
"spare_number_9": 0,
"spare_number_10": 0,
"spare_bool_1": false,
"spare_bool_2": false,
"spare_bool_3": false,
"spare_bool_4": false,
"spare_bool_5": false,
"external_reference": "",
"id": 38294,
"date_time_created": "2024-02-28T14:06:55.723Z",
"date_time_updated": "2024-02-28T14:23:45.69Z"
}
}

Get Site and Company Information

Get Site and Company ID's information for all sites the authenticated user has access to. | key: getSiteAndCompanyInformation

InputDefaultNotes
Connection
connection
/ Required
connection
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.

{
"data": [
{
"company_id": 123,
"company_name": "APITestCompany",
"tenant_id": 1234,
"site_id": "XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX",
"site_name": "Demodata",
"site_short_name": "xxxxxxxxxx"
}
]
}

Get Tax Code

Retrieve a tax code by ID | key: getTaxCode

InputDefaultNotesExample
Company
string
/ Required
company
The company ID. You can get and reference this value from the 'Get Site and Company Information' action.
14123
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Site
string
/ Required
site
The site ID. You can get and reference this value from the 'Get Site and Company Information' action.
9e12a1b-caa9-ca01-dcca-08dc12dd123a
Tax Code ID
string
/ Required
taxCodeId
The ID of the tax code to retrieve
16

{
"data": {
"code": 16,
"name": "Purchase Services ROW (Reverse Charge)",
"tax_rate": 20,
"terms": "EcTermsPurchaseNonRelatedServices",
"terms_description": "Purchase Non-Related Services",
"is_notional_acquisition_tax": true,
"id": 16,
"date_time_created": "2024-11-06T11:41:16.86Z",
"date_time_updated": "2024-11-06T11:41:16.86Z"
}
}

List Customer Contacts

Retrieve a list of customer contacts | key: listCustomerContacts

InputDefaultNotesExample
Company
string
/ Required
company
The company ID. You can get and reference this value from the 'Get Site and Company Information' action.
14123
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Filter Data After Date
string
filterDataAfterDate
Filter data to only include items that have been updated after this date.
2021-01-01T00:00:00Z
Site
string
/ Required
site
The site ID. You can get and reference this value from the 'Get Site and Company Information' action.
9e12a1b-caa9-ca01-dcca-08dc12dd123a

{
"data": [
{
"customer_id": 27825,
"salutation_id": 0,
"name": "Art Vandelay Dalkin",
"first_name": "Art",
"middle_name": "Vandelay",
"last_name": "Dalkin",
"is_default": true,
"default_telephone": "01742 876 234",
"default_email": "newbusinessadvice@sage.com",
"id": 27914,
"date_time_created": "2024-02-28T14:06:36.887Z",
"date_time_updated": "2024-05-23T09:25:16.827Z"
}
]
}

List Customer Delivery Addresses

Retrieve a list of customer delivery addresses | key: listCustomerDeliveryAddresses

InputDefaultNotesExample
Company
string
/ Required
company
The company ID. You can get and reference this value from the 'Get Site and Company Information' action.
14123
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Filter Data After Date
string
filterDataAfterDate
Filter data to only include items that have been updated after this date.
2021-01-01T00:00:00Z
Site
string
/ Required
site
The site ID. You can get and reference this value from the 'Get Site and Company Information' action.
9e12a1b-caa9-ca01-dcca-08dc12dd123a

{
"data": [
{
"contact": "Lee Dalkin",
"country": "",
"customer_id": 27825,
"description": "Registered address",
"email": "newbusinessadvice@sage.com",
"fax": "01742 876 236",
"is_default": false,
"postal_name": "A1 Design Services",
"tax_code_id": 1729,
"tax_number": "GB238 3839 38",
"telephone": "01742 876 234",
"country_code_id": 13,
"address_1": "67a Station Road",
"address_2": "",
"address_3": "Blackpool",
"address_4": "Lancashire",
"city": "",
"county": "",
"postcode": "BP12 7HT",
"address_country_code_id": 0,
"id": 27927,
"date_time_created": "2024-02-28T14:06:36.983Z",
"date_time_updated": "2024-02-28T14:23:46.867Z"
}
]
}

List Customer Price Bands

Retrieve a list of customer price bands | key: listCustomerPriceBands