tFileInputJSON "Can't find any data with JSONPath"

[ecurren-lmi]

I've searched other issues similar to this one, but I have not found a solution that solves the issue I am facing at the moment.

My job writes out data in JSON format to a file via a tFileOutputJSON component.  It then open the file using a tFileInputJSON to read the data out of the file.  Both components use the same schema.

The job looks like this:

The output of the tFileOutputJSON_1 looks like this:

{
	"data": [
		{
			"RowId": "0",
			"WorksheetIndex": 16,
			"Value": "504353",
			"SheetColumn": "A",
			"SubjectId": 0,
			"WorksheetName": "LookUps"
		},
		{
			"RowId": "0",
			"WorksheetIndex": 16,
			"Value": "Tolle, Sebastian",
			"SheetColumn": "B",
			"SubjectId": 0,
			"WorksheetName": "LookUps"
		},
		{
			"RowId": "0",
			"WorksheetIndex": 16,
			"Value": null,
			"SheetColumn": "CI",
			"SubjectId": 0,
			"WorksheetName": "LookUps"
		},
		{
			"RowId": "0",
			"WorksheetIndex": 16,
			"Value": null,
			"SheetColumn": "CJ",
			"SubjectId": 0,
			"WorksheetName": "LookUps"
		}
	]
}

The mapping for tFileInputJSON_1 looks like this:

And the resulting output from running the job ends with this error:

I appreciate any and all help I can get on this.

[vapukov]

Hi,

you need to use JSONPath with loop
https://goessner.net/articles/JsonPath/ 

cheers

[vapukov · Accepted solution]

Hi,

you need to use JSONPath with loop
https://goessner.net/articles/JsonPath/ 

cheers

[ecurren-lmi]

Thanks very much vapukov.  I appreciate your help.

[ecurren-lmi]

Thanks very much vapukov.  I appreciate your help.