How can we improve the newest version of Windward Studios Products?

Variables in the Datasource URL of a Webservice

At the moment I could not add dynamic parameters to the URL of a Webservice. For example I have the following datasource url:

http://jsondatasource/api/Json/GetEmployeeByName?firstname=Martin

but instead of the static value 'Martin' I need a dynamic variable value like

http://jsondatasource/api/Json/GetEmployeeByName?firstname=${firstnameParam}

Thx,

Regards

21 votes
Vote
Sign in
(thinking…)
Password icon
Signed in as (Sign out)
You have left! (?) (thinking…)
Martin Schagerl shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

2 comments

Sign in
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...
  • Nath Papadacis commented  ·   ·  Flag as inappropriate

    In my particular instance I have an XML datasource accessed by a REST call. I'd like to be able to change the request parameters so that I can pull back data specifically for a report.
    For example. http://myurl.com/getData.xml?orderId={orderID}

    The documentation seems to suggest a similar facility is available by using a "select" input variable in order to filter the resultset, but this will only work efficiently against an SQL datasource. For XML/JSON the entire datasource is read first and then filtered afterwards. This will not work for me as the full datasource will be too large to retrieve in one go.

    I know I could use the engine to alter the datasource at runtime but during development of the template using AutoTag it would be nice to hit different endpoints using an input variable rather than having to edit the datasource each time.

  • AdminWindward Admin (Windward Staff, Windward) commented  ·   ·  Flag as inappropriate

    Hi Martin,

    Can you clarify where you would want to pass the parameter? We have discussed this internally and find 2 scenarios where this could be possible.

    1) The initial data source connection, you wish to filter the JSON URL based on the dynamic parameter passed in.

    2) Inside of a Windward tag IE, forEach, to return a result set based on the variable parameter passed in. IE, you wish to return a list of employees to iterate over based on the parameter you pass in.

    If you can give a little more detail or an example of how you want to use this JSON service URL with Windward, it would help greatly.

    The Windward Staff

Feedback and Knowledge Base