I need to query a MobileConnect List to delete some Contact records. I created a MobileConnect List and then used automation studio to query it into a DE. This worked fine BUT is SubscriberKey the only field I can query? My list has other fields (channel, source, Email Address, etc), but I can't seem to figure out how I can query them. And...once I can get that working, I also need someone to tell me how to query a list field I see as "Email Address"....how to account for the space?
(I am asking because I want to save a copy of the DE, in a non-sendable DE, before I run the delete - i'd like to have more info in that copy than just the subscriber key)
select SubscriberKey from [MyListName]
here are some examples of what I tried (none work):
select SubscriberKey, channel from [MyListName]
select SubscriberKey, x.channel from [MyListName] x