Try that: [ { "operation": "shift", "spec": { "*": { "Ean": "[&1].gtin", "ean": "[&1].gtin", "EAN": "[&1].gtin", "EanCode": "[&1].gtin", "EAN-Code": "[&1].gtin", "EANCode": "[&1].gtin", "Ausdr1": "[&1].gtin", "Bestand": "[&1].qty", "Menge": "[&1].qty", "Stock": "[&1].qty", "stock": "[&1].qty", "Verfügbare Menge (Kennzahl)": "[&1].qty", "Verfügbare Menge": "[&1].qty" } } }, { "operation": "modify-default-beta", "spec": { "*": { "update_date": "2022-11-03", "supplier_name": "demo", "file_name": "test" } } } ] Greetings ... View more

Hi @SAMSAL, thanks, i have try this out and it works. I thought you can directly edit the value of the JSON file. Now I have to merge all split JSON files into one again ... View more

Hi, It doesnt seem like "Stuff" function is recognized function through the QueryRecord sql. I think you have two options: 1- If you are dumping this data into a database where you can use the stuff function there then delegate this to SQL before storing\processing the data. 2- Instead of trying to use QueryRecord processor I would try and use the JoltTransformJson with the following spec:     [ { "operation": "modify-overwrite-beta", "spec": { "*": { "tempStart": "=split('', @(1,start_time))", "tempEnd": "=split('', @(1,start_end))", "start_time": "=concat(@(1,tempStart[0]),@(1,tempStart[1]),':',@(1,tempStart[2]),@(1,tempStart[3]))", "start_end": "=concat(@(1,tempEnd[0]),@(1,tempEnd[1]),':',@(1,tempEnd[2]),@(1,tempEnd[3]))" } } }, { "operation": "remove", "spec": { "*": { "temp*": "" } } } ]   Not sure how this will perform with large dataset but its worth testing. Hope that helps, if it does please accept solution. Thanks     ... View more

I have found a solution. I use in the Query Record Processor the sql function substring and  it worked as expected for my case   SELECT SUBSTRING("Interval start", 12, 5) as "start_time" FROM FLOWFILE     store_id date start_time end time out 1005 20220915 00:00 00:15 0 ... View more

The Nifi Processor ConvertCharacterSet helps. I use this before the Nifi Processor convert csv to json     ... View more

Hi,   I dont think you need the asterisk "*" in the spec, since you need it on the first level and you dont need to reference any other fields. Just have your spec as follows:     [ { "operation": "modify-default-beta", "spec": { "target.organisation": "${target.organisation}" } } ]       ... View more

I have found the solution, for the changing parts of the url https://mycompany\.my\.app/api/public/v1/organisations/([0-9a-z]+)/detailedLaborcosts.* ... View more