I have a sync data extension and I want to update records in All Subscribers. I've completed these steps using automation:

  1. Data Extract Activity;
  2. A File Transfer Activity to put the file in FTP;
  3. An Import Activity to import the subscribers list in All Subscribers.

My DE has these fields: Subscriber Key, Email Address, Status and the other fields are renamed exactly like the fields in All Subscribers. But I see this error Import Activity: InvalidRestrictedFieldValue

Any solution on this?

  • 1
    It's likely an invalid value for Status. – Adam Spriggs Oct 17 '18 at 1:39
  • 1
    Status should be either "Active" or "Unsubscribed". Any other values like Held, Bounced will not be accepted. – Praveen Kumar Bandi Oct 17 '18 at 3:54
  • Hello, my DE has the field status filled "Active" like you said, but the error persists; – Joao Marano Oct 17 '18 at 13:48

You lost your fields as Email Address, Subscriber Key, Status - but you also mention

'other fields are renamed exactly like the fields in All Subscribers.'

The error you get relates to the Field type / values you are attempting to import.

If you have eliminated 'status' but ensuring values are simply 'Active' or 'Unsubscribed' (and watch out for spaces etc) then I would question what other fields that you have mapped.

Are there Decimal, or Boolean fields that you are attempting to import to?

You could try to simplify and import only the required fields and then add additional fields to undercover which field is causing the issue.

Provide an anonymised sample of your file so we can check for anything obvious - double-quote values, misspelt values etc

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.