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’2016-01-01T00:00:00′ and Date le datetime’2016-12-31T00:00:00′   Definition Example and explanation Equivalent C/AL expression […]

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 […]