Self-Serve Backfill API for Amazon Selling Partner (SP) & Vendor Central (VC) Reports

We're excited to introduce the Self-Serve Backfill API, which allows you to independently retrigger Amazon SP and VC report tables for any custom date range (within the last 45 days) — without waiting for support.

Why This Matters

Amazon occasionally updates report data even after the attribution window. This API helps you recover such missing or updated data quickly and efficiently.

What is attribution? 
Attribution works by re-fetching past data over a defined period at set intervals. For example, you might choose to fetch the last 90 days of data every 30 days. The exact time span can be customized as needed

Key Benefits

Targeted Backfill

Retrieve only the data you need, for your specified start and end dates. (No more pulling from a single start date onward.)

Faster Resolution

Instantly trigger your own backfill jobs—no delays or tickets needed.

Flexible Date Selection

Backfill any date range from the last 45 days.

Secure Access

Authenticate using your registered email ID and company name. No API keys or tokens needed.

Built-in Validations

Prevents duplicate or invalid submissions and ensures accurate data recovery.

How to Use the Backfill API

Step 1: Set Up a New POST Request

Use Postman or any API tool.

Endpoint URL: https://webapi.sarasanalytics.com/services/schedule-report

Step 2: Authentication

Go to the Authorization tab → Choose Basic Auth

• Username: Your registered email ID (used when setting up the integration)
• Password: Your registered company name

Only use credentials from your integration setup. Contact support if unsure.

Step 3: Add Header

Key: Content-Type
Value: application/json

Step 4: Request Body (JSON Format)

{
"sourceId": [12345, 67890],
"tableNames": ["FBAInventoryReport", "FBAReturnsReport"],
"dateStartTime": "2025-04-25T00:00:01Z",
"dateEndTime": “2025-04-25T10:59:59Z”
}

Field Details:
• sourceId: List of integration IDs
• tableNames: List of report tables to backfill
• dateStartTime / dateEndTime: Date range for backfill (within past 45 days)

Frequently Asked Questions

1. What happens if I enter an invalid date range?

The API will return an error if the dates are invalid, in the future, reversed, or older than 45 days.

2. What time zone is used for reports?

The system uses the time zone of your Amazon marketplace (with the correct UTC offset).

3. What if my integration has a job already running?

The backfill will be blocked. Please retry once the ongoing job finishes.

4. Which reports are supported?

Most Amazon SP & VC category reports are supported.

Not supported:

• Snapshot reports
• Raw tables
• Search Query Performance (SQP) reports

5. Can I reprocess already completed data?

Yes, the API allows you to run backfill for the same date range multiple times.

6. Can I specify time ranges?

Currently, only full-day ranges are supported.
The API automatically adjusts:
• dateStartTime → 00:00:00
• dateEndTime → 23:59:59

7. How can I verify when a report was triggered?

You can verify this by checking the Daton UI. Go to the Jobs section under the specific table name and check the Report Status — it will show you the date and time the report was triggered and it’s Status.

8. Does triggering a backfill affect my Daton cost or Big Query usage?

• Daton Cost: No, Daton allows free backfill and reloads for up to a 2-day period. Most jobs typically complete data fetches within this window.

• BigQuery Usage: Yes, backfilled data is re-ingested into BigQuery, which can significantly increase the number of rows processed and, in turn, impact your BigQuery billing. To avoid unnecessary costs, we recommend using backfill only when needed and for specific date ranges.

Need Help?

Feel free to reach out to your support representative, or contact us via support

Reference Video

For better understanding of the process, please refer to the Loom video linked below:
loom video