Add option for automatic flatner of any json attribute in xyz-layer loaded.

heremaps / xyz-qgis-plugin

Plugin for QGIS to connect to the HERE Platform IML

https://plugins.qgis.org/plugins/XYZHubConnector/

MIT License

27 stars 10 forks source link

Add option for automatic flatner of any json attribute in xyz-layer loaded. #40

Open jvidin opened 3 years ago

jvidin commented 3 years ago

As an analyst i would like to jump straight away into labeling and symbology in Qgis using flat attributes and avoiding the need to dive into the exposed string json structures received when loading xyz layers.

Please see below an image example of a flaten attribute.

SNAGHTML12aff953

minff commented 3 years ago

Hi @jvidin, thanks for the suggestion, it would be very useful for nested json string. Could you share how you flattened the attributes as shown in the screenshot ? Was it done with some built-in QGIS functions ?

jvidin commented 3 years ago

Hi , screenshot is from FME tool ... this is how they internally flaten the nested json structures and expose them. docs I belleive pandas.json_normalize does something similar.