<@U04S8PLJWMT> i want to refresh data with deletei...
# replication-ask-ai
m
@kapa.ai i want to refresh data with deleteing already present data via API
k
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.