topic Re: can't extract JSON tExtractJsonFields from tOracleInput field in Talend Studio

can't extract JSON tExtractJsonFields from tOracleInput field

Anonymous — Sat, 16 Nov 2024 08:10:32 GMT

Hi,

i'm having problems with the tExtractJsonFields component.

We have a table in oracle database with a field that contains json data.

This is an example;

{"id":"ffcf1b00-df24-4349-9880-adf64afb6205","dueDate":"2018-05-31T12:00:00Z","message":"There is (are) {0} uploaded file(s) which","additionalReferenceDescription":"025259-M01","fileType":"LFF","idCountry":"ES","cid":"011023","cuid":"025259","lid":"MC15S13","pid":"998034","category":{"id":1,"description":null},"type":{"id":15,"description":null},"creation":"2018-05-30T13:37:00.1283729Z","fileId":"41eb29c2-bcad-4796-b83a-115f042d2bc2","cycleId":"211c3afb-6c6e-04ad-e053-353b810bc100","timetableId":"211c3afb-6c6c-04ad-e053-353b810bc100","changeRequestId":null,"timetableApprovalId":null,"paygroup":"c74aeda7-11dc-4e43-bbb6-f76c75ad8bca","paygroupAssignmentId":"81be406d-e1ee-4a41-b813-ab117e8a8acc","idPaygroup":"0000","clientId":"7786cb10-94e3-4813-bacb-d028cdf2d6d6","entityId":"07f871f8-71f1-4916-a8ad-78d955e69b79","partnerId":"f61be5dd-a001-4639-b367-78c0772c60b3","platformId":"40522568-e740-431a-aac3-fc6849cc9972","side":2,"paygroupName":"No Paygroup [0000]","entityName":"entity MC15 [025259]","clientName":"SPM1.3 client [011023]","scope":null}

But it appears an error: java.io.IOException: Illegal character: <o>

for each register that tries to extract.

Can anyone help me with that??

I've attached some screenshots with the design.

Thanks in advanced.

Re: can't extract JSON tExtractJsonFields from tOracleInput field

David_Beaty — Sun, 03 Jun 2018 22:24:52 GMT

Hi,

i wonder if it’s having an issue with the numeric values in curly braces for the number of files uploaded.

the only other issue I’ve exoerienced with extracting data from JSON is if you have numeric prefixed tags.

thanks

David

Re: can't extract JSON tExtractJsonFields from tOracleInput field

vboppudi — Mon, 04 Jun 2018 16:10:22 GMT

Hi,

Please try the following settings in tExtractjsonFields.

Regards,

Re: can't extract JSON tExtractJsonFields from tOracleInput field

Anonymous — Tue, 05 Jun 2018 15:44:01 GMT

Hi, finally i found the problem, it was because in the input of the json component my json field it was an "object" type and not a "string" type. So, very easy, I've changed the type in the schema in the input with a string and everything goes well.

Thanks