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

Through REST Post I am passing below using postman tool:

{
“FIRST_NAME”:“Virender”,
“LAST_NAME”:“Rana”
}

Postman setting:
Key Value

Accept application/json
Authorization Bearer xxxxxxxxxxxxxxxxxxxxxx
content-type application/json.

In mapper input variables I have given two parameters as below:
$FIRST_NAME
$LAST_NAME

Feel free to ask more information if any.

Thanks,

Surendar's avatar
Surendar
Contributor
8 years ago

You can pass the input from REST or post-man to pipeline as pipeline parameters from query string.

say for example,
The pipeline is calling from any url like,
www.yoururl/?firstName = Virender&lastName = Rana

Note this parameter from url and pipeline parameter should be same i.e.case sensitive.