Iterator not working with Notion query DB
Status: Open · Asked by dsgadmin on · 0 views
trying to use iterator after doing a db query in notion but its not splitting up the field data. how do i get this to be accessible?
Hi @dsgadmin,
Could you please share the Workflow URL where you have this concern?
Hi @dsgadmin,Could you please share the Workflow URL where you have this concern?
https://connect.pabbly.com/v2/app/workflow/share/WxNTYQBXAmFSGABqBFtUc1hMBQEIUQhpBx5VR11SUipbFVIpVBVcNg1BVHZUEwVkVh8GbAZaVG0LHwEFUAYFdlFIU0EGBVwmA05TKAJbDD9bBVN7AGE#
also this is the json im getting from notion (if that helps -- seems to be very nested)
[
{
"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.
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.
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
You do have data in the JSON Extractor action step. You can directly map this data to the Google Docs action step. However, it cannot be mapped to the Iterator step. Only the nested JSON you’re receiving in Iterator 1 can be mapped in Iterator 2.