I am using a smart object to retrieve data from multiple SQL data sources using the Dynamic Sql service object. When I pass a parameter to my GetAgent method, I can set that as the input parameter on the first service object method, but it also sets the mapping of the return parameter to the smart object parameter. If I try to map the return property to "AgentID" smart object property, the wizard automatically changes the input parameter to be the smart object property as well. I found the same question in this post but it didn't really have an answer.
The problem I have is that the first service object may, or may not have a record with this AgentID. If the wizard is mapping the return value of the first service object to the parameter (AgentIDParam), then it is null when I call the second service object, which does contain a record with the AgentID. Since the parameter has changed, there is no data retrieved from the second service object, either.
It seems to me that I should be able to map the input parameter of the service object to the input parameter but still map the return value to the smart object property.
Is this a bug? Is there another approach to retrieving data through service objects in this scenario?
Thanks in advance,
Scott