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.