Home > database >  Kettle JSON INPUT parsing JSON string
Kettle JSON INPUT parsing JSON string

Time:10-13

You greatly, while using the JSON kettle run into a problem when I INPUT parsing JSON string
I have a JSON string
{" errorCode ":" 0 ", "realName" : "Zhang Xiaoming", "schoolId:" 13068, "schoolName" : "the 452 primary schools,"
"TeachClasses" : [{" className ":" three class 3, grade ", "classRole" : "0" and "croName" : "primary school", "croid" : 3, "gradeId" : 6, "gradeName" : "third grade", "id", 31105, " teachSubjects " : [{" id ": 4," subjectName ":" mathematics "}]},
{" className ":" grade four class 4 ", "classRole" : "1", "croName" : "primary school", "croid" : 3, "gradeId" : 7, "gradeName" : "fourth grade", "id" : 31106}], "uid" : 1003147629, "uuid" : "T0000001003147629}
"
Because the JSON string teachClasses is a JSON string, so you need to do 2 times, but in this teachClasses string, teachSubjects probably does not exist, so I'm using JSON INPUT analytical tools,

A runtime error, will prompt
The data structure is not The same inside The resource! We found 1 values for json path [$.. teachSubjects], which is the company that the number retourned for path [$.. the className] values (2). We MUST have the same number of values for all paths.
Is there a great god help online, etc., nasty nasty,

There is a problem, when teachSubjects exist inside identifier is written with outer id id repeat, complains, prompt information as above,

CodePudding user response:

Solve the yao finally
I also encountered this problem

CodePudding user response:

Layered to parsing

CodePudding user response:

Can be used to filter out the formulas do not exist

CodePudding user response:

How to resolve? Give advice or comments about the
  • Related