Four Stars

can't extract JSON tExtractJsonFields from tOracleInput field

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Four Stars

Re: can't extract JSON tExtractJsonFields from tOracleInput field

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

3 REPLIES
Seven Stars

Re: can't extract JSON tExtractJsonFields from tOracleInput field

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

Regards

David

Don't forget to give Kudos when an answer is helpful or the solution.
Nine Stars

Re: can't extract JSON tExtractJsonFields from tOracleInput field

Hi,

 

Please try the following settings in tExtractjsonFields.

 

OracleJson1.PNGOracleJson2.PNG

Regards,

Veeru Boppudi
Four Stars

Re: can't extract JSON tExtractJsonFields from tOracleInput field

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