Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Amazon Selling Partner: Add posted_date column in FINANCIAL_SERVICE_FEE_EVENT Table

Answered
Akhila Mukka User

Need the field posted_date on the FINANCIAL_SERVICE_FEE_EVENT or a similar field/table that will contain that.

These are the columns we have on fivetran versus the ones actually have on amazon api:

Standard Fivetran Columns:

_fivetran_id - Primary key (auto-generated hash by Fivetran)
_fivetran_deleted - Boolean flag for soft deletes
_fivetran_synced - Timestamp of when the record was synced

Amazon Service Fee Event Columns:

amazon_order_id - The Amazon order ID (sometimes malformed according to API issues)
fee_type - Type of fee (e.g., FBADisposalFee, FBAInboundTransportationFee, Subscription)
fee_amount - The fee amount
currency_code - Currency code (e.g., USD, EUR)
asin - Product ASIN (though this is often missing from the API)
sku - Product SKU (often missing from the API)
posted_date - Date when the fee was posted (known to be missing in many cases)

 

 

Please sign in to leave a comment.

Comments

2 comments

Date Votes
  • Official comment
    Sandeep Preetam Saila Fivetranner

    Hi Akhila,

    Your request to add the posted_date column to the FINANCIAL_SERVICE_FEE_EVENT table for the Amazon Selling Partner connector has been added to our feature improvements backlog. We will keep the community updated on this thread as we make progress.

    Thanks,
    Sandeep

  • Sandeep Preetam Saila Fivetranner

    Hi Akhila,

    Thank you for your feature request regarding the Amazon Selling Partner connector. Unfortunately, the Amazon SP-API Finances v0 does not include a PostedDate field in the ServiceFeeEvent schema, so we are unable to support this request at this time. 

    Best,  
    Sandeep