Hi, Please see the modified spec below. The comments indicate what I had to do to make your modify-overwrite-beta spec works based on the input json. I hope it works.   [{ "operation": "modify-overwrite-beta", "spec": { "FatturaElettronicaBody": { // The DatiGenerali level is not found in the input JSON // "DatiGenerali": { "DatiBeniServizi": { "DettaglioLinee": { "*": { //level3 "ScontoMaggiorazione": { // level2 "*": { // Quantita is located level 3 and not level 1 "Importo": "=divide(@(1,Importo),@(3,Quantita))" } } } } } //} } } }]     ... View more

Hi, I believe this spec would help with setting the date as default date in each array element:   [ { "operation": "modify-overwrite-beta", "spec": { "FatturaElettronicaBody": { "DatiGenerali": { "DatiDDT": { "NumeroDDT": "=split('[,]',@(1,NumeroDDT))" } } } } }, { "operation": "shift", "spec": { "FatturaElettronicaBody": { "DatiGenerali": { "DatiGeneraliDocumento": "FatturaElettronicaBody.DatiGenerali.&", "DatiDDT": { "NumeroDDT": { "*": { "@": "FatturaElettronicaBody.DatiGenerali.DatiDDT[&1].NumeroDDT", "@(3,DatiGeneraliDocumento.Data)": "FatturaElettronicaBody.DatiGenerali.DatiDDT[&1].Date" } } } } } } } ] If that helps please accept solution. ... View more

Hi, One of the main differences that I can see is that the QueryDatabaseTableRecord has a RecordWriter which allows you to to decide the format of the output (Json, xml, csv , parquet ...etc.) where a service need to be setup for the record writer depending on the format, while the QueryDatabaseTable will only provide an Avro format output without the need to setup any record writer service. This is similar to the case of  processors ExecuteSQL vs ExecuteSQLRecord. Another important difference I see is the QueryDatabaseTable  has property setting for "Transaction Isolation Level" while the other doesn't If that helps please accept solution. Thanks   ... View more