Forum Discussion

virender's avatar
virender
New Contributor
8 years ago
Solved

How to pass json parameters in mapper form postman or snaplogic URL's for Oracle stored procedure

Hello Team, Description of pipeline: I have created a sample pipeline to execute “Oracle stored procedure” which ha 2 input variables and 1 output variable. Procedure is working fine manually a...
  • SandeepVemula's avatar
    SandeepVemula
    8 years ago

    Have you defined Pipeline Parameters?

    If so This is the Correct approach.
    If you havent defined parameters. Go to Edit Pipeline and define them with the names you are using.
    LAST_NAME and FIRST_NAME

virender's avatar
virender
New Contributor
8 years ago

Actually cant close the output view of oracle stored procedure as its is default from Oracle snap. let me try union one.

virender's avatar
virender
New Contributor
8 years ago

error is gone after combining two snaps output by Union snap.

But it is still not taking input variables from outside and showing below message:

[
{
“to”: “virender_singh_rana@abc.com”,
“cc”: null,
“bcc”: null,
“from”: null,
“subject”: null,
“emailType”: “text/html”,
“body”: “Your Employee is $LAST_NAME, $FIRST_NAME”
}
]

I have given $FIRST_NAME and $LAST_NAME for input variables in mapper snap and it is passing those name as it is to further snaps.

Thanks.

  • tstack's avatar
    tstack
    Former Employee
    8 years ago

    It looks like you haven’t made the property an expression. Note that variables are not automatically substituted in strings. You can make the property an expression by pressing the ‘=’ toggle on the left of the property and then changing the value to something like this:

    "Your Employee is " + $LAST_NAME + ", " + $FIRST_NAME

    Are you passing these values into the triggered task using a POST operation or are you using a query string like was mentioned in another post? If you’re using a query string, the values will be passed in through Pipeline Parameters and you’ll need to reference them with an underscore instead of a dollar sign:

    "Your Employee is " + _LAST_NAME + ", " + _FIRST_NAME
    • virender's avatar
      virender
      New Contributor
      8 years ago

      Thanks for replying…

      I am passing the parameters from a triggered task using post method through postman tool. I have a output parameter FULL_NAME in my oracle proc which is returning correct value.
      But not sure how to take input using expression (in input fields) in mapper snap.

      Thanks.

      • SandeepVemula's avatar
        SandeepVemula
        Contributor
        8 years ago

        Have you defined Pipeline Parameters?

        If so This is the Correct approach.
        If you havent defined parameters. Go to Edit Pipeline and define them with the names you are using.
        LAST_NAME and FIRST_NAME