To refresh data
and delete already-present data, you have two API-driven options, depending on your sync mode and goal: ### 1. Use a
Clear (erase all records, then re-sync) A
Clear removes all records that Airbyte has written for the selected connection/stream(s); tables stay but are emptied. You then run a normal sync to reload data from the source.[\[Clear guide\]](
https://docs.airbyte.com/platform/operator-guides/clear) - Works with any sync mode (including Full Refresh – Overwrite, Incremental, etc.).[\[Refresh options\]](
https://docs.airbyte.com/platform/operator-guides/refreshes) - Can be triggered via the Airbyte API at
connection or
stream level.[\[Clear guide\]](
https://docs.airbyte.com/platform/operator-guides/clear) Effectively, this gives you “delete everything and load again”. ### 2. Use
Refresh Sync – Remove Records (for incremental streams) If your stream uses
Incremental | Append + Dedupe, you can trigger a
“Refresh and Remove Records” via API:\[\[Refresh options\]](
https://docs.airbyte.com/platform/operator-guides/refreshes) - Airbyte rewinds the cursor and reloads from the beginning. - Final tables will only show the data synced
since the refresh started, so previously-present data is effectively removed. Per the docs table, “Refresh stream and remove records” is
available for
Incremental | Append + Dedupe only; for
Full Refresh – Overwrite the only “delete” option is
Clear.[\[Refresh options\]](
https://docs.airbyte.com/platform/operator-guides/refreshes) --- The knowledge sources describe
what Clear and Refresh do and that both can be triggered via the API, but they do
not show specific API endpoint names or request bodies. I'm sorry, but there’s no information in the provided docs about the exact API calls or JSON payloads to use.