How to get max value from one table and use it to insert into another table?

I have 2 tables, I want to get the max value from the table 1 field and then use that value as part of the insert to table 2.

How do I set this up in the API Steps?

Add a database query step and use the aggregate functions to find the max value of a column. Add an alias for it:

Then add the insert step and select the alias from the query step:

Thanks @Teodor, realised where I was going wrong from your screen shots as I was using a single result query to get the max.

1 Like