Can only retrieve data for the first division of a client.
Example of query:
SELECT AmountDC , Date , Description , FinancialPeriod , FinancialYear , GLAccount , GLAccountCode , GLAccountDescription , Type FROM ExactOnlineREST.FinancialTransaction.TransactionLinesBulk Where FinancialYear = x AND Division = y
We’re connecting through an ODBC connector for OData connections. Due to limitations when it comes to OData connections in our BI-tooling. It worked fine until we went from the free trial to production.