Hello everybody, I need your help please.
I am currently using the REFramework without Orchestrator queues. I need to pass a DataTable with two columns to the GetTransactionData workflow via the Config file.
Could anyone please advise on the best way to implement this?
What exactly you are trying to send from the config file?
Welcome to community!!
Take a look on below thread and practice with following practice as below tutorial. then you will get an idea, then you can relate this to your business logics,
Happy Automation!!
Hi @Ben.Zineb
Please refer below post on same. It talks about the changes that need to be made to enable datatable iteration instead of queues.
This also has a sample project included.
Hello,
It’s a table with two columns: one for the Jira name and the second for the link.
Hello,
Thank you for your response!
Follow the below steps to get the solution,
- In Reframework change the variable type from queueitem to datarow.
- in get transaction state remove queue get transaction item activity and read your config file using read range activity and mention the sheet that where you stored the input.
- Now you got the data table as input after reading the input you can build the logic to read the data one by one.
If you got stuck at any point go throw below course then you will get an idea how to do this.
Happy Automation
Hi @Ben.Zineb
In the Config file, add a new row where the Key is ColumnNames and in the Value field specify the two required column names separated by a semicolon (or comma).
During the Initialization state, read the input file and store it in a DataTable variable.
Create two string variables named Column1 and Column2, and assign their values as follows:
Column1 = out_Config("ColumnNames").ToString.Split(";"c).First
Column2 = out_Config("ColumnNames").ToString.Split(";"c).Last
Use these two variables in the Filter Data Table activity to retain only these columns and remove the others.
Finally, pass this filtered DataTable to the GetTransactionData workflow through arguments.
Check the below screenshot to how to give values in config file,
Hope it helps!!
Thank you so much for your response!
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.