as your output seems to be of a collection type (which resembles a Javascript object), you can also navigate directly into your output structure when specifying the output parameters in your SQL connector call. However, this will only work, if the field you want to access within your output has a static position, e.g. it is always part of the first object included in the array under the same key, no matter the input of your SQL query. Then you could specify your output parameter like the following:
/[indexInArray]/keyInObject
What you see above is basically the path to the field within your structure, starting from the very top (which is the “/” or root, respectively). Please remember to adapt the data type of your output parameter accordingly as you won’t get a collection returned anymore but the simple datatype of the field itself, like string or integer.
If the position of the value within your output structure should not be static, I would suggest to access it dynamically from within a business object that executes the connector call. Here is how to achieve this. Using the business object is of course not really different from your script-based solution, so please keep that in mind.
