I want to lookup a data extension in mobile connect optin message using Ampscript. We are sending that SMS using API call.
In my code I am looking up using mobile_number, I can see that the Mobile_Number carries a value but not able to look up a DE using that value.
Below is my sample code:
%%mobile_number%%
%%[
var @mobilenumber,@locale
SET @mobilenumber=mobile_number
SET @locale= Lookup("ENT._allContacts","SubscriberKey", "Mobile Number", @mobilenumber)
]%%
LOCALE: %%=v(@locale)=%%
Can anyone provide help on how to access Data Extensions from SMS(optin message type) using Mobile Number in where clause.
Thanks.