Bobby
New Contributor
Joined 6 years ago
User Profile
User Widgets
Contributions
Parsing of json object with dynamic attribute keys
Hi, I have a nested json, with the inner most element is an array of struct. The key to identify this inner element is a dyamic value. see the numeric value in the below json. the json parser snap works fine with this, but when it comes to splitter, I am not able to give the actual value to split on. has anyone worked had success with a json like this ? { “VehicleName”: “Test Automobile”, “VehicleId”: 0000011111, “renderedDate”: “2022-03-02”, “alternativeVehicle”: { “0000002222”: [ { “priority”: “1”, “VehiclelabelName”: “Car 1”, “VIN”: 72183, “type”: “Manual” }, { “priority”: “2”, “VehiclelabelName”: “Van 1”, “VIN”: 72166, “type”: “Auto” } ], “00002144509”: [ { “priority”: “1”, “VehiclelabelName”: “miniVan 1”, “VIN”: 72432, “type”: “Auto” } ] } }3KViews0likes1CommentExpression output
Is there a way to log ( or to see) the output of an expression after the expression is completely evaluated for parameters. Example : I am using a Generic JDBC execute to retrieve data from a table. This table is a parameter that is being passed from parent pipeline. so my SQL-Statement expression looks like this. "select * from “+ _tableName + " where joindate=”+ Date.now() My requirement is, I should be able to see the final prepared query that reads like "select * from employee where joindate = ‘7-31-2020’ "1.9KViews0likes1Comment