Using a SQL lookup to feed a HTTP source

Integrator.io
1

I have a flow with a HTTP source. As part of the filter parameters for my query, I need to do a SQL query (lookup) to get the max ID of the last record retrieved. If my flow source is HTTP, I don’t know how I can use the SQL statement below to get the max ID. If my flow source is a SQL step, then I can get the max ID, but then I always get only 1 record in my results. If my next step is the HTTP lookup, when I map the lookup results back into my overall results, all of the returned rows are under 1 record. How can I get my HTTP rows to be the records, but execute the SQL query first?

Here’s the simple SQL I am trying to execute:

select max(id) from OrderHeader

2

@tylerlamparter provided the answer. Since my expected result set is small, and will fit within 1 page, I can just use “One to Many” = Yes on my next step.