04-09-2024 05:27 PM
Hi All - Attempting to add to the existing email_helper BR some logging information (Row counts) from the results of a Data Management Step that loops through a series of workflow profiles to load data to Onestream from an API.
I have located the information on the rowcount in the SQL table 'TaskFlowStepLog', but would prefer to use something that's available in the BRAPI if possible. Any ideas?
04-09-2024 07:37 PM - last edited on 04-10-2024 06:30 AM by JackLacava
Hi @tschilling - I tried something like this in the past
Dim dt As DataTable = JsonConvert.DeserializeObject(Of DataTable)(jArray.ToString)
Me.Logger(si,"Number of rows in DataTable=" & dt.Rows.Count,LogLevel.Debug)
04-10-2024 07:41 AM
@Krishna - I should have been more clear in the original post. I am able to retrieve the # of rows via that method currently, I was hoping to utilize on of the built in BRAPI functions that are already in place in the emailhelper function.
04-10-2024 11:55 AM
@tschilling Got it. If you are in Version 7 and it is a direct connect. You can use the Open Place Solution Data Import Schedule Manager. It will provide you which step it failed and # of rows. All you need to provide is email address. Hope this helps.