HTTP Pagination with json body parameters

Describe the problem/error/question

I’m having issues successfully paginating as it only returns the first result.

What is the error message (if any)?

Please share your workflow

returned:
[
{
“body”: {
“data”: [
{
“id”: “67b0611da29431f27cb11843”,
“thumbnail”: null,
“sku”: “VORG9964495”,
“attributes”: {
“brand_name”: “WD-40”,
“cost_per_item”: 7.14,
“inventory_management”: “shopify”,
“model_number”: “120107”,
“pro_benchmark_retail”: 8.39,
“shelf_pack”: “FALSE”,
“shelf_pack_quantity”: “1”,
“suggested_retail”: 9.65,
“variant_inventory_policy”: “deny”,
“variant_weight_unit”: “lb”,
“warehousename”: “Orgill Ecommerce”,
“weight”: 6.04
},
“num_variations”: 0,
“product_family_id”: null,
“product_family_model_id”: null,
“modified”: “2025-02-17T13:27:10.298000+00:00”,
“modified_user_audit”: {
“type”: “SYSTEM”,
“user_email”: “System”,
“user_name”: “System”
},
“created_user_audit”: {
“type”: “SYSTEM”,
“user_email”: “System”,
“user_name”: “System”
},
“overwritten_attributes”: ,
“categories”:
}
],
“pagination”: {
“count”: 172864,
“order”: null,
“page”: 1,
“page_size”: 1,
“total_count”: 288821
}
},
“headers”: {
“date”: “Mon, 17 Feb 2025 15:27:27 GMT”,
“content-type”: “application/json”,
“content-length”: “821”,
“connection”: “close”,
“server”: “uvicorn”,
“x-request-id”: “9a5cc762-f925-45f7-a4e5-38b39e04d7e6”,
“access-control-allow-origin”: “"
},
“statusCode”: 200,
“statusMessage”: “OK”
},
{
“body”: {
“data”: [
{
“id”: “67b0611da29431f27cb11843”,
“thumbnail”: null,
“sku”: “VORG9964495”,
“attributes”: {
“brand_name”: “WD-40”,
“cost_per_item”: 7.14,
“inventory_management”: “shopify”,
“model_number”: “120107”,
“pro_benchmark_retail”: 8.39,
“shelf_pack”: “FALSE”,
“shelf_pack_quantity”: “1”,
“suggested_retail”: 9.65,
“variant_inventory_policy”: “deny”,
“variant_weight_unit”: “lb”,
“warehousename”: “Orgill Ecommerce”,
“weight”: 6.04
},
“num_variations”: 0,
“product_family_id”: null,
“product_family_model_id”: null,
“modified”: “2025-02-17T13:27:10.298000+00:00”,
“modified_user_audit”: {
“type”: “SYSTEM”,
“user_email”: “System”,
“user_name”: “System”
},
“created_user_audit”: {
“type”: “SYSTEM”,
“user_email”: “System”,
“user_name”: “System”
},
“overwritten_attributes”: [],
“categories”: []
}
],
“pagination”: {
“count”: 172864,
“order”: null,
“page”: 1,
“page_size”: 1,
“total_count”: 288821
}
},
“headers”: {
“date”: “Mon, 17 Feb 2025 15:27:28 GMT”,
“content-type”: “application/json”,
“content-length”: “821”,
“connection”: “close”,
“server”: “uvicorn”,
“x-request-id”: “49457817-4997-452b-b91f-e18ad65d693f”,
“access-control-allow-origin”: "

},
“statusCode”: 200,
“statusMessage”: “OK”
}
]

Information on your n8n setup

  • **n8n version:1.78.0
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • **Running n8n via (Docker, npm, n8n cloud, desktop app):Cloud
  • **Operating system:Windows

You have to use $response to get data from the output.
Otherwise you end up referencing previous input data.

See documentation here

If my reply answers your question, please remember to mark it as the solution.

Hey @Shadner_Joseph were you able to solve this?

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