Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
David_Lan
Contributor
Contributor

tExtractJSONFields component return errors

Hello,

I want to parse the following json files:

*******BEGIN

{

    

"IdDossier"

"53"

,

    

"Agent"

"009"

,

    

"Apporteur"

1

,

    

"LibAffaire"

"Test1"

,

    

"Clients"

 : {

        

"1"

:{

                

"sIdClient"

 : 

"123456XYZ"

,

                

"Civilite"

 : 

1

,

                

"Nom"

 : 

"BRAD"

        },

        

"2"

:{

                

"sIdClient"

 : 

"567896XYZ"

,

                

"Civilite"

 : 

1

,

                

"Nom"

 : 

"JEFF"

        }

     }

}

**** END

When I add a new index under Clients (1 and 2), the tExtractJSONFields return the error below :

Error on line 1 of document : Le contenu des éléments doit inclure un balisage ou des caractères au format correct.

[ERROR] 20:34:22 csf_horizon.copy_of_testdl_0_1.Copy_of_testdl- tExtractJSONFields_1 - Error on line 1 of document : Le contenu des éléments doit inclure un balisage ou des caractères au format correct.

Without the index, no error appears and the json format is OK.

Thank you for your help.

Labels (3)
1 Reply
Anonymous
Not applicable

Hi

It seems like the json format is invalid. Can you show an example of Json file after you add a new index under Clients? You can validate the json format via online website.

 

Regards

Shong