This article outlines the implementation of external reporting in OutSystems Developer Cloud (ODC) using Power BI, JSON, and OneDrive. It outlines how the team addressed technical constraints without compromising application performance, utilizing automated incremental data exports to maintain accurate, lightweight, and up-to-date reports.

This article provides a step-by-step guide on integrating Google Sheets with OutSystems applications for streamlined data management. Learn how to set up your environment, retrieve data from Google Sheets, and display it on your app screens. The guide covers setting up the Google Sheets Rest API, obtaining tokens via the Google API Token helper, and configuring the Google API Service Account.

A data structure must be defined beforehand when importing or exporting an excel file through the built-in OutSystems feature. Although this works for most situations, a different approach is needed when the number of columns is not specified or is data-dependent. So, how can we work around not using a known data structure?

A data migration might be a long and painful process, and if you are here, it’s probably because you’re one of the lucky few that will have a taste. So, you have come to the right place; we are here to help!