How to split data from JSON?

Questions
, ,
1

I want to separate the meeting room information.

myoutput

[
{
“response”: {
“returncode”: “SUCCESS”,
“meetings”: {
“meeting”: [
{
“meetingName”: “Home Room”,
“meetingID”: “ipjtxxlmof4yskpzvllxwikuhpndqnqa2mivzuvq”,
“internalMeetingID”: “869812d554c087cff1ffaa5c9fd8140822017b77-1690428276079”,
“createTime”: “1690428276079”,
“createDate”: “Thu Jul 27 03:24:36 UTC 2023”,
“voiceBridge”: “46476”,
“dialNumber”: “613-555-1234”,
“attendeePW”: “KGILoZQHdNSJ”,
“moderatorPW”: “pmELpJOOQNUT”,
“running”: “true”,
“duration”: “0”,
“hasUserJoined”: “true”,
“recording”: “true”,
“hasBeenForciblyEnded”: “false”,
“startTime”: “1690428276092”,
“endTime”: “0”,
“participantCount”: “3”,
“listenerCount”: “0”,
“voiceParticipantCount”: “0”,
“videoCount”: “0”,
“maxUsers”: “0”,
“moderatorCount”: “2”,
“attendees”: {
“attendee”: [
{
“userID”: “gl-ggfwhoqqfvfo”,
“fullName”: “Natcha Damkerngsuntorn”,
“role”: “MODERATOR”,
“isPresenter”: “false”,
“isListeningOnly”: “false”,
“hasJoinedVoice”: “false”,
“hasVideo”: “false”,
“clientType”: “HTML5”
},
{
“userID”: “gl-guest-bfa914476ebcb295a8e92491”,
“fullName”: “Boss”,
“role”: “VIEWER”,
“isPresenter”: “true”,
“isListeningOnly”: “false”,
“hasJoinedVoice”: “false”,
“hasVideo”: “false”,
“clientType”: “HTML5”
},
{
“userID”: “gl-kxfspoaizqsk”,
“fullName”: “Prapaporn Operator”,
“role”: “MODERATOR”,
“isPresenter”: “false”,
“isListeningOnly”: “false”,
“hasJoinedVoice”: “false”,
“hasVideo”: “false”,
“clientType”: “HTML5”
}
]
},
“metadata”: {
“bbb-origin-version”: “release-2.14.8.1”,
“bbb-origin-server-name”: “go.quest.ac”,
“bbb-origin”: “Greenlight”,
“gl-listed”: “true”
},
“isBreakout”: “false”
},
{
“meetingName”: “Home Room”,
“meetingID”: “k5hjimjjvn79flg6gjjweyubu80gpyqywmnnwfag”,
“internalMeetingID”: “6e023214d01ff892b8cbb469dbcf5ae5da8c4d58-1690430721632”,
“createTime”: “1690430721632”,
“createDate”: “Thu Jul 27 04:05:21 UTC 2023”,
“voiceBridge”: “10516”,
“dialNumber”: “613-555-1234”,
“attendeePW”: “WrrRIbrGXiJx”,
“moderatorPW”: “DlwCTsHpGFIx”,
“running”: “true”,
“duration”: “0”,
“hasUserJoined”: “true”,
“recording”: “true”,
“hasBeenForciblyEnded”: “false”,
“startTime”: “1690430721648”,
“endTime”: “0”,
“participantCount”: “3”,
“listenerCount”: “0”,
“voiceParticipantCount”: “0”,
“videoCount”: “0”,
“maxUsers”: “0”,
“moderatorCount”: “2”,
“attendees”: {
“attendee”: [
{
“userID”: “gl-kxfspoaizqsk”,
“fullName”: “Prapaporn Operator”,
“role”: “MODERATOR”,
“isPresenter”: “false”,
“isListeningOnly”: “false”,
“hasJoinedVoice”: “false”,
“hasVideo”: “false”,
“clientType”: “HTML5”
},
{
“userID”: “gl-ggfwhoqqfvfo”,
“fullName”: “Natcha Damkerngsuntorn”,
“role”: “MODERATOR”,
“isPresenter”: “false”,
“isListeningOnly”: “false”,
“hasJoinedVoice”: “false”,
“hasVideo”: “false”,
“clientType”: “HTML5”
},
{
“userID”: “gl-guest-bfe82562ded02565599d0191”,
“fullName”: “Nut”,
“role”: “VIEWER”,
“isPresenter”: “true”,
“isListeningOnly”: “false”,
“hasJoinedVoice”: “false”,
“hasVideo”: “false”,
“clientType”: “HTML5”
}
]
},
“metadata”: {
“bbb-origin-version”: “release-2.14.8.1”,
“bbb-origin-server-name”: “go.quest.ac”,
“bbb-origin”: “Greenlight”,
“gl-listed”: “true”
},
“isBreakout”: “false”
},
{
“meetingName”: “Home Room”,
“meetingID”: “biz8ikgu3tbdej8ydgwmdlrn87cvddugzkwqgxgj”,
“internalMeetingID”: “90a7dc7a8c5f343b2ebf8cc88e2197bf3e2c487a-1690437262604”,
“createTime”: “1690437262604”,
“createDate”: “Thu Jul 27 05:54:22 UTC 2023”,
“voiceBridge”: “76797”,
“dialNumber”: “613-555-1234”,
“attendeePW”: “PAmaVYvSEVyc”,
“moderatorPW”: “rRAVIExlKBlO”,
“running”: “true”,
“duration”: “0”,
“hasUserJoined”: “true”,
“recording”: “true”,
“hasBeenForciblyEnded”: “false”,
“startTime”: “1690437262612”,
“endTime”: “0”,
“participantCount”: “1”,
“listenerCount”: “0”,
“voiceParticipantCount”: “0”,
“videoCount”: “0”,
“maxUsers”: “0”,
“moderatorCount”: “1”,
“attendees”: {
“attendee”: {
“userID”: “gl-wufbuatdkzhn”,
“fullName”: “Sun Quest”,
“role”: “MODERATOR”,
“isPresenter”: “true”,
“isListeningOnly”: “false”,
“hasJoinedVoice”: “false”,
“hasVideo”: “false”,
“clientType”: “HTML5”
}
},
“metadata”: {
“bbb-origin-version”: “release-2.14.8.1”,
“bbb-origin-server-name”: “go.quest.ac”,
“bbb-origin”: “Greenlight”,
“gl-listed”: “true”
},
“isBreakout”: “false”
},
{
“meetingName”: “Home Room”,
“meetingID”: “iw9xjtovkqyyisiqgs79nf9wfaqzuxsyx8uaqdiz”,
“internalMeetingID”: “465ea33c69b6f56ba8c74a25e7f844355c332188-1690441020655”,
“createTime”: “1690441020655”,
“createDate”: “Thu Jul 27 06:57:00 UTC 2023”,
“voiceBridge”: “10553”,
“dialNumber”: “613-555-1234”,
“attendeePW”: “jUvLayDPlHvq”,
“moderatorPW”: “aQTkADoDwoIY”,
“running”: “true”,
“duration”: “0”,
“hasUserJoined”: “true”,
“recording”: “true”,
“hasBeenForciblyEnded”: “false”,
“startTime”: “1690441020665”,
“endTime”: “0”,
“participantCount”: “3”,
“listenerCount”: “0”,
“voiceParticipantCount”: “2”,
“videoCount”: “2”,
“maxUsers”: “0”,
“moderatorCount”: “1”,
“attendees”: {
“attendee”: [
{
“userID”: “gl-codswzsivtnj”,
“fullName”: “P Quest”,
“role”: “MODERATOR”,
“isPresenter”: “false”,
“isListeningOnly”: “false”,
“hasJoinedVoice”: “false”,
“hasVideo”: “false”,
“clientType”: “HTML5”
},
{
“userID”: “gl-guest-3313955ffe71e77f674f2bda”,
“fullName”: “PP”,
“role”: “VIEWER”,
“isPresenter”: “false”,
“isListeningOnly”: “false”,
“hasJoinedVoice”: “true”,
“hasVideo”: “true”,
“clientType”: “HTML5”
},
{
“userID”: “gl-guest-13c651d35befd671488d39c9”,
“fullName”: “Earth”,
“role”: “VIEWER”,
“isPresenter”: “true”,
“isListeningOnly”: “false”,
“hasJoinedVoice”: “true”,
“hasVideo”: “true”,
“clientType”: “HTML5”
}
]
},
“metadata”: {
“bbb-origin-version”: “release-2.14.8.1”,
“bbb-origin-server-name”: “go.quest.ac”,
“bbb-origin”: “Greenlight”,
“gl-listed”: “true”
},
“isBreakout”: “false”
},
{
“meetingName”: “Home Room”,
“meetingID”: “wq7ihwps9octf1pzfbevvgjbjf1kbwppbtwbqn1m”,
“internalMeetingID”: “c5b2ac9a452879faf32e6d5eae1d4f879dc4b78e-1690428295719”,
“createTime”: “1690428295719”,
“createDate”: “Thu Jul 27 03:24:55 UTC 2023”,
“voiceBridge”: “76083”,
“dialNumber”: “613-555-1234”,
“attendeePW”: “sEyPFpMPqNSB”,
“moderatorPW”: “oTTrkLbIRMdz”,
“running”: “true”,
“duration”: “0”,
“hasUserJoined”: “true”,
“recording”: “true”,
“hasBeenForciblyEnded”: “false”,
“startTime”: “1690428295729”,
“endTime”: “0”,
“participantCount”: “3”,
“listenerCount”: “0”,
“voiceParticipantCount”: “0”,
“videoCount”: “0”,
“maxUsers”: “0”,
“moderatorCount”: “2”,
“attendees”: {
“attendee”: [
{
“userID”: “gl-ggfwhoqqfvfo”,
“fullName”: “Natcha Damkerngsuntorn”,
“role”: “MODERATOR”,
“isPresenter”: “false”,
“isListeningOnly”: “false”,
“hasJoinedVoice”: “false”,
“hasVideo”: “false”,
“clientType”: “HTML5”
},
{
“userID”: “gl-kxfspoaizqsk”,
“fullName”: “Prapaporn Operator”,
“role”: “MODERATOR”,
“isPresenter”: “false”,
“isListeningOnly”: “false”,
“hasJoinedVoice”: “false”,
“hasVideo”: “false”,
“clientType”: “HTML5”
},
{
“userID”: “gl-guest-2e92e52f0e692482ad9e4818”,
“fullName”: “เรียล”,
“role”: “VIEWER”,
“isPresenter”: “true”,
“isListeningOnly”: “false”,
“hasJoinedVoice”: “false”,
“hasVideo”: “false”,
“clientType”: “HTML5”
}
]
},
“metadata”: {
“bbb-origin-version”: “release-2.14.8.1”,
“bbb-origin-server-name”: “go.quest.ac”,
“bbb-origin”: “Greenlight”,
“gl-listed”: “true”
},
“isBreakout”: “false”
},
{
“meetingName”: “Home Room”,
“meetingID”: “uwe8zajffyzbuzcsyn26mixglwlp9snnfiujgydh”,
“internalMeetingID”: “3b19d7db736be00099f3cf8a65b69ba93819f707-1690428252546”,
“createTime”: “1690428252546”,
“createDate”: “Thu Jul 27 03:24:12 UTC 2023”,
“voiceBridge”: “30149”,
“dialNumber”: “613-555-1234”,
“attendeePW”: “ZEMNZpTvvwny”,
“moderatorPW”: “jyvRhPNBWsOq”,
“running”: “true”,
“duration”: “0”,
“hasUserJoined”: “true”,
“recording”: “true”,
“hasBeenForciblyEnded”: “false”,
“startTime”: “1690428252596”,
“endTime”: “0”,
“participantCount”: “2”,
“listenerCount”: “0”,
“voiceParticipantCount”: “0”,
“videoCount”: “0”,
“maxUsers”: “0”,
“moderatorCount”: “2”,
“attendees”: {
“attendee”: [
{
“userID”: “gl-pexzyiszpsnj”,
“fullName”: “Jeep Quest”,
“role”: “MODERATOR”,
“isPresenter”: “true”,
“isListeningOnly”: “false”,
“hasJoinedVoice”: “false”,
“hasVideo”: “false”,
“clientType”: “HTML5”
},
{
“userID”: “gl-kxfspoaizqsk”,
“fullName”: “Prapaporn Operator”,
“role”: “MODERATOR”,
“isPresenter”: “true”,
“isListeningOnly”: “false”,
“hasJoinedVoice”: “false”,
“hasVideo”: “false”,
“clientType”: “HTML5”
}
]
},
“metadata”: {
“bbb-origin-version”: “release-2.14.8.1”,
“bbb-origin-server-name”: “go.quest.ac”,
“bbb-origin”: “Greenlight”,
“gl-listed”: “true”
},
“isBreakout”: “false”
},
{
“meetingName”: “Home Room”,
“meetingID”: “goaamnfg1uvvnj628wszrhxg0av2ouls5jbpjtwc”,
“internalMeetingID”: “76478a569f01d7699780c4f623cabfc04fee1b18-1690428354692”,
“createTime”: “1690428354692”,
“createDate”: “Thu Jul 27 03:25:54 UTC 2023”,
“voiceBridge”: “30171”,
“dialNumber”: “613-555-1234”,
“attendeePW”: “ooBMGythNaZw”,
“moderatorPW”: “sEAgzjtYazWE”,
“running”: “true”,
“duration”: “0”,
“hasUserJoined”: “true”,
“recording”: “true”,
“hasBeenForciblyEnded”: “false”,
“startTime”: “1690428354704”,
“endTime”: “0”,
“participantCount”: “3”,
“listenerCount”: “0”,
“voiceParticipantCount”: “0”,
“videoCount”: “0”,
“maxUsers”: “0”,
“moderatorCount”: “2”,
“attendees”: {
“attendee”: [
{
“userID”: “gl-guest-4fe04a9ff8c3be37bc13d4ce”,
“fullName”: “T”,
“role”: “VIEWER”,
“isPresenter”: “true”,
“isListeningOnly”: “false”,
“hasJoinedVoice”: “false”,
“hasVideo”: “false”,
“clientType”: “HTML5”
},
{
“userID”: “gl-kxfspoaizqsk”,
“fullName”: “Prapaporn Operator”,
“role”: “MODERATOR”,
“isPresenter”: “false”,
“isListeningOnly”: “false”,
“hasJoinedVoice”: “false”,
“hasVideo”: “false”,
“clientType”: “HTML5”
},
{
“userID”: “gl-ggfwhoqqfvfo”,
“fullName”: “Natcha Damkerngsuntorn”,
“role”: “MODERATOR”,
“isPresenter”: “false”,
“isListeningOnly”: “false”,
“hasJoinedVoice”: “false”,
“hasVideo”: “false”,
“clientType”: “HTML5”
}
]
},
“metadata”: {
“bbb-origin-version”: “release-2.14.8.1”,
“bbb-origin-server-name”: “go.quest.ac”,
“bbb-origin”: “Greenlight”,
“gl-listed”: “true”
},
“isBreakout”: “false”
}
]
}
}
}
]

4

Hi @Panupol_Sonnuam, are you trying to split your data into one n8n item per meeting? This could be done using the Item Lists node like so:

5

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