jsonpentahokettle
How to get json keys in Pentaho?
I am trying to get the json keys in Pentaho. This is my json:
{"ID":0,"Landen":"T001047","GN":"GN25010010","Perioden":"2015JJ00","TotaleInvoerwaarde_1":" 2","TotaleInvoerhoeveelheid_2":" 2","TotaleUitvoerwaarde_3":" 1","TotaleUitvoerhoeveelheid_4":" 1","EenheidHoeveelheid_5":"mln kg "}
Altough you can use a modified Javascript value to get the keys. It doesn't give the keys one by one so it doesn't loop correctely. So is there another way to get the json keys?
Solution
Just split the values on "," to get one key-value pair per records, and then remove everything after : and remove doublequotes, "{" and "}", and you are there.... Just basic transformation steps.
Result:
Details:
- Wordpress API JSON return limit
- Object serialization to json, certain fields only
- Using Python APIs to download data and make pandas
- Java android moshi parse Json to Object
- python + json file saving
- How to create rocket + sea orm correct json response?
- How do check for Some vs None in multiple nested enums at once?
- How to delete full object with javascript?
- How to return JSON as a response in Rocket 0.5?
- Import json-simple from Maven failed
- How to map this Json with rest template spring boot
- Jackson triggering JPA Lazy Fetching on serialization
- while using python web-scraping faced error
- Json Deserialization parsing non valid Json object
- How to marshal a byte/uint8 array as json array in Go?
- Create OBJECT with column values as Key in Snowflake
- PowerShell - ConvertTo-Json how to get ndjson result
- How do I serve both HTML and JSON content with Flask?
- JSON Schema - Foreign Key (FK) Validation
- Setting Base Path using ConfigurationBuilder
- How to route json into multiple attributes in Nifi?
- Jolt Transformer to match key array with value arrays
- zsh - How to assign a miltiline json string with substituted values to a variable
- Looping problem when serializing objects to JSON in Spring Boot
- How to write JSON string value in code?
- How to render static files within Gin router?
- How to configure custom MediaType in Spring MVC?
- No String-argument constructor/factory method to deserialize from String value ('')
- Is there any way i can get both Matter and Arcade physic in Player object
- Syntax for row_to_json with sqlalchemy