topic Re: tFileInputJSON "Can't find any data with JSONPath" in Talend Studio

tFileInputJSON "Can't find any data with JSONPath"

ecurren-lmi — Mon, 29 Jun 2020 16:04:56 GMT

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.

Re: tFileInputJSON "Can't find any data with JSONPath"

vapukov — Tue, 30 Jun 2020 01:14:57 GMT

Hi,

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

cheers

Re: tFileInputJSON "Can't find any data with JSONPath"

vapukov — Tue, 30 Jun 2020 01:14:57 GMT

Hi,

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

cheers

Re: tFileInputJSON "Can't find any data with JSONPath"

ecurren-lmi — Tue, 30 Jun 2020 15:48:28 GMT

Thanks very much vapukov. I appreciate your help.

Re: tFileInputJSON "Can't find any data with JSONPath"

ecurren-lmi — Tue, 30 Jun 2020 15:48:28 GMT

Thanks very much vapukov. I appreciate your help.