This post contains the details to be used in the in-person Linx training.
Resources:
Here are the resources that you will need during the training:
CSV
Here is the CSV file that you will need during the training:
clients.csv (5.0 KB)
Database:
Here is the SQLite database:
TrainingDB.zip (899 Bytes)
Unzip it and place it somewhere - this is the database you will be setting up in the ODBC connection.
API
-
API Documentation: Swagger UI
-
Api Endpoints:
Setup
Before you start building in Linx, you need to set up your database environment. You can use any database technology you want, however in the tutorial video a specific SQLite database is used. You will need to set up the ODBC connection to connect to this database. This can be done with the following steps:
-
Download and install the SQLite ODBC driver from: [SQLite ODBC Driver (ch-werner.de)](SQLite ODBC Driver)
-
Specifically, you will need to download sqliteodbc_w64.exe: http://www.ch-werner.de/sqliteodbc/sqliteodbc_w64.exe
-
Download the database from above and unzip the file into a folder on your computer
-
You can now connect to the SQLite database in Linx by using a properly configured connection string. The connection string will have the following format:
Driver={SQLite3 ODBC Driver};Database=MyFilePath;
MyFilePath will be the full file path of the database, so if you placed it in C:\Training\DB\ you will have a connection string that looks like this:
Driver={SQLite3 ODBC Driver};Database=C:\Training\DB\TrainingDB.db;
See Connection Editor for more details.