[{"_id":{"$oid":"639b17befd601480ffbb06d5"},"payload":{"data":{"none":{"GENERAL":{"uom":"J","tuf":"15000","mod":{"type":"FORMULA","start":"2019-01-01T01:00:00Z","t":"1y","f":"1"},"class":"A017","jurisdiction":"IM","language":"EN","Issuer":{"CompanyAddress":{"Country":"IM"}},"Redemption":{"MinimumQuantity":{"UomRedemption":"J","Amount":"1000"},"ValidFrom":"1512086400","ValidUntil":"1577750400"}}},"en":{"GENERAL":{"name":"Electric energy","description":"utility for electry energy supply. ","Issuer":{"CompanyName":"Water&Power Inc","ContactPerson":"Tim Zen","CompanyAddress":{"Addressline1":"Foreworth 99","Addressline2":"9F8/1","ZIP":"7U03","Town":"Douglas"},"WirePhone":"0044918237128","MobilePhone":"004498127312","Website":"http://waterpower.io","OfficePhone":"004498721323","Fax":"004491283211","EmailAddress":"somAddr@waterpower.io","Timezone":"GMT"},"Redemption":{"Condition":"none","Address":{"ShipToCountries":"Only within GB"}}}},"de":{"GENERAL":{"name":"(DE)Electric energy","description":"(DE)utility for electry energy supply.","Issuer":{"CompanyName":"(DE)Water&Power Inc","ContactPerson":"Tim Zen","CompanyAddress":{"Addressline1":"Foreworth 99","Addressline2":"9F8/1","ZIP":"7U03","Town":"Douglas"},"WirePhone":"0044918237128","MobilePhone":"004498127312","Website":"http://waterpower.io","OfficePhone":"004498721323","Fax":"004491283211","EmailAddress":"somAddr@waterpower.io","Timezone":"GMT"},"Redemption":{"Condition":"none","Address":{"ShipToCountries":"(DE)Only within GB"}}}}},"defaultlanguage":"en"}},{"_id":{"$oid":"639b17befd601480ffbb06d6"},"payload":{"data":{"none":{"GENERAL":{"uom":"l","tuf":"7000","mod":{"type":"FORMULA","start":"2019-01-01T01:00:00Z","t":"1y","f":"1"},"class":"A013","jurisdiction":"GB","language":"EN","Issuer":{"CompanyAddress":{"Country":"GB"}},"Redemption":{"MinimumQuantity":{"UomRedemption":"l","Amount":"25"},"ValidFrom":"1496271600","ValidUntil":"1559343600"}},"GOODS":{"Chemistry":{"Purity":"99.3","Analysis":{"MeltingPoint":"-114","RefractiveIndexWaveLength":"0.5876","RefractiveIndex":"1.3616"}}}},"en":{"GENERAL":{"name":"Ethanol","description":"Technical Ethanol, made from Wheat. Can be used for various purposes. For example to make fake Vodka, or to clean the engine.","Issuer":{"CompanyName":"Dry Spirits Inc.","ContactPerson":"jonas.drinkfest@dryspirits.com","CompanyAddress":{"Addressline1":"Jamestown road 22","Addressline2":"34A/5","ZIP":"A839I2","Town":"Herefordshire"},"WirePhone":"0044094358309458","MobilePhone":"004478787283472","Website":"https://dryspirits.uk","OfficePhone":"00449837598473","Fax":"004419823791827","EmailAddress":"office@dryspirits.uk","Timezone":"GMT"},"Redemption":{"Condition":"Shipping with our transportation partner Koala Limps Ltd.","Address":{"Incoterms":"EXW"}}},"GOODS":{"Type":"Industrial Precursors","Chemistry":{"Formula":"C2H5OH","Quality":"PA"}}}},"defaultlanguage":"en"}},{"_id":{"$oid":"639b17bffd601480ffbb06d7"},"payload":{"data":{"none":{"GENERAL":{"uom":"kg","tuf":"2000","mod":{"type":"FORMULA","start":"2019-01-01T01:00:00Z","t":"1y","f":"1"},"class":"A013","jurisdiction":"De","language":"EN","Issuer":{"CompanyAddress":{"Country":"DE"},"ShipFromAddress":{"Country":"DE"}},"Redemption":{"MinimumQuantity":{"UomRedemption":"kg","Amount":"1000"},"ValidFrom":"1546300800","ValidUntil":"1609372800"}},"GOODS":{"Energy":{"Coal":{"OriginCountry":"DE"},"CarbonContent":"99","WaterContent":"1","EnergyContent":"69"}}},"en":{"GENERAL":{"name":"Coal","description":"Fine anthrazit coal from the core of the mountains. Excavated and brought to you by the worlds most reliable coal producer.","Issuer":{"CompanyName":"Grabefroh Schleishausen AG","ContactPerson":"Thomas Bergmann","CompanyAddress":{"Addressline1":"Berlinerstrasse 2","ZIP":"38945","Town":"Schleishausen am Wechsel"},"ShipFromAddress":{"ZIP":"38945","Town":"Schleishausen am Wechsel"},"WirePhone":"0049192837","MobilePhone":"0049734687326","Website":"grabefroh-schleishausen.de","OfficePhone":"004918237622","EmailAddress":"hallo@grabefroh-schleishausen.de","Timezone":"GMT+1"},"Redemption":{"Condition":"Bring your own lorry","Address":{"Incoterms":"EXW"}}},"GOODS":{"Type":"Fuel","Energy":{"EnergyCarrier":"Carbon","Coal":{"CoalType":"Anthracite"}}}}},"defaultlanguage":"en"}}]

db.collection.aggregate([{$addFields:{defLangData:{$arrayElemAt:[{$map:{input:{$filter:{input:{$objectToArray:"$payload.data"},as:"arr",cond:{$eq:["$$arr.k","$payload.defaultlanguage"]}}},as:"arr",in:"$$arr.v"}},0]}}},{$addFields:{CustomDefinitionItems:{$filter:{input:{$concatArrays:[{$objectToArray:"$defLangData.GENERAL"},{$objectToArray:"$payload.data.none.GENERAL"}]},as:"arr",cond:{$not:{$in:["$$arr.k",["name","description","language","jurisdiction","uom","currency","tuf","mod","class","refId"]]}}}}}}])