Describe the problem/error/question
I’m trying to extract some email adresse from an array subscriptions but there are more than one object inside. How can i split them or extract them. I tried out many things but i allways get stucked. Maybe someone have a hint vor me
[
{
“total_count”: 9,
“subscriptions”: [
{
“id”: 23204278,
“firstname”: “Sandra”,
“surname”: null,
“company”: null,
“email”: “@",
“country”: null,
“street”: null,
“house_number”: null,
“postcode”: null,
“city”: null,
“province”: null,
“phone”: null,
“external_id”: “”,
“extra_fields”: {},
“consent_fields”: null,
“custom_field”: “”,
“registration_ip”: “”,
“viewing_ip”: null,
“viewing_country”: null,
“viewing_device”: null,
“confirmation_link”: “”,
“watch_link”: “”,
“watched”: false,
“watch_start”: null,
“watch_end”: null,
“watch_duration”: null,
“watched_live”: false,
“watched_replay”: false,
“watched_yesterdays_replay”: false,
“watch_start_replay”: null,
“watch_end_replay”: null,
“watch_duration_replay”: null,
“payment_to_watch_completed”: false,
“eligible_to_watch”: true,
“unsubscribed”: false,
“unsubscribed_at”: null,
“time_zone”: “Europe/Vienna”,
“created_at”: 1695278477,
“email_updated_at”: null,
“email_verified”: true,
“email_verified_at”: 1695278477,
“assessment_passed_at”: null
},
{
“id”: 23189891,
“firstname”: “Jana”,
“surname”: null,
“company”: null,
“email”: "",
“country”: null,
“street”: null,
“house_number”: null,
“postcode”: null,
“city”: null,
“province”: null,
“phone”: null,
“external_id”: “”,
“extra_fields”: {},
“consent_fields”: null,
“custom_field”: “”,
“registration_ip”: "1",
“viewing_ip”: "1",
“viewing_country”: “Switzerland”,
“viewing_device”: “Mobile”,
“confirmation_link”: “”,
“watch_link”: “”,
“watched”: true,
“watch_start”: 1695220460,
“watch_end”: 1695221480,
“watch_duration”: 1020,
“watched_live”: false,
“watched_replay”: false,
“watched_yesterdays_replay”: false,
“watch_start_replay”: null,
“watch_end_replay”: null,
“watch_duration_replay”: null,
“payment_to_watch_completed”: false,
“eligible_to_watch”: true,
“unsubscribed”: false,
“unsubscribed_at”: null,
“time_zone”: “Europe/Zurich”,
“created_at”: 1695220452,
“email_updated_at”: null,
“email_verified”: true,
“email_verified_at”: 1695220452,
“assessment_passed_at”: null
},
{
“id”: 23168153,
“firstname”: “Marion”,
“surname”: null,
“company”: null,
“email”: "",
“country”: null,
“street”: null,
“house_number”: null,
“postcode”: null,
“city”: null,
“province”: null,
“phone”: null,
“external_id”: “”,
“extra_fields”: {},
“consent_fields”: null,
“custom_field”: “”,
“registration_ip”: "",
“viewing_ip”: null,
“viewing_country”: null,
“viewing_device”: null,
“confirmation_link”: “”,
“watch_link”: “”,
“watched”: false,
“watch_start”: null,
“watch_end”: null,
“watch_duration”: null,
“watched_live”: false,
“watched_replay”: false,
“watched_yesterdays_replay”: false,
“watch_start_replay”: null,
“watch_end_replay”: null,
“watch_duration_replay”: null,
“payment_to_watch_completed”: false,
“eligible_to_watch”: true,
“unsubscribed”: false,
“unsubscribed_at”: null,
“time_zone”: “Europe/Zurich”,
“created_at”: 1695138703,
“email_updated_at”: null,
“email_verified”: true,
“email_verified_at”: 1695138703,
“assessment_passed_at”: null
},
{
“id”: 23147030,
“firstname”: "Renata ",
“surname”: null,
“company”: null,
“email”: "”,
“country”: null,
“street”: null,
“house_number”: null,
“postcode”: null,
“city”: null,
“province”: null,
“phone”: null,
“external_id”: “”,
“extra_fields”: {},
“consent_fields”: null,
“custom_field”: “”,
“registration_ip”: “",
“viewing_ip”: "”,
“viewing_country”: “Germany”,
“viewing_device”: “Mobile”,
“confirmation_link”: “”,
“watch_link”: “”,
“watched”: true,
“watch_start”: 1695104582,
“watch_end”: 1695115567,
“watch_duration”: 8010,
“watched_live”: false,
“watched_replay”: false,
“watched_yesterdays_replay”: false,
“watch_start_replay”: null,
“watch_end_replay”: null,
“watch_duration_replay”: null,
“payment_to_watch_completed”: false,
“eligible_to_watch”: true,
“unsubscribed”: false,
“unsubscribed_at”: null,
“time_zone”: “Europe/Berlin”,
“created_at”: 1695104576,
“email_updated_at”: null,
“email_verified”: true,
“email_verified_at”: 1695104576,
“assessment_passed_at”: null
},
],
“pages”: {
“next”: null,
“page”: 1,
“per_page”: 50,
“total_pages”: 1
}
}
]
What is the error message (if any)?
Please share your workflow
(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)
Share the output returned by the last node
Information on your n8n setup
- n8n version:
- Database (default: SQLite):
- n8n EXECUTIONS_PROCESS setting (default: own, main):
- Running n8n via (Docker, npm, n8n cloud, desktop app):
- Operating system:
