OutSystems offers several ways of incorporating content from external sources into applications, such as:
Using APIs (REST, SOAP) to connect
Connecting directly to external databases
Importing data from files like Excel, CSV, XML, and JSON.
This article addresses Excel, CSV, XML, and JSON formats.
Importing and exporting data from Excel or JSON
Developers can easily import and export data from Excel or JSON directly from the toolbox:
If developers need tighter control of an Excel export, they can use a Forge component called Advanced Microsoft Excel. This component supports data formatting, the creation of Excel charts, and ability to fill in specific cells by providing row and column numbers.