bschalme/qbd-api repository overview

⁠QBD API

An API for QuickBooks Desktop (QBD). This uses the MySQL database created by Synergration's OpenSync⁠ as its backing datastore. You simply issue REST-ful HTTP calls against QBD API and it will fetch and persist the data.

Of course, you will need OpenSync running and a licensed copy of QuickBooks Desktop to synchronize the MySQL database with QuickBooks.

⁠To run QBD API Against a MySQL Database

1. Edit build.gradle and comment out the H2 dependency and un-comment the MySQL dependency;
2. Un-comment the DataSource bean in Application.java; and
3. Instead of an application.properties file, QBD API uses Spring Cloud Config⁠ at localhost:8888. Make a qbd-api.properties in the Spring Cloud Config server that holds these properties, substituting the placeholders for real values:

configuration.projectName = qbd-api
spring.datasource.url = jdbc:mysql://${hostname}:3306/${databaseName}?useSSL=false
spring.datasource.username = ${dbUsername}
spring.datasource.password = ${dbPassword}
spring.jpa.hibernate.naming.physical-strategy = org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl

The PhysicalNamingStrategyStandardImpl is important because QuickBooks uses UpperCamelCase instead of snake_case for their table and column names.

Build it and run it.