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
Martin Schagerl
shared this idea
Hello Reporter,
I am happy to announce that this functionality has been released and is live in the 20.2.1 version of Windward Designer! To learn how you can change your connection URL at runtime, please read our feature documentation here: https://ohana.windwardstudios.com/m/76878/l/1321991-how-do-i-edit-the-datasource-connection-on-output Thank you for your suggestion and please submit any other ideas you have to improve our products.
Adam Austin
Product Manager
-
Shameem
commented
For designers perspective, this is a critical option for us to have.
When is this feature going to be released?
-
Nath Papadacis
commented
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.
-
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