topic Read jSON with multiple data in Talend Studio

Read jSON with multiple data

Anonymous — Tue, 31 Jul 2018 10:08:58 GMT

Hi there,

I´m in trouble in reading data from a jSON-File with the following input:

{
"accountid": "AEX6376734",
"exhibitortype": "New Exhibitor",
"street": "Teststreet 1234",
"city": "Test City",
"email": "test@test.com"
"contact": {
"firstname": "Frank",
"lastname": "Master",
"contactphone": "+49 342823873",
"contactfax": null,
"contactmobile": null,
"contactemail": null,
"gender": null,
"salutation": null
}
}
{
"accountid": "AEX734875448",
"exhibitortype": "New Exhibitor",
"street": "Teststreet 5678",
"city": "Test City2",
"email": "test123231@test.com"
"contact": {
"firstname": "Robert",
"lastname": "Master",
"contactphone": "+49 12345",
"contactfax": null,
"contactmobile": null,
"contactemail": null,
"gender": null,
"salutation": null
}
}

I tried to create a meta-schema for this jSON but I only get the first data of this jSON. So it seems that it don´t iterate over the rest of the file.

So my result must return two sets of data.

AccountID: AEX6376734

AccountID: AEX734875448

My solution should be:

tFileInputJson -> tIterateToFlow -> tLogRow to test if it works.

Is anyone able to show me a solution how to read all the data iterated into tLogRow? How should I define loop element if I don´t have a group element.

Thx for your help.

Re: Read jSON with multiple data

iamabhishek — Wed, 01 Aug 2018 08:47:47 GMT

How about something like this - tFileInputJSON - main - tMap - main - tLogRow

Job Layout -

Also, your json seems to be wrong and doesn't get validated. It should be something like this -

		[{
			"accountid": "AEX6376734",
			"exhibitortype": "New Exhibitor",
			"street": "Teststreet 1234",
			"city": "Test City",
			"email": "test@test.com",
			"contact": {
				"firstname": "Frank",
				"lastname": "Master",
				"contactphone": "+49 342823873",
				"contactfax": null,
				"contactmobile": null,
				"contactemail": null,
				"gender": null,
				"salutation": null
			}
		}, {
			"accountid": "AEX734875448",
			"exhibitortype": "New Exhibitor",
			"street": "Teststreet 5678",
			"city": "Test City2",
			"email": "test123231@test.com",
			"contact": {
				"firstname": "Robert",
				"lastname": "Master",
				"contactphone": "+49 12345",
				"contactfax": null,
				"contactmobile": null,
				"contactemail": null,
				"gender": null,
				"salutation": null
			}
		}]

Re: Read jSON with multiple data

iamabhishek — Wed, 01 Aug 2018 09:21:03 GMT

How about something in the line of tFileInputJSON - > main - > tMAP -> main -> tLogRow