Sync Sql Server

Guidance
1

What s the best way to sync production data with a Sql server?

do we run the put and delete for all of those or is there a better way

2

Best way to sync production data with SQL Server + ComboCurve API.
Use batch PUT/PATCH for updates/inserts, and DELETE by well + date range for removals—avoid row-by-row calls.

Recommended flow:

  1. Detect changes in SQL Server
    Use last-updated timestamps or change tracking to ID new, modified, or deleted records.

  2. Push new/updated records

    • Use PUT for inserts

    • Use PATCH for updates

    • Both accept arrays, so send in batches.

  3. Handle deletes

    • Use DELETE by well ID + date range

    • Group deletions to minimize calls

1 Like
3

Is there a way I can check the updated date or inserted date of Production data (either Daily or Weekly)? My thinking here is if I am able to pull the well ids whose production have not been updated in the first run where i run the put (upsert) then delete it.

4

Armaan,
If you read the API documentation (https://api.combocurve.com/v1/daily-productions), you will see filters for createdAt and updatedAt. You can use these filters to pull and compare the production data you are referring to.