I have managed to connect a FM database to an online Wordpress website database via ODBC. This way I can access all SQL tables directly from my FM database. I even found a free ODBC driver (MySQL ODBC 5.3 ANSI Driver) which worked (on my Mac)! There is also a paid version from Actual, which is recommended by FileMaker.
I did not setup a WooCommerce webshop yet but I assume all tables can be read out directly just as the Wordpress tables and can be imported into FM for further processing (products, prices, transactions, registrations, etc.).
But I wonder if there are any downsides compared to using an API. I have very little experience with API's and seems not the easiest thing to learn so I thought this was a good and less complicated approach.
What are the benefits using the API if you can access the SQL-DB directly?
Any advice is welcome.