rpt_get_fba_reimbursements_data

Seller reports (SP-API) · GET_FBA_REIMBURSEMENTS_DATA · Daily at 01:04 marketplace local time

How fresh is it?

Daily

Daily at 01:04 marketplace local time

Need it right now?

—

No live tool answers this — query the synced rows.

FamilySeller reports (SP-API)
Report typeGET_FBA_REIMBURSEMENTS_DATA
Grainregion
Syncincremental
Business dateapproval_date

Columns (22)

ColumnTypeKey
idINTEGER
store_idVARCHAR(36)🔑 key
report_dateDATE
approval_dateTIMESTAMP WITH TIME ZONE
reimbursement_idVARCHAR(100)🔑 key
case_idVARCHAR(100)🔑 key
amazon_order_idVARCHAR(50)
reasonVARCHAR(200)
skuVARCHAR(200)
fnskuVARCHAR(200)
asinVARCHAR(20)
product_nameTEXT
conditionVARCHAR(50)
currency_unitVARCHAR(10)
amount_per_unitNUMERIC(12, 2)
amount_totalNUMERIC(12, 2)
quantity_reimbursed_cashINTEGER
quantity_reimbursed_inventoryINTEGER
quantity_reimbursed_totalINTEGER
original_reimbursement_idVARCHAR(100)
original_reimbursement_typeVARCHAR(100)
extraJSON

Query it

In an AI client (MCP)

tools/call
{
  "name": "query_report_data",
  "arguments": {
    "store": "myStore-US",
    "tables": [
      "rpt_get_fba_reimbursements_data"
    ],
    "columns": [
      "rpt_get_fba_reimbursements_data.reimbursement_id",
      "rpt_get_fba_reimbursements_data.case_id"
    ],
    "order_by": [
      {
        "column": "rpt_get_fba_reimbursements_data.approval_date",
        "dir": "desc"
      }
    ],
    "limit": 100
  }
}

From code (Tool API)

curl -X POST https://api.sellersheetai.com/api/v1/tools/query_report_data \
  -H "Authorization: Bearer $SELLERSHEET_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"store":"myStore-US","tables":["rpt_get_fba_reimbursements_data"],"columns":["rpt_get_fba_reimbursements_data.reimbursement_id","rpt_get_fba_reimbursements_data.case_id"],"order_by":[{"column":"rpt_get_fba_reimbursements_data.approval_date","dir":"desc"}],"limit":100}'
Early access — the Tool API is open on request, contact us.

On this page

Actions

View as Markdown

Ask an assistant

Ask ChatGPTAsk Claude