Hi,  Please i need your kind help. SCENERIO: INSERT CONTENT OF AN XML FILE AS A FIELD INTO A DATABASE - I am trying to read the content of an xml file into a flowfile attribute - I want to use the attribute as variable in sql query statement to insert the content into a DB ISSUES: - I tried to use both Xpath & Xquery but no success.   DATA: The data i am trying to convert is as below   <?xml version='1.0' encoding='utf-8'?> <!DOCTYPE database> <database xmlns='http://www.lotus.com/dxl' version='9.0' maintenanceversion='1.0' replicaid='8525886700702AFD' path='BStravel2.nsf' title='BSTravel_Expenses_and_Vacations' maintainunread='false' optimizetablebitmaps='true' increasemaxfields='true' compressdesign='true' compressdata='true' markmodifiedunread='false' logtransactions='false' uselz1='true'> <databaseinfo dbid='85256700702AFD' odsversion='43' diskspace='261440' percentused='96.2421875' numberofdocuments='13'><datamodified><datetime dst='true'>20220813253,61-04</datetime></datamodified><designmodified ><datetime dst='true'>2022062936,80-04</datetime></designmodified></databaseinfo> <launchsettings><noteslaunch whenopened='openframeset' frameset='Launch' showaboutdocument='never'/></launchsettings></database>     Thank you so much for all your help . ... View more

Hello, please kindly help. i am trying to convert a datetime(attribute) from one format to the other but it keeps giving me empty value on the attribute: SCENERIO: Flowfile is json----->extract date from Json flowfile using Evaluatejsonpath---->format date using Updateattribute Actual Date: "2022-08-01 00:00:00.0" Desired date: "01/08/2022 00:00:00.000000" I have tried to use this on the updateattribute, but it is not working: ${DATE_TIME:toNumber():toDate('yyyy-MM-dd hh:mm:ss.S'):format('dd/MM/yyyy HH:mm:ss.SSSSSS')}   Thank you. ... View more

Hello, Please kindly help to resolve this error. I am trying to learn how to create a Nifi custom processor following this tutorial: https://help.syncfusion.com/data-integration/how-to/create-a-custom-processor#_Project_Creation%22%22   But i don't know the class to import to solve the below error:   Below are all the imports i have on the file import org.apache.nifi.components.PropertyDescriptor; import org.apache.nifi.flowfile.FlowFile; import org.apache.nifi.annotation.behavior.ReadsAttribute; import org.apache.nifi.annotation.behavior.ReadsAttributes; import org.apache.nifi.annotation.behavior.WritesAttribute; import org.apache.nifi.annotation.behavior.WritesAttributes; import org.apache.nifi.annotation.lifecycle.OnScheduled; import org.apache.nifi.annotation.documentation.CapabilityDescription; import org.apache.nifi.annotation.documentation.SeeAlso; import org.apache.nifi.annotation.documentation.Tags; import org.apache.nifi.processor.AbstractProcessor; import org.apache.nifi.processor.ProcessContext; import org.apache.nifi.processor.ProcessSession; import org.apache.nifi.processor.ProcessorInitializationContext; import org.apache.nifi.processor.Relationship; import org.apache.nifi.processor.util.StandardValidators;   import java.io.IOException; import java.io.InputStream; import java.io.OutputStream; import org.apache.nifi.processor.io.StreamCallback; import org.apache.nifi.processor.exception.ProcessException; import java.util.ArrayList; import java.util.Collections; import java.util.HashSet; import java.util.List; import java.util.Set;     Thanks for your kind help ... View more