Hi @Shu_ashu  I have the neir input and i want to extract all attributes but i can't got the attributes in the arrays. i have try the jolttransformation processor but no ok Please can you help me [{ "Num_client__c": "3456", "Code_etablissement__c": "4562", "Mode_de_retrait__c": "xx", "OrderNumber": "000001", "Commande_en_stock__c": "y", "Commande_payee__c": "y", "Montant_Commande_TTC__c":"3000", "Status":"En cours", "OrderedDate": "2021-02-20", "Date__c": "2021-02-21", "Heure_de_debut__c":"10:24", "Heure_de_fin__c": "11:15", "shipping_address": [ { "ShippingStreet": "4 Allé du bois", "ShippingPostalCode": "75008", "ShippingCity": "Paris" } ], "orderItems_request": [ { "Code_Base_Produit__c": "AG45", "Quantity": "75", "UnitPrice": "30" }, { "Code_Base_Produit__c": "FF34", "Quantity": "75", "UnitPrice": "20" } ] }, { "Num_client__c": "3456", "Code_etablissement__c": "4562", "Mode_de_retrait__c": "xx", "OrderNumber": "000002", "Commande_en_stock__c": "y", "Commande_payee__c": "y", "Montant_Commande_TTC__c":"3000", "Status":"En cours", "OrderedDate": "2021-02-20", "Date__c": "2021-02-21", "Heure_de_debut__c":"10:24", "Heure_de_fin__c": "11:15", "shipping_address": [ { "ShippingStreet": "4 Allé du bois", "ShippingPostalCode": "75008", "ShippingCity": "Paris" } ], "orderItems_request": [ { "Code_Base_Produit__c": "AG45", "Quantity": "75", "UnitPrice": "30" } ] } ] ... View more

This solution will not work. The failure flow does not go to next putDatabaseRecord processor because the error is exception. Failure flow files will go nowhere ... View more

@Shu_ashu  How to configure the flow if  EvaluateJsonPath Processor flow have recipient mail id and FetchFile has the file path. I have configured as below but two mails are getting triggered. Could you help to modify the flow so that only one mail with attachment will trigger ?      ... View more

great job dude, thanks! 🙂 ... View more

Why doesn't spark work like hive? Just create a temporary directory to store the final files, and finally rename it. ... View more

Do you have this flow available for download? Would be an excellent template ... View more

Hi @calonsca! Please have a look at this spec as well! [ { "operation": "shift", "spec": { "@": "data", "ID": "&", "#${date}": "date", "#${dataset:toLower()}": "dataset" } } ] ... View more

spark-xml package is a good option too. With all options you are limited to only process simple XMLs which can be interpreted as dataset with rows and columns. However, if we make it a little complex, those options won’t be useful.  ... View more

I believe this will fail if you stop your job today and run it tomorrow.. now will change to other day and you will miss the data... ... View more

is there any resolution to this. I am seeing this issue with one of the acid tables which has around 25 M records.  Other tables have 700 M records and are working fine.  Facing this issue only for few tables. ... View more