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

[virender]

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 and even from snaps.

Flow of pipeline 🙂

mapper → oracle stored procedure snap → email sender.

In mapper I am passing hardcoded values which are passing in Oracle proc and working fine.

Issue -
1- Not sure how to pass json inputs from outside (postman or URL) in pipeline to mapper snap.
2- What should be the input expression in mapper input to get the input variables from json from outside.

Thanks,
Virender.
+91 9873060030

[virender]

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 · Accepted solution]

Have you defined Pipeline Parameters?

tstack:

"Your Employee is " + _LAST_NAME + ", " + _FIRST_NAME

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