can't extract JSON tExtractJsonFields from tOracleInput field

[Anonymous]

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.

[David_Beaty]

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

[vboppudi]

Hi,

Please try the following settings in tExtractjsonFields.

Regards,

[Anonymous · Accepted solution]

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