I need to query a MobileConnect List to delete some Contact records. Following this documentation on MC they status creating a MobileConnect List can then be queried into a Data Extension using the following format:

select SubscriberKey 
from [MyListName]

But I get an error creating the query stating MyListName doesn't exist.

Any ideas how I can do this and what I'm doing wrong?

  • Are the filtered mobileConnect list and the query present in the same business unit? – Praveen Kumar Bandi Aug 8 '18 at 9:30
  • Yes they’re in the same BU – Deployment Failure Aug 8 '18 at 10:37

The reason for this not working is because there is currently a bug which does not update the MobileList names in the Marketing Cloud backend DB if they are renamed at any point.

I had renamed my list at some point is the reason why I am unable to query the list, if I created a list without renaming it later the query works fine.

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.