I'm working on the following scenario in Data Services (v4.2).
Web Service (Request) -> DS (expose RT job as service) -> SQL Query -> Response to Web Service
Web service is sending single field - like Vendor #. Now, the issue is that I need to capture this field and pass this to the SQL Transformation.
The hard-requirement is that I need to use specific SQL Query to get the values (it is nested actually). So, I need to find a way to capture the input field from Web Service and pass this to the SQL Transform query.
I believe there are two ways of doing it:
1. Using the script to declare a Global Variable
2. Using custom function to capture input field and assign it to GV
Unfortunately, I've not been able to get this to work. Need help to fix this issue.