Skip to Content
Former Member
Oct 28, 2016 at 12:51 PM

Capturing field value from Web Service and passing to SQL Transformation


Hi All,

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.