Vitruvi Developer Hub

Welcome to the Vitruvi developer hub. You'll find comprehensive guides and documentation to help you start working with Vitruvi as quickly as possible, as well as support if you get stuck. Let's jump right in!

Vitruvi Integration

Vitruvi data integration is provided through an open but secured set of RESTful web APIs. These APIs can be used for many purposes but are primarily used for ETL tools, integrating with ERP systems and for reporting through tools such as Power Query for Excel, Power BI.

The intention of this document is not to be a complete resource for the underlying technologies but rather to highlight specific common use cases for interacting with Vitruvi.

APIs

Vitruvi uses a RESTful API to interact with its services. It uses standard HTTP requests and responses with JSON objects.

Scripting

Vitruvi has a scripting engine that allows for various actions to be automated inside of Vitruvi.

Unfortunately, due to their nature, writing scripts is solely the domain of Vitruvi Technical Services and not something our clients can access.

If you want to explore using scripts to automate tasks, please get in touch with your Customer Success Manager for more details.

Power Query

Tools such as Power BI, Excel and Microsoft Power Apps all use Power Query to retrieve and pre-process data before passing it into applications like Excel or Power BI. It is often described as a data transformation and data preparation engine.

As of Excel 2016, Power Query is included with the Excel installation. Before Excel 2016 it was a standalone installation that needed to be downloaded directly from Microsoft.

Power Query is useful to get Vitruvi data into Excel and Power BI for further reporting and analysis.