Power BI Connector for Sage Business Cloud Accounting

Build 22.0.8342


Query AddressRegions in Sage Business Cloud Accounting.

Table Specific Information

Query the available AddressRegions


The driver uses the Sage Accounting API to process search criteria that refer to CountryId column. The driver processes other filters client-side within the driver.

  • CountryId supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM AddressRegions WHERE CountryId='AF'


Name Type References Description
Id [KEY] String The unique identifier for the item
Name String The name of the address region
Code String The code of the address region
DisplayedAs String Display text for the item
LegacyId Int The legacy ID for the item
CountryId String

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 22.0.8342