Power BI Connector for Exact Online

Build 24.0.9060

Division

The Division associated with the Exact Online administration.

Data Type

string

Default Value

""

Remarks

The Division associated with the Exact Online administration. You can determine the Divisions associated with your account by browsing to MyExactOnlineSite/api/v1/current/Me?$select=CurrentDivision. The Exact Online site is determined by your Region. The value of the CurrentDivision element in the response contains the division code.

If you are unsure of your Division, you can leave the Division blank, and the connector sends a request to Exact Online to retrieve the default Division value for internal use.

After you connect, you can query the Division view to retrieve the Divisions associated with your account.

To access multiple divisions, set Division=All; the SchemaName is the value of division. You can access the table as shown below,

 select * from [12345].Accounts 
where 12345 is the division value.

See the "Getting Started" chapter in the Exact Online developer documentation for more information on Exact Online sites.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060