Python Tutorial

Learn how the Export API can be used with Python to extract intersections and hierarchy data out of a Vena data model and prepared for loading into a downstream system.

Why use this feature?

In this article, we’ll show you how to load intersections and hierarchy data into a Pandas DataFrame, which is a popular method to represent tabular data in Python. We will also provide coding examples that may be useful for your integration, for example how to implement pagination with our API.

Before you begin

To follow the instructions in this article, you will need at least Modeler access.

You will also need an application token from Vena. You can get your application token by following these instructions.

The API also requires the model ID of the data model you will export data from. Follow these steps to find the model ID.

Python tutorials

In the following tutorials, we will show how to export intersections, filter intersections, and export hierarchy data with Python using Vena’s Export API. Make sure to use Python3 to follow along with these examples.