https://community.cloudera.com/t5/Support-Questions/How-to-convert-json-file-to-csv-file-using-Apache-Nifi/m-p/242178#M203981 <P>Hello,</P><P>I am trying to convert multiple json file into csv file in that,</P><P>In source folder i am getting different json file with different schema. need to convert json file to csv file with dynamic schema mapping and put that file into destination folder. </P><P>I have tried bellow flow,</P><P>1) getFile processor- to get file from source. </P><P>2) UpdateAttribute - set attribute schema.name : record </P><P>3) inferAvroSchema -configure Schema Output Destination : flowfile-attribute Input Content Type : json </P><P>4)convertRecord processor - Record Reader :JsonTreeReader Record Writer :CSVRecordSetWriter </P><P>5) putFile : put file into destination folder.</P><P> But in above flow getting error in convertRecord Processor,</P><P> Error: Failed to process StandardFlowFileRecord[uuid=69603ac0-ac43-44b5-82f3-5c1c89e4abaf,claim=StandardContentClaim [resourceClaim=StandardResourceClaim[id=1547526092906-1, container=default, section=1], offset=878, length=878],offset=0,name=orders1.json.avro,size=878]; will route to failure: Failed to create schema from the Schema Text after evaluating FlowFile Attributes.</P><P> Please find the attached screen-shot of configuration of convert record processor.</P><P>Thanks</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="96716-csvrecordsetwriter.png" style="width: 1366px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/13619iB27CA2B6C51B4288/image-size/medium?v=v2&amp;px=400" role="button" title="96716-csvrecordsetwriter.png" alt="96716-csvrecordsetwriter.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="96715-jsontreereader.png" style="width: 1366px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/13620iE96097F2A279F65E/image-size/medium?v=v2&amp;px=400" role="button" title="96715-jsontreereader.png" alt="96715-jsontreereader.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="96714-inferavroschema.png" style="width: 1366px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/13621i5C8517A22064AD3E/image-size/medium?v=v2&amp;px=400" role="button" title="96714-inferavroschema.png" alt="96714-inferavroschema.png" /></span></P> Sat, 17 Aug 2019 22:02:20 GMT waghmithu 2019-08-17T22:02:20Z