We would like to add new table to the SFCC connector.

We currently have an internal process that allows for the deletion of records in SalesForce results in missing records in campaign_coupon and campaign_promotion. This is causing an issue for our analytics team which results in them not being able to link a coupon to a campaign or promotion.

One of our software engineers found a source that contains all pieces of information (order no, coupon, campaign and promotion ids) in the salesforce UI in a single json object that would resolve this issue for the team.