What was the process to print all the field values from extracted json?

@alexcabuz This feature is so amazing!!! Already Started working today in this .
Will you guys help me on how can i get an individual values like all the fields from the dataset output (Say output Dataset : ds)
I am trying with for each activity and trying to print , but it was not expected filed results some random text i got …

Help me guys, what was the process to print all the field values from extracted json.

Regards,
Sriram

Hello @Sriram07 - please try to use the Export Extraction Results activity - this will generate a DataSet with all the values.

You can then do a ForEach table in dataSet.Tables (as DataTable)
do

  • excel application scope with an excel file name, then
  • write range (tab name: table.Name) values in table.

You should be able to see all the content of the exported data in the excel sheet afterwards.

Any chance you can elaborate on this a little more. I’m not seeing a lot of information about getting the dataSet parsed and into excel in the documentation and I have been unable to figure it out.

I took the demo invoice reader file, added an “export extraction results” activity to convert the extractionResults to a DataSet. After that, I am not certain how to get the fields extracted into excel or any format other than the .json that the demo has set up.

Any help is appreciated. Thanks!

Invoices_example.xaml (22.5 KB)

Hello @wbader,

This is how my workflow looks like:

So what happens here is:

  1. I use Export Extraction Results and set the output to a variable called “validatedDS” (DataSet)
  2. I do a For Each dt in validatedDS.Tables, and I set the type argument to System.Data.DataTable
  3. inside the For Each loop, I do a Write Range to a file of my choice (I am using the name of the document being processed, in my case stored in the “item” string variable), and i write a tab with the name dt.TableName, and in that tab I write the entire dt DataTable.
    To make sure you can view the field names as well, please check the AddHeaders option of the Write Range activity.

NB: I am using the Excel package 2.6.2.

Hope this helps,

Ioana

I am not clear in “dt.TableName” ?
TableName?

And also When i am executing as same as your workflow after export extraction results , But i am not getting expected results its only giving the last 6 fields only i don’t know why .
Will you tell me ? why?

@Sriram07
if confidentiality is not an issue, please send me the full workflow with one file that the issue reproduces on - I would like to have a look and see what is not working.
THanks!

This is fantastic. Thank you so much. I would not have figured this out on my own.

@Ioana_Gligan will you help me on this ?
What is that tablename ? is this a member of datatable ? or what ?

Yes, table name is a member of the DataTable.