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

dmiller's avatar
dmiller
Former Employee
8 years ago

We might need a bit more information on what you want to pass in and from where.
For example, to get information from a URL may require a REST Get before the Mapper.

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,