Guides
My Account

Available recon report dates (Legacy)

Overview

The Available recon report dates (Legacy) API provides date ranges available to download in the recon report.

Endpoint

GET <https://marketplace.walmartapis.com/v3/report/reconreport/availableReconFiles>

Functionality

This API helps you to:

  • Identify which reconciliation files are available
  • Determine valid retrieval report dates
  • Automate financial reconciliation workflows
  • Avoid requesting reports for unavailable dates

The response returns a list of report dates in the MMDDYYYY format.

Request sample

curl --request GET --url <https://marketplace.walmartapis.com/v3/report/reconreport/availableReconFiles> --header 'accept: application/json'

Modify your code

1. Add authentication headers

Include your required Walmart Marketplace authentication headers, such as:

  • OAuth access token
  • Consumer ID (if applicable)
  • Correlation ID (recommended for tracing)

2. Automate report discovery

For scheduled reconciliation:

  • Call this endpoint daily or weekly
  • Compare returned dates against previously downloaded reports
  • Trigger download of newly available dates

3. Validate date format

Dates are returned in the MMDDYYYY format (for example, 07012018).
Ensure your system correctly parses:

  • Month (MM)
  • Day (DD)
  • Year (YYYY)

Response sample

{ "availableApReportDates": [ "07012018", "07032018", "07102018", "07172018", "07242018", "07312018", "08072018", "08142018", "08212018", "08282018" ] }

Result

  • The API returns available reconciliation report dates.
  • Each string represents a report that can be retrieved using the Recon report (Legacy) API.
  • The dates correspond to settlement and accounting financial cycles.

Next Steps

Recon report (Legacy)

The Recon report (Legacy) API generates transaction-level details about your account, such as IDs, adjustments, refunds, commissions, shipping fees, and settlement totals. The recon report is generated in CSV file format for legacy systems that aren’t JSON compatible.

Recon Report JSON

The Recon report JSON Is a report of transactions, payouts, fees, refunds, and other financial activities in the JSON file format.

Recon report

The Recon report provides data about your settlements, order transactions, commissions, shipping fees, taxes, adjustments, and refund information. This API has the latest API standards with more advanced functionality and improvements.

Available recon report dates

The available recon report dates provides the date ranges available to download in the recon report.

Payment statement report

The Payment statement report Is a high-level overview of the payouts on your account after the settlement cycle has closed.

Performance report

The Performance report details the payment performance on your account, so you can see how payments are performing during the current cycle.

Updated 8 days ago