Incremental does not perform deletes

[jashwood]

When an inspection_item is deleted in the front end, the incremental refresh does not remove it from the target database.
SQL Server in our case.

[hkf57]

Hey @jashwood, could I get the command you are running and your config file?

[jashwood]

Hey, here are the details.
From what I have seen in the code of the exporter, it will never perform deletes on the target database, is that correct?
So if an object is deleted in the front end, the only way to delete it from the target database is to drop the table and repopulate it fully?

Command :-
c:\teambi\iAuditor\iAuditorExporter\iauditor-exporter.exe sql --db-dialect sqlserver --db-connection-string sqlserver://ourdatabase --config-path "C:\TeamBI\iAuditor\iAuditorExporter\iauditor-exporter-config.yaml"

Config File

access_token: "##########################"
api:
proxy_url: ""
tls_cert: ""
tls_skip_verify: false
url: https://api.safetyculture.io
db:
connection_string: ""
dialect: sqlserver
export:
incremental: true
inspection:
archived: "false"
completed: "true"
included_inactive_items: false
limit: 50
skip_ids: []
media: false
media_path: ./export/media/
modified_after: "2000-01-01"
path: ./export/
site:
include_deleted: false
tables: []
template_ids: []
report:
filename_convention: INSPECTION_TITLE
format:

• PDF
  preference_id: ""