The OData filter function It is possible to get OData to return selected data only by using a filter.   For example, for a debtor: https://odata.uniconta.com/odata/DebtorClient?$filter=Account eq ‘1101798’   For example, for debtor transactions for a certain date range: https://odata.uniconta.com/odata/DebtorTransClient?$filter=Date ge datetime’2021-01-01T00:00:00′ and Date le datetime’2021-12-31T00:00:00′   Eg. Finance in date range https://odata.uniconta.com/odata/DebtorTransClient?$filter=Date ge datetime’2021-01-01T00:00:00′ […]

It is possible to have direct ‘Read Only’ access to Uniconta from Excel. The minimum excel requirement is Office 365 or Excel 2016. Get data Select data in the Excel menu Select ”New Query” Select ”From Other Sources” Select ”From OData Data Feed” Enter the URL, including any filters Enter the Username and Password. The […]