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
Skip to content
  • 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!