You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Using RPL to display a content loop

in Responsys 4 comments

Hi there!

Really struggling to pull data from a SQL view into a campaign using a RPL. 

I have a SQL view in the following format.

RIID_       NAME       CATEGORY     PRICE       GENDER PRODUCTID

29940      String2      Skirt                  £5              Womens  1 

29940      String6      Knitwear           £10            Mens        2

29940      String10    Dress                £6              Womens  3

I'd like to display the content in a campaign as below:

ProductId:1 

NAME: String2     

CATEGORY: Skirt

PRICE: £5

GENDER: Womens

ProductId: 2 

NAME: String6     

CATEGORY: Knitwear

PRICE: £10

GENDER: Mens

etc.

I've added the view and columns in data sources but not entirely sure what to add for the data, filter and list parameters. Please can someone advise?

Thanks!

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!