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.

 

1 Comment

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

marty.smith1.45... - Sep 05, 2019 - 4:51am
+ Add a Comment
Login