Thank you for your answer! The output (with redacted values) is the following:
[
{
"object": "page",
"id": "{ID}}",
"created_time": "2024-08-07T16:49:00.000Z",
"last_edited_time": "2024-08-07T17:53:00.000Z",
"created_by": {
"object": "user",
"id": "{ID}}"
},
"last_edited_by": {
"object": "user",
"id": "{ID}}"
},
"cover": null,
"icon": null,
"parent": {
"type": "database_id",
"database_id": "{ID}}"
},
"archived": false,
"in_trash": false,
"properties": [
{
"id": "%3E%3ESP",
"type": "date",
"date": null,
"label": "Datum"
},
{
"id": "%3EV%3A%60",
"type": "people",
"people": [
{
"object": "user",
"id": "{ID}}",
"name": "Luke Test",
"avatar_url": "https://redacted.com/",
"type": "person",
"person": {
"email": "t.test@test.com"
}
}
],
"label": "Verantwortlich"
},
{
"id": "D%3CrZ",
"type": "files",
"files": [],
"label": "Medien / Datein"
},
{
"id": "N%5C%7Cj",
"type": "url",
"url": null,
"label": "Links"
},
{
"id": "RjtT",
"type": "url",
"url": null,
"label": "Kontaktseite"
},
{
"id": "%5CW%5DY",
"type": "phone_number",
"phone_number": "+4912345678912",
"label": "Telefon"
},
{
"id": "al%3AW",
"type": "multi_select",
"multi_select": [],
"label": "Zugehörig"
},
{
"id": "hpFU",
"type": "last_edited_time",
"last_edited_time": "2024-08-07T17:53:00.000Z",
"label": "Letzte Änderung um"
},
{
"id": "rS%3E_",
"type": "email",
"email": "t.test@test.com",
"label": "E-Mail"
},
{
"id": "%7BZ%5Eh",
"type": "status",
"status": {
"id": "{ID}}",
"name": "In Bearbeitung",
"color": "blue"
},
"label": "Status"
},
{
"id": "%7Ch%7B%7C",
"type": "created_time",
"created_time": "2024-08-07T16:49:00.000Z",
"label": "Erstellt um"
},
{
"id": "title",
"type": "title",
"title": [
{
"type": "text",
"text": {
"content": "Tim Test",
"link": null
},
"annotations": {
"bold": false,
"italic": false,
"strikethrough": false,
"underline": false,
"code": false,
"color": "default"
},
"plain_text": "Tim Test",
"href": null
}
],
"label": "Name"
},
{
"id": "{ID}}",
"type": "checkbox",
"checkbox": false,
"label": "Done"
}
],
"url": "https://www.notion.so/{ID}",
"public_url": null,
"request_id": "{ID}}",
"properties_value": {
"Datum": null,
"Verantwortlich": [
{
"object": "user",
"id": "{ID}}",
"name": "Luke Test",
"avatar_url": "https://redacted.com/",
"type": "person",
"person": {
"email": "t.test@test.com"
}
}
],
"Medien / Datein": [],
"Links": null,
"Kontaktseite": null,
"Telefon": "+4912345678912",
"Zugehörig": [],
"Letzte Änderung um": "2024-08-07T17:53:00.000Z",
"E-Mail": "t.test@test.com",
"Status": {
"id": "b118c21f-d642-4287-9976-3c2ad635227a",
"name": "In Bearbeitung",
"color": "blue"
},
"Erstellt um": "2024-08-07T16:49:00.000Z",
"Name": [
{
"type": "text",
"text": {
"content": "Tim Test",
"link": null
},
"annotations": {
"bold": false,
"italic": false,
"strikethrough": false,
"underline": false,
"code": false,
"color": "default"
},
"plain_text": "Tim Test",
"href": null
}
],
"Done": false
}
}
]
The solution is probably going to be some combination of map(), flatten() and slice(), but I just can’t seem to figure out how to do it
