An invalid XML character in JSON file

[hiba1]

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]

Hi

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

Regards

Shong

[hiba1]

Hi @Shicong Hong​ ,

thanks for reply.

this is the file :

[hiba1]

can someone help me please!

[Anonymous]

@[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