Forum Discussion

jhagist's avatar
jhagist
New Contributor III
8 years ago

Eloqua Snap: Adding A Variable

I am using the Eloqua snap to extract multiple of the Core Object Types.
I would like to create a variable so I could reuse the pipeline but I can give it is a drop down.

Any idea how to run it with a variable?

Open to other work arounds too…

  • skatpally's avatar
    skatpally
    Former Employee

    you can access it directly.

    INSERT INTO _paramTableName VALUES ($id)

    • sghadse's avatar
      sghadse
      New Contributor

      Thanks for your response. I have a parent pipeline with pipeline execute that has parameters defined as shown below. These captures table name and row count:

      In Child pipeline, do I have to redefine pipeline parameters again. If yes, what should be the value of pipeline parameters here.

  • skatpally's avatar
    skatpally
    Former Employee

    In the child Pipeline you don’t have to specify any values(the Values can be blank). When you run the pipeline the values are sent from the Parent Pipeline to Child pipeline. when using the Pipeline Execute Snap, the data can be passed through the input view of the child Pipeline When you are designing the pipeline you can specify valid values to work with.
    https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1438254/Pipeline+Properties#PipelineProperties-Settings