topic Re: An invalid XML character in JSON file in Talend Studio

An invalid XML character in JSON file

hiba1 — Wed, 02 Dec 2020 21:47:58 GMT

Hi ,

want to load data from JSON files to my data base (Mysql server).

a have this error whene i'm trying to execute my job:

any help please i can't resolve this problem !

Anonymous — Thu, 03 Dec 2020 02:06:40 GMT

Can you show an example of your Json file? It seems it is an invalid Json file.

Regards

Shong

hiba1 — Thu, 03 Dec 2020 08:53:13 GMT

Hi @Shicong Hong ,

thanks for reply.

this is the file :

hiba1 — Wed, 09 Dec 2020 08:38:42 GMT

can someone help me please!

Anonymous — Tue, 15 Dec 2020 10:23:49 GMT

@[hiba]

Take a look at this post on stackoverflow, you have to remove or replace the invalid XMl character before reading it.

https://stackoverflow.com/questions/40306289/an-invalid-xml-character-unicode-0x3-was-found-in-the-element-content-of-the

Here is a similar post.

https://community.talend.com/s/feed/0D53p00007vCoohCAC

Regards

Shong