Changing the date filed dynamically for an API call

Hello Knime users,

I am looking for a solution in KNIME that changes the to and from dates in my API call dynamically based on the max(date) in my database.  This way I can schedule the workflow and have the data flow into the db everyday.  

Right now I am using the GET Request Node for the api call.

What nodes/workflow would i need to use to acheive this?  





you can do this using FlowVariables.

Here are some resources to get you started:

Best, Iris