Find out how to use the new Vertabelo Public API to access data models, SQL scripts, and more. One of the signs of a decent SaaS solution is its public API. A good API helps users to incorporate some automation into an application. Based on our experience in using other SaaS services, we have introduced a more document-oriented version of our public API. In this article, we will demonstrate how to use Vertabelo API to fetch a list of documents (models), SQL scripts, and data models in various formats.
If you need to automatically download SQL script from Vertabelo, for example, for the purposes of your build system, you definitely should check out our Vertabelo API. It allows you to download an SQL or XML of your model by a simple HTTP request. In the command line, it may look like this: VERTABELO_API_TOKEN=put-your-api-token-here MODEL_ID=put-your-model-identifier-here curl -u $VERTABELO_API_TOKEN: \ https://my.vertabelo.com/api/sql/$MODEL_ID create-database.sql To learn more about Vertabelo API, go here.
Generating a token We've added an API to our Vertabelo application to help you incorporate some automation into your build system. Here is a short instruction on how to use the Vertabelo API. First of all, you have to enable access to the API. You'll need have at least a "Basic" account plan or be a member of a company. Go to the My account page. Scroll down to the Settings section.