neelamanikandan
New Contributor II
Joined 3 years ago
User Profile
User Widgets
Contributions
Re: Json splitter for multiple array objects
Vehicle_Id InceptionDt @_Id $ ServiceCompanyAddressLine1 ServiceCompanyPhone ServiceCompanyPostalCode _Id4 08/03/2023 _Id5 ServiceCompany45 ServiceCompanyAddressLine150 ServiceCompanyPhone26 ServiceCompanyPostalCode2 _Id4 08/03/2023 _Id5 ServiceCompany45 ServiceCompanyAddressLine163 ServiceCompanyPhone9 ServiceCompanyPostalCode15 _Id4 08/03/2023 _Id6 ServiceCompany47 ServiceCompanyAddressLine150 ServiceCompanyPhone26 ServiceCompanyPostalCode2 _Id4 08/03/2023 _Id6 ServiceCompany47 ServiceCompanyAddressLine163 ServiceCompanyPhone9 ServiceCompanyPostalCode154.1KViews0likes0CommentsRe: Json splitter for multiple array objects
Hi RogerSramkoski It was a question, in the above example I had 2 (Servicecompany and Servicecompanydetail) fields that had values in array, so I have used 2 JSON splitters in the pipeline. But if my input JSON contains multiple(eg. 10) array fields should I always use multiple (10 JSON splitters) in the pipeline? Is there alternate Snap that can flatten all the Array elements at one go, or is there an alternative approach to use the JSON splitter to flatten all arrays4.1KViews0likes0CommentsJson splitter for multiple array objects
I have a Json input that contains multiple array objects within it. Json sample given below. I'm trying to flatten this data into table rows, I use two json splitter to achieve this. First Json splitter with Split path $ServiceCompanyArray and then a mapper to map the split value and then another Json splitter with split path $ServiceCompanyDetailArray and then another mapper to Writer. Note: this is an xample Json, the actual Json could have multiple array fields, so should we always use N number of json splitters. { "Vehicle_Id": "_Id4", "InceptionDt": "2023-08-03", "ServiceCompanyArray": [ { "@_Id": "_Id5", "$": "ServiceCompany45" }, { "@_Id": "_Id6", "$": "ServiceCompany47" } ], "ServiceCompanyDetailArray": [ { "ServiceCompanyAddressLine1": "ServiceCompanyAddressLine150", "ServiceCompanyPhone": "ServiceCompanyPhone26", "ServiceCompanyPostalCode": "ServiceCompanyPostalCode2" }, { "ServiceCompanyAddressLine1": "ServiceCompanyAddressLine163", "ServiceCompanyPhone": "ServiceCompanyPhone9", "ServiceCompanyPostalCode": "ServiceCompanyPostalCode15" } ] }5.2KViews0likes6CommentsSplitting Json with array[0]
I have a Json data, that contains a field that could be an array as per Source definition. Json given below It is not always mandatory that the FeeReductionDetail will always be an array with multiple elements, sometimes it could be with just one element i.e., array [0]. I use a Json splitter with JSON Path to Split* as FeeReductionDetail to flatten out the array and convert the above Json into two table rows, this work when the Split path contains a real list of values, but when there is only one element it fails. Json splitter Sucess : Json example { "VehicleId": "_Id4", "FeeReduction": { "FeeReductionDetail": [ { "Type": "Type10", "ExpirationDate": "2023-08-03", "ManagementFee": "2.2", "ExpenseRatio": "8.3", "DividendExpense": "1.0" }, { "Type": "Type21", "ExpirationDate": "2023-08-03", "ManagementFee": "4.3" } ] }, "SwitchingFee": "4.1", "TransactionFee": "6.1", "MaxManagementFee": "1.1", "ActualManagementFee": "8.4", "ProspectusDate": "2023-08-03", "CtgyId": "Id315" }. Json Splitter Failure : Json example { "VehicleId": "_Id4", "FeeReduction": { "FeeReductionDetail": { "Type": "Type10", "ExpirationDate": "2023-08-03", "ManagementFee": "2.2" } }, "SwitchingFee": "4.1", "TransactionFee": "6.1", "MaxManagementFee": "1.1", "ActualManagementFee": "8.4", "ProspectusDate": "2023-08-03", "CtgyId": "Id315" }.Solved3.1KViews0likes2CommentsDynamically change the Delimiter in CSV parser
I’m designing ah pipeline that will handle multiple delimiters in a single CSV parser. I’m using a expression library that has the delimiter details of the respective files as below. [ { “src_file”: “aab”, “Delimit”: “PIPE”, “tgt_table”: “T_STG_AAB” } }, { “src_file”: “abc”, “Delimit”: “TAB”, “tgt_table”: “T_STG_ABC” } }, { “src_file”: “efg”, “Delimit”: “COMMA”, “tgt_table”: “T_STG_EFG” } } ] On the mapper snap I can write expression to refer this expression library lib.sample.find(x => x.src_file==“incoming_filename”).get(‘Delimit’). But when I try to use the same in CSV parser it doesnt accept. can we really do this.