What is RQL
RQL (REST Query Language) is a simple, readable way to filter and retrieve live data from Sage 50 using your REST Server. It lets users ask for exactly what they need—without downloading entire datasets or writing complex SQL.
Think of it as an innovative search engine for your accounting data.
How it works
RQL uses intuitive filter expressions in the URL to define what data you want. These filters are passed as query parameters to your REST endpoints.
This example asks for invoices where the customer name is “Acme Corp”.
GET /v1/sj/list?filter=eq(CustomerName,'Acme Corp')Shows Invoices with no ship date
GET /v1/sj/list?filter=isnull(ShipDate)Find inventory items with “widget” in the Item Description:
GET /v1/inv/list?filter=contains(ItemDescription,'widget')Your REST Server uses RQL to expose live, read-only Sage 50 data—perfect for dashboards, mobile apps, and integrations that need real-time visibility without risking data changes.