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
    Copy LinkReport

    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
      Copy LinkReport

      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
        Copy LinkReport

        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.