Support Questions
Find answers, ask questions, and share your expertise

PutDatabaseRecord Successfully parsed a JSON object from input but failed to convert into a Record object with the given schema.

Explorer

Unable to match the schema of input JSON from processor "JoltTransformJSON".

Input JSON:

[ { "id" : 57467, "code" : "village1006", "created_by_id" : null, "created_date" : null, "l_village_name" : "village1006", "modified_by_id" : 70806, "modified_date" : null, "name" : "village1006", "status" : "{0}", "taluk_id" : 386 } ]

 

JsonPathReader:

 

JsonPathReader1.11.4.png

 

AvroSchemaRegistry

AvroschemaRegistry1.11.4.png

 

 

Data flow to update in MYSQL Database: 

 

DataFlow.png