Hope you are well. I need help.
I have two workflows. Need to integrate one workflow into another.
There is a challenge.
The output of the first workflow should be passed into another workflow. But the first workflow output has timestamp.
Please let me know how to go about this,
Did you create arguments for your second workflow?
You can directly pass datatime as wel or string or any type.may i know what issue you are facing?
You could pass the DateTime var as an argument to the second workflow and then remove the timestamp if you don’t need it inside the second workflow.
Hi @Anil_G ,
Thanks for the reply and suggestion. To explain the situation.
I have two workflows
- Invoice workflow - it extracts all the necessary information from the pdf (invoices) and store in a excel file
- Sql workflow - This is the one you helped me with.
- Is to integrate sql workflow into the invoice workflow.
- Pass the invoice column from the first workflow into the Sql workflow query.
But the output from the invoice workflow in an excel file is name - timestamped. (not a static output) which i can point the sql to this location to pickup file.
When i will run the workflow the time would have lapsed and by the time it enters sql query it wont recognize. Not sure do we need to invoke a new workflow, create parameters?
Please let me know your thoughts,
Hi @sangeethaneelavannan1 ,
Thank you for the suggestion. Can you please share some sample workflow which i can have a look into it?