How get data from SQL complex query and use it in endpoint?
I created an Integration event solution, then create a request/reply map, I want to get the result of a complex query and use it from an endpoint.
When I tried to set it in a stored procedure I can't get its data as a table result, Also I Can't use a sql function in request/reply map.
You can't directly process a result set returned by a stored procedure in the body of the map
You would need to have the sproc write the results to a table and then use a Fetch block to read from the table an process the data accordingly