Solved

Complicated JSON key-values as import for a database table

Forum|Forum|1 year ago
April 8, 2024
3 replies
53 views

+2

fbrws
BANNED

I want to transform this JSON for import in a database what would be the best practice when using the standard transformers?

{
"keys":[
"day",
"domain",
"subject_identifier",
"kpi_type_code",
"kpi_count",
"kpi_value_min",
"kpi_value_max",
"kpi_value_avg",
"kpi_value_last",
"kpi_alert_condition_lower_limit_last",
"kpi_alert_condition_upper_limit_last",
"kpi_value_extremum_ok",
"kpi_value_avg_ok"
],
"values":[
[
"20240407",
"production",
"7ab20028",
"RA_MAP_FREQUENCY",
1256,
"24,0000",
"24,0000",
"24,0000",
"24,0000",
"0,9000",
"50,0000",
1,
1
],
[
"20240407",
"production",
"7ab20028",
"RA_EXCEPTIONAL_CONDITION_PERCENTAGE",
1440,
"5,9418",
"5,9418",
"5,9418",
"5,9418",
null,
"25,0000",
1,
1
],
]
}

Best answer by danilo_fme

Hi @fbrws

Please, see attached file.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.