Rename Keys Node - JSON Doted notation to spaces

I have a Json output like the one below.
I want to rename all keys from the dot notation to key names that are seperated by a single space.

Example:
"lastModifiedBy.application.id" -> "lastModifiedBy application id"

{"lastModifiedBy": {
"application": {
"id": "ölkaelfhasdfgjkhasödfgklahöslkf",
"displayName": "n8n"
}
}
}

My reason is that otherwise NOCODB wont recognise the fields during Automatching key names.
(There are plenty more keys, thats the reason I’m not doing it manually)

O this kinda did the trick:

Source: Flattening a JSON object in JavaScript

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.