-
Instructions to Ask a Question
For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.
We offer seven comprehensive applications designed to help you efficiently manage and grow your business:
- Pabbly Connect
- Pabbly Subscription Billing
- Pabbly Email Marketing
- Pabbly Form Builder
- Pabbly Email Verification
- Pabbly Hook
- Pabbly Chatflow
Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.
🚀 Exclusive Lifetime Offers 🚀
We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:
- 🔥 Pabbly Connect — Lifetime Access for $249 — View Offer
- 🔥 Pabbly Subscription Billing — Lifetime Access for $249 — View Offer
- 🔥 Pabbly Chatflow — Lifetime Access for $249 — View Offer
Make a one-time investment and enjoy the advantages of robust business management tools for years to come.
-
Iterator not working with Notion query DB
- Thread starter dsgadmin
- Start date
dsgadmin
Member
Pabbly Connect
also this is the json im getting from notion (if that helps -- seems to be very nested)
JSON:
[
{
"object": "page",
"id": "233b6969-e4f8-808a-8fd6-e498eb98dbc5",
"created_time": "2025-07-17T22:24:00.000Z",
"last_edited_time": "2025-07-17T22:24:00.000Z",
"created_by": {
"object": "user",
"id": "135d872b-594c-8186-90be-0002cf3b251a"
},
"last_edited_by": {
"object": "user",
"id": "135d872b-594c-8186-90be-0002cf3b251a"
},
"cover": null,
"icon": null,
"parent": {
"type": "database_id",
"database_id": "233b6969-e4f8-80a6-9a9d-c0c37947a527"
},
"archived": false,
"in_trash": false,
"properties": {
"What got done": {
"id": "HF%5DM",
"type": "multi_select",
"multi_select": [
{
"id": "c069092f-f640-46e3-bc5f-743649830a01",
"name": "Contact",
"color": "red"
},
{
"id": "ced37598-4ce6-4ac3-bb97-eb0d3160e3db",
"name": "About",
"color": "blue"
},
{
"id": "1132cfc9-d11e-4b8e-b14c-3cf8180ae8f8",
"name": "Services",
"color": "orange"
}
]
},
"Dev URL": {
"id": "M%3Ayr",
"type": "rich_text",
"rich_text": [
{
"type": "text",
"text": {
"content": "https://dreamsitegurus.com",
"link": null
},
"annotations": {
"bold": false,
"italic": false,
"strikethrough": false,
"underline": false,
"code": false,
"color": "default"
},
"plain_text": "https://dreamsitegurus.com",
"href": null
}
]
},
"Clients": {
"id": "NO%5CM",
"type": "relation",
"relation": [
{
"id": "233b6969-e4f8-8052-9207-c15b6ee5f408"
}
],
"has_more": false
},
"Formula": {
"id": "N%5C%3C%7B",
"type": "date",
"date": null
},
"Submit and send": {
"id": "%5DtA%3D",
"type": "button",
"button": {}
},
"Status": {
"id": "aoSJ",
"type": "status",
"status": {
"id": "0b29e66c-b923-4a6b-8a3e-3508b612143a",
"name": "In progress",
"color": "blue"
}
},
"Name": {
"id": "title",
"type": "title",
"title": [
{
"type": "text",
"text": {
"content": "Test project 2",
"link": null
},
"annotations": {
"bold": false,
"italic": false,
"strikethrough": false,
"underline": false,
"code": false,
"color": "default"
},
"plain_text": "Test project 2",
"href": null
}
]
}
},
"url": "https://www.notion.so/Test-project-2-233b6969e4f8808a8fd6e498eb98dbc5",
"public_url": null
},
{
"object": "page",
"id": "233b6969-e4f8-8025-988a-e3b64934141d",
"created_time": "2025-07-17T20:28:00.000Z",
"last_edited_time": "2025-07-17T22:42:00.000Z",
"created_by": {
"object": "user",
"id": "135d872b-594c-8186-90be-0002cf3b251a"
},
"last_edited_by": {
"object": "user",
"id": "135d872b-594c-8186-90be-0002cf3b251a"
},
"cover": null,
"icon": null,
"parent": {
"type": "database_id",
"database_id": "233b6969-e4f8-80a6-9a9d-c0c37947a527"
},
"archived": false,
"in_trash": false,
"properties": {
"What got done": {
"id": "HF%5DM",
"type": "multi_select",
"multi_select": [
{
"id": "f68a136e-bfd9-403d-88e0-4c60893c2d15",
"name": "Home Page",
"color": "pink"
},
{
"id": "ced37598-4ce6-4ac3-bb97-eb0d3160e3db",
"name": "About",
"color": "blue"
},
{
"id": "c069092f-f640-46e3-bc5f-743649830a01",
"name": "Contact",
"color": "red"
},
{
"id": "1132cfc9-d11e-4b8e-b14c-3cf8180ae8f8",
"name": "Services",
"color": "orange"
}
]
},
"Dev URL": {
"id": "M%3Ayr",
"type": "rich_text",
"rich_text": [
{
"type": "text",
"text": {
"content": "https://google.com",
"link": null
},
"annotations": {
"bold": false,
"italic": false,
"strikethrough": false,
"underline": false,
"code": false,
"color": "default"
},
"plain_text": "https://google.com",
"href": null
}
]
},
"Clients": {
"id": "NO%5CM",
"type": "relation",
"relation": [
{
"id": "233b6969-e4f8-8062-8718-d95adacc4bd6"
}
],
"has_more": false
},
"Formula": {
"id": "N%5C%3C%7B",
"type": "date",
"date": null
},
"Submit and send": {
"id": "%5DtA%3D",
"type": "button",
"button": {}
},
"Status": {
"id": "aoSJ",
"type": "status",
"status": {
"id": "0b29e66c-b923-4a6b-8a3e-3508b612143a",
"name": "In progress",
"color": "blue"
}
},
"Name": {
"id": "title",
"type": "title",
"title": [
{
"type": "text",
"text": {
"content": "Website Project Name",
"link": null
},
"annotations": {
"bold": false,
"italic": false,
"strikethrough": false,
"underline": false,
"code": false,
"color": "default"
},
"plain_text": "Website Project Name",
"href": null
}
]
}
},
"url": "https://www.notion.so/Website-Project-Name-233b6969e4f88025988ae3b64934141d",
"public_url": null
}
]You would need to use an Iterator to loop through the nested JSON data, which you seem to be doing. If you simply want to extract specific data from the JSON, you can use a JSON Extractor. It appears that you have both steps in your workflow.
dsgadmin
Member
sorry i dont understand what / how to get this to work -- those mulptles were to test if that would work but its not working
the json extrator is empty
