I am trying to convert the following date format -> 8/6/2023 12:46 am to this format -> 2023-08-06 00:46:00. I want to do this using NiFi. I have tried using the UpdateRecod processor for the same and used toDate() and format() for the above conversion. But it didn't give the desired results. How can I achieve this using NiFi? ... View more

Hi, I have an input json as below:   [ { "orderId": "1234567890", "orderName": "Test1", "orderItems": [ { "orderItemId": "01", "orderItemName": "test1-OrderItem1" }, { "orderItemId": "02", "orderItemName": "test1-OrderItem2" } ] }, { "orderId": "12235", "orderName": "Test2", "orderItems": [ { "orderItemId": "01", "orderItemName": "test2-OrderItem1" } ] }, { "orderId": "12236", "orderName": "Test3", "orderItems": [ { "orderItemId": "01", "orderItemName": "test3-OrderItem1" } ] } ]   I want to convert it into text form where we want the order details and then item details for each map in the list. Here is the desired output:   1234567890 Test1 01 test1-OrderItem1 02 test1-OrderItem2 12235 Test2 01 test2-OrderItem1 12236 Test3 01 test3-OrderItem1   This is json to csv conversion, and I am using the ConvertRecord processor and below are the reader and writer configured: 1. Record Reader - JsonTreeReader 2. Record Writer - FreeFormTextRecordSetWriter For the FreeFormTextRecordSetWriter controller service in the text property, I added the key names from the input json like this ${keyName} and got the values but in the next line, I wanted orderItemId from all the maps in the orderItems list. How can I access the values from orderItems list? Thanks in advance!   ... View more

I have an input JSON file and I want to convert it to a fixed-width length type file. If the length is less than the required length, trailing spaces should be added to the field. Here is the sample Input JSON:   [ { "orderId": "1234567890", "orderName": "Test1" }, { "orderId": "12235", "orderName": "Test2" }, { "orderId": "12236", "orderName": "Test3" } ]   Here is the desired Output:   1234567890 Test1 12235 Test2 12236 Test3       The condition here is if the length of orderId(in input JSON) is less than 10 then add the required spaces. Can this be done in Nifi? I want to have fixed-width length files. Thanks in advance! ... View more