[SalesForce] AMPSCRIPT “not empty” not working

I am using this code

 var @rs, @row, @Id, @Fname, @Lname
      SET @rs= RetrieveSalesforceObjects('Lead', 'Id, FirstName,LastName', 'email', '=', @email)
      IF NOT Empty(@rs) THEN
        SET @row = ROW(@rs,1)
        SET @Id = FIELD(@row,"Id")
        SET @Fname = FIELD(@row,"FirstName")
        SET @Lname = FIELD(@row,"LastName")

      ENDIF




    ENDIF

    ]%%
    <div class="container">
      <p>
        %%[ if RequestParameter("email") != "" then ]%%
          <p>
            %%=v(@Id)=%%
            Thank you, your preferences have been saved. (actually need to only show this on success, need error handling)
          </p>

I know if have two ENDIFs there but there is another IF above that I'm not showing here. My Retrieve SalesforceObjects is working fine without the IF NOT EMPTY, but with it, my other variables never get set. Why is this? I don't think it's case sensitive, but I've tried it with a number of different cases and it never works. It only works if I remove the if statement entirely. Are we not allowed to nest IF statements in Ampscript?

Best Answer

I believe that function returns a row set, so you'd need to check the rowcount() instead of using empty().

%%[

var @rs, @rc, @row, @Id, @Fname, @Lname
set @rs = RetrieveSalesforceObjects('Lead', 'Id, FirstName,LastName', 'email', '=', @email)
set @rc = rowcount(@rs)

IF @rc > 0 THEN
  SET @row = ROW(@rs,1)
  SET @Id = FIELD(@row,"Id")
  SET @Fname = FIELD(@row,"FirstName")
  SET @Lname = FIELD(@row,"LastName")
ENDIF

]%%

Related Solutions

[SalesForce] I can’t even set variables in ExactTarget AmpScript

I think what you are running into, is that your account is not yet fully built out.

The reasone why MemberID, FirstName, LastName all work, is that the account already has those set up as profile attributes, and are listed as personalization strings

A profile attribute contains information to characterize a subscriber profile. For example, each subscriber may be asked to provide their gender, birth date, and email address. By default, every account has three profile attributes: Full Name, Email, and User Defined (which is intended as a generic attribute that you can use as needed). You cannot modify these attributes.

A preference attribute characterizes how a subscriber prefers to receive email. These are specified as "yes or no" choices to a declarative statement. For example: "The subscriber prefers to receive email as HTML."

First you must create the profile or preference attribute in your account so there is a place for the system to store the data. You also specify whether an attribute is required information for every subscriber and whether subscribers can see and edit their own attributes in the Profile Center (a link to the Profile Center is included in every email). You can also specifiy profile attributes when you import a subscriber list. See Subscribers for more information.

Click the Subscribers tab.
Click Profile Management or Preference Management.
Click Create Attribute, which opens the Attribute Properties dialog box.
Define the properties for this attribute.
Click OK in the Attribute Properties dialog box when done.

Note: If you marked the new attribute as a required field, all subscriber imports now must include this field. You may want to include a default value so that records can be saved even if a value isn't provided.

You will then be able to access those properties in your AMPscript.

Ampscript if else statement issue

So I think the issue you are running into is that you have null values in your TestCity field in the TEST DE data extension. This means that when you do the lookupRows to a null value (e.g. MailingCity is empty/null) then it returns those rows that have null from your DE.

This is likely why you are getting a false positive result and it is returning a rowcount. Something like the below should remove this issue.

%%[

set @city = AttributeValue("MailingCity")

IF NOT EMPTY(@city) THEN
  set @rows = LookupRows("TEST DE","TestCity", @city)
  set @rowCount = rowcount(@rows)
ELSE
  set @rowCount = 0
ENDIF

]%%

%%[ if @rowCount > 0 then

for @i = 1 to @rowCount do

    set @row = row(@rows, @i) /* get row based on counter */
    set @Name = field(@row,"FirstName")
    set @TestCity = field(@row,"TestCity")

    ]%%

    %%=v(@i)=%%

    %%=v(@Name)=%%
    %%=v(@TestCity)=%%

%%[ next @i ]%%

%%[ else ]%%

No rows found

%%[ endif ]%%

Best Answer

Related Solutions

[SalesForce] I can’t even set variables in ExactTarget AmpScript

Ampscript if else statement issue

Related Topic