Hi, i failed to convert this format to an CSV with header
Has anyone seen this type of structure before?
Thanks for all
{
"nbResults": "2",
"columnList": [
"THE_LIBELLE",
"THE_ACTIF",
"THE_DT_CREA",
"THE_UTIL_CREA",
"THE_DT_DERN_MAJ",
"THE_UTIL_DERN_MAJ",
"THE_ORDRE"
],
"keyList": [
"THE_ID"
],
"rowList": [
{
"columnDataList": [
"Commercial",
"1",
"11/10/2022 18:15",
"Test X",
"11/10/2022 18:15",
"Test Y",
"1"
],
"keyDataList": [
"1"
]
},
{
"columnDataList": [
"Culturelle",
"1",
"11/10/2022 18:15",
"Test X",
"11/10/2022 18:15",
"Test Y",
"2"
],
"keyDataList": [
"2"
]
}
]
}
Gives you:
If the schema is always the same, you could skip reading the schema definition and simply use something like an AttributeManager to rename the list items as needed, e.g.
If the schema can differ and the workspace needs to be fully dynamic, it's going to be more complicated ;-)