Inventory Adjustment Log Table

Dataset ID: 4abae034-8240-4595-85c7-17a8f5398d42

Unique Composite Key(s): id, storeid

Datetime Dataset Last Updated: last_retrieved_timestamp

Incremental Load Logic: Use the column adjustment_datetime as data appends per new inventory adjustment action

Pull Previous Day - Data-Raw Append Example:

{"sql": "SELECT * FROM table WHERE date(adjustment_datetime) = date(date_add(now(), INTERVAL -1 day)) "}

Pull Previous Successful Update: Data-Raw Append Example:

{"sql": "SELECT * FROM table WHERE date(adjustment_datetime) >= $stored_last_update_datetime"}

• stored_last_update_datetime is your stored datetime for last successful data pull

TIP: As a best practice, we recommend that you save the timestamp for each of your dataset pulls as 'stored_last_update_datetime'. Note that this value is not saved in our datasets, but is a suggestion.