[SalesForce] Update MobileConnect Demographics from a Data Extension

I seem unable to update an existing row in MobileConnect All Contacts list.

I also seem to not be the only one with the confusion:

Is there a way to update MobileConnect Subscription Data from a Data Extension?
How do I update mobile connect demographics when data for a contact changes?

My account seems to be set up correctly based on this known issue.

I have a single row in a source Data Extension:

Source DE

And an Import Definition like so:

Import Definition
Import Definition Mapping

Which points to the source DE. The Contact Key field on the row in the source DE matches a Contact Key in the All Contacts list. I would expect it to then update the mobile contact with the new values but it does not. I.e., I would expect the highlighted fields (see below image) to now include the boolean values as seen in the source DE:

MobileConnect Contact

Contact builder looks like so:

Contact Builder

Question is what am I missing here? Is Contact Key not the correct upsert key? I also see a field called Contact ID – is this instead it?

Edit: I am getting the following notification email with validation errors from SFMC:

"The following import has completed with validation errors" and the csv says required field _mobileNumber although the Mobile Number in my import is not empty:

Row Number Error Number Error Code Error Details Row Data
0 133273946 RequiredField _MobileNumber [34805][1234567890][1234567890][DK][Test][Test][False][True]

Best Answer

Please check you mapping in the import definition. On some occasions, the "Map by Header Row" is failing. Even though the mapping looks correctly in the UI, it fails to map the fields properly. Switching it to "Map Manually", even though it is the exact same mapping, sometimes solves the issue.

Related Topic