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

Community

Connector Improvement: SFCC Customer and Address missing an id to join the 2

Answered
Dan Doyle User

I presume the API to retrieve a customer address(es) uses the customerID/No. this data point should be in the Address table to get an exact join between Customer and Address instead of matching on common fields between the 2.

Please sign in to leave a comment.

Comments

2 comments

Date Votes
  • Sandeep Preetam Saila Fivetranner

    Hi Dan

    Thank you for the feature request. This is already in our backlog and we plan to pick it up soon. We will keep the thread posted on the developments!

    Best
    Sandeep

  • Charles Tran User

    +1, address is not usable to us without a tie to the parent customer_id.

    @Dan Doyle, which common fields are you using to join the tables? From just the native fields our team is unable to join them at all, as presumably the first_name last_name in address may not always be the same as the profile.