search

intakedesk / PowerBI-General

Placeholder for issues migrated from Jira
1 stars 0 forks source link

LeadConduit: Add SuppressionList Is Unique Reason to Leads table of integration (need for duplicate phone number recently received) #591

Closed jesusitd closed 4 years ago

jesusitd commented 4 years ago

Added fields to Leads schema of LeadConduit_REST:

    <attr  name="vars.suppressionlist.is_unique.reason"          xs:type="unknown"  readonly="false"              other:xPath="/json/vars/suppressionlist/is_unique/reason"          />
    <attr  name="vars.suppressionlist.is_unique.outcome"         xs:type="unknown"  readonly="false"              other:xPath="/json/vars/suppressionlist/is_unique/outcome"         />

Added to REPLICATE statement:

    [vars.suppressionlist.is_unique.outcome] AS [suppressionlist_is_unique_outcome],
...
    [vars.suppressionlist.is_unique.reason] AS [suppressionlist_is_unique_reason],
jesusitd commented 4 years ago

Also incorporated for "Duplicate" reason in LeadConduit Sync Monitor report.