tExtractJsonFields : java.io.IOException: Already in an array

PeterS3 — Thu, 01 Apr 2021 15:17:19 GMT

Hello,

I try to read a json response with a tExtractJsonFields, and got this error : java.io.IOException: Already in an array

My json :

{

"CollectionsContainer": [

[

{

"__type": "AccessProfile:Alcea.WebServices(www.alcea.fr)",

"AccessProfileID": 475,

"BackTime": null,

"Description": "xxxxx",

"Disabled": false,

"Name": "1234",

"PassBack": false,

"SupervisorCodeID": 31,

"ValidityBeginDate": "2021-01-01",

"ValidityEnddate": "2021-12-31",

"PeriodCollection": null

}

]

"PageNumber": 1,

"PageSize": 1,

"ProcessingTime": "PT0.0312523S",

"TotalNumber": 11,

"TotalNumberRequest": 1,

"success": true,

"OperationResult": {

"Status": "ALWIN_SDK_OK",

"Message": null,

"SystemMessage": null,

"StackTrace": null

}

I want to recup the field : AccessProfileID

I try a lot of things like that :

but got this error with all my attempts.

I think this is due to the double "[[" on CollectionsContainer...

When I test with simple [ ], i have no problem to recup the field.

Anyone got an idea?

Thx

Re: tExtractJsonFields : java.io.IOException: Already in an array

gjeremy1617088143 — Thu, 01 Apr 2021 15:32:39 GMT

Hi, you can use JsonPath instead of Xpath (in the read by field in your component) set the Jsonpathquery to : "$.CollectionsContainer[*].[*]"

and Json query of your column to : "AccessProfileID".

Send me Love and Kudos

Re: tExtractJsonFields : java.io.IOException: Already in an array

PeterS3 — Fri, 02 Apr 2021 08:21:10 GMT

Thanks you gjeremy, it works!

It seems so simple I wonder why I haven't tested this before ...😑

topic tExtractJsonFields : java.io.IOException: Already in an array in Talend Studio

tExtractJsonFields : java.io.IOException: Already in an array

Re: tExtractJsonFields : java.io.IOException: Already in an array

Re: tExtractJsonFields : java.io.IOException: Already in an array