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?  

Thanks,

 

MV

Hi,

you can do this using FlowVariables.

Here are some resources to get you started:

https://tech.knime.org/wiki/flow-variables

https://www.knime.org/nodeguide/control-structures/loops/using-tablerows-as-flowvariables-in-loop

https://www.knime.org/nodeguide/control-structures/loops/collecting-variables-in-loop

Best, Iris