Nosql json to table

Queries and Resources
1

Hi,
i have this json response from ninox API:
[

{
"id": 681,
"sequence": 112161,
"createdAt": "2021sdsd:16:08",
"createdBy": "lbhhsdsdsdfu9uj2v",
"modifiedAt": "2021-10-04T14:16:47",
"modifiedBy": "lbsdsdsdufu9uj2v",
"fields": {
"Straße": "Gersdsdsd/36",
"Ort": "Fasdasdrg",
"Name oder Firma": "sdsdser",
"Postleitzahl": "790924248",
"Kunden Nummer": "19534",
"Personen": [
679
],
"Aufträge": [
1038
],
"Dokumente": [
4947,
4948
]
}
},
{
"id": 682,
"sequence": 121726,
"createdAt": "20sdsd1T09:45:14",
"createdBy": "lbhsdsdcufu9uj2v",
"modifiedAt": "202sdsdsd1T11:41:33",
"modifiedBy": "lsdsdufu9uj2v",
"fields": {
"Straße": "asdasd",
"Ort": "asasd",
"Name oder Firma": "asasdasd",
"Angebote": [
613
],
"Postleitzahl": "24233",
"Kunden Nummer": "4224",
"Personen": [
686
],
"Aufträge": [
1045
],
"Dokumente": [
5053,
5054
],
"Bemerkung Kunde intern": "asd",
"Banktyp": "asd"
}
}
]
I want to have every element "id" as row and every key in fields as column...
How can I achieve this?

2

okay I found a solution... {{ ninox.data.map(x=>x['fields']) }}

3

Guten nachmittag @ben10,

Right! you'll need to transform your data before you display it. I scrambled this together which probably can be written in a much nicer way but get's the point across:

var formattedResponse = []

rawResponse.map((x) => {
  var fields = x.fields
  delete x.fields
  
  var formatted = {
    "Straße": fields["Straße"], 
    "Ort": fields["Ort"], 
    "Name oder Firma": fields["Name oder Firma"], 
    "Angebote": fields["Angebote"], 
    "Postleitzahl": fields["Postleitzahl"], 
    "Kunden Nummer": fields["Kunden Nummer"], 
    "Personen": fields["Personen"].join(', '), 
    "Aufträge": fields["Aufträge"].join(', '), 
    "Dokumente": fields["Dokumente"].join(', '), 
    "Bemerkung Kunde intern": fields["Bemerkung Kunde intern"], 
    "Banktyp": fields["Banktyp"]
  }
  
  var output = {...x, ...formatted}
  formattedResponse.push(output)
})

return formattedResponse
2 Likes