Forum Discussion

tschilling's avatar
tschilling
New Contributor III
9 months ago

Adding RowCount to Email Notification from an import stage load

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?    

 

  • Krishna's avatar
    Krishna
    Valued Contributor

    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)		

     

    • tschilling's avatar
      tschilling
      New Contributor III

      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.  

      • Krishna's avatar
        Krishna
        Valued Contributor

        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.