d2-sql-insert.sql - daily dump that includes DROP TABLE, CREATE TABLE and INSERT statements, to replace all existing tables + data.
d2-sql-update.sql - daily dump that uses REPLACE INTO statements to update any existing data.
For clarification there is no Defacto2 API.
Currently, the source code to Defacto2 is not open, but the medium-term goal is to have it publically accessible on GitHub.
Defacto2 has a GitHub page at github.com/defacto2 where you can find notes and wikis for Defacto2 and repositories for historical scene websites. As well the defacto2.net repository where you can submit issues and feature requests for this website.