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 da...
Data Integration
Krishna's avatar
Krishna
Valued Contributor
9 months ago

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
    9 months ago

    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
      9 months ago

      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.