In order to personalize our SMS - Journey Builder sent, we need to use the values of the fields of the Data Extension that trigger de Journey Builder.
So that, we are using an AMPScript code in the SMS in Mobile Connect outbound SMS. We have tried with this:
%%[ SET @idSubscriber = _subscriberkey SET @rows = LookupOrderedRows("DE", 1, "ID_SUBSCRIBER Desc", "ID_SUBSCRIBER", @idSubscriber) SET @RowCount = RowCount(@rows) IF (Rowcount(@rows) > 0) THEN VAR @ILRow, @name, @limit SET @ILRow = row(@rows,1) SET @name = Field(@ILRow, "DES_NOMPILA") SET @limit = Field(@ILRow, "LIM_MC") ENDIF ]%% 1= %%=v(@idSubscriber)=%% 2= %%=v(@RowCount)=%%
We have recieved the SMS but the value of @idSubscriber is null. We have tried then with changing the Personalization string (found in Exacttarget documentation WEB):
%%[ SET @idSubscriber = CONTACT_KEY SET @rows = LookupOrderedRows("DE", 1, "ID_SUBSCRIBER Desc", "ID_SUBSCRIBER", @idSubscriber) SET @RowCount = RowCount(@rows) IF (Rowcount(@rows) > 0) THEN VAR @ILRow, @name, @limit SET @ILRow = row(@rows,1) SET @name = Field(@ILRow, "DES_NOMPILA") SET @limit = Field(@ILRow, "LIM_MC") ENDIF ]%% 1= %%=v(@idSubscriber)=%% 2= %%=v(@RowCount)=%%
but in this case we have not recieved the SMS.
Could you help us on how to access to the values of the Data Extension within Mobile Connect SMS, triggered by Journey Builder?
Than you very much

In order to personalize our SMS - Journey Builder send, we need to use the values of the fields of the Data Extension that trigger de Journey Builder.

So that, we are using an AMPScript code in the SMS in MobileConnect outbound SMS. We have tried this:

%%[ 
    SET @idSubscriber = _subscriberkey 
    SET @rows = LookupOrderedRows("DE", 1, "ID_SUBSCRIBER Desc", "ID_SUBSCRIBER", @idSubscriber) 
    SET @RowCount = RowCount(@rows) 
    IF (Rowcount(@rows) > 0) THEN 
        VAR @ILRow, @name, @limit 
        SET @ILRow = row(@rows,1) 
        SET @name = Field(@ILRow, "DES_NOMPILA") 
        SET @limit = Field(@ILRow, "LIM_MC") 
    ENDIF 
]%%
1= %%=v(@idSubscriber)=%% 2= %%=v(@RowCount)=%%

We have recieved the SMS but the value of @idSubscriber is null. We have tried then with changing the Personalization string (found in ExactTarget documentation):

%%[ 
    SET @idSubscriber = CONTACT_KEY 
    SET @rows = LookupOrderedRows("DE", 1, "ID_SUBSCRIBER Desc", "ID_SUBSCRIBER", @idSubscriber) 
    SET @RowCount = RowCount(@rows) 
    IF (Rowcount(@rows) > 0) THEN 
        VAR @ILRow, @name, @limit 
        SET @ILRow = row(@rows,1) 
        SET @name = Field(@ILRow, "DES_NOMPILA") 
        SET @limit = Field(@ILRow, "LIM_MC") 
    ENDIF 
]%% 
1= %%=v(@idSubscriber)=%% 2= %%=v(@RowCount)=%% 

In this case we have not received the SMS.

Could you help us on how to access to the values of the Data Extension within Mobile Connect SMS, triggered by Journey Builder?

Than you very much.