Invantive Cloud: run a SQL query on Exact Online, including joins.Access OData: download data choosing one of the over 1.000 Exact Online tables, based upon Invantive Cloud.Get My Report: download data using pre-defined queries.
The following approaches are to available to import data from Exact into Google spreadsheets: This guide explains how to real-time download data from Exact Online into Google Sheets.Īlthough not described here, you can use the same Invantive technologies to upload data from Google Sheets into Exact Online. Downloading data from a cloud solution such as Exact Online into Google Sheets may seem daunting. However, it is somewhat more limited than the Office apps from Microsoft which have been around for over twenty years and matured well. Google Sheets provides from the foundation up both platform independence and online collaboration and runs on many platforms, including MacOS. Within the creative industry we see a lot of people using Google Sheets within a browser as an alternative for Microsoft Excel on a PC. The current (2021) approach to download Exact Online into Google Sheets is described at Hoe kan ik openstaande posten en bankmutaties downloaden in Google Sheets vanuit Exact Online?.
Currently it may be possible to use OData v4 download using Google Sheets with the steps described on Use data from an OData feed - AppSheet Help.
0 kommentar(er)
