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′ […]
unipedia
- Introduction
- Get started with Uniconta
- Which browser are you using?
- Get started with an existing set of accounts
Search
Transfer data from Uniconta to Excel
May 9th, 2017 by Jørn RejndrupIt 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 […]