topic Re: tExtractJSONField : Premature end of file error. in Talend Studio

tExtractJSONField : Premature end of file error.

MAnywar — Fri, 18 Nov 2022 14:03:15 GMT

I have am trying to extract fields from a json string: but I keep getting the error: Error on line 1 of document : Premature end of file.

{

"PAT_ID":null,"MPI":null,"ACCESSION_NO":"RAD-2022-","SERIES_IUID":"1.3.12.2.1107","SERIES_DESC":"T1_VIBE_DIXON_TRA_OPP","NUM_INSTANCES":"544678","STUDY_IUID":"2.20266.966.819132811","STUDY_DATETIME":"2022-09-22","SRC_AET":"ACHIEVA2","MODALITY":"MR","BODY_PART":"WHOLEBODY","LATERALITY":"098","POTID":"KK"

}

I tried replacing the nulls with some values but I get the same error.

I also tried to just work with only one field: {"PAT_ID":"993"}. But I get the same error. Any help is highly be appreciated. Thank you.

Screenshot of the reading part of the job.

Re: tExtractJSONField : Premature end of file error.

Anonymous — Fri, 18 Nov 2022 15:18:17 GMT

I just validate your json string on site and confirm that it is a valid json string, i use a tFileInputJson to read the json file and it works.

Can you share a screenshot of the basic settings of tExtactJsonFields?

Regards

Shong

Re: tExtractJSONField : Premature end of file error.

MAnywar — Fri, 18 Nov 2022 16:57:38 GMT

Yes, you are right. when I use tFileJson, the file is read. but when I use tExtract, it fails because I was saying ready by Xpath instead of Jsonpath. After changing to Read by Jsonpath, all is being read now.

Thanks a bunch!

Re: tExtractJSONField : Premature end of file error.

Anonymous — Sat, 19 Nov 2022 07:57:40 GMT

Great, thanks for your feedback!

Re: tExtractJSONField : Premature end of file error.

MAnywar — Fri, 25 Nov 2022 08:32:38 GMT

Hello team,

I did not want to create a 2nd issue but this is kind of similar; I have a problem with reading loops in a string.

I tried converting the data from xml to json hoping there will be some change, but i have not been successful..

Attached is screenshot of part of the job doing the above.

So I have I would like to extract:

Medication/code/coding/code/@value,

Medication/ingredient/extension/valueCoding/code/@value,

Medication/ingredient/itemCodeableConcept/coding/display/@value

All these have varying number of times they can loop. On one document, they could just appear once. On another probably 10 time. I cannot tel how many times each appear.

I will be grateful for any help or advise,

Here is my sample data:

</identifier>

<code>

</coding>

</coding>

</code>

<form>

</coding>

</form>

</valueCoding>

</extension>

</coding>

</itemCodeableConcept>

</numerator>

</denominator>

</strength>

</ingredient>

</valueCoding>

</extension>

</coding>

</itemCodeableConcept>

</numerator>

</denominator>

</strength>

</ingredient>

</Medication>