# Array to Table from API Response

**URL:** <https://discourse.nodered.org/t/array-to-table-from-api-response/95951>\
**Category:** Dashboard\
**Created:** [12 March 2025 16:27 UTC](https://discourse.nodered.org/t/array-to-table-from-api-response/95951 "2025-03-12T16:27:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![joshwilliams](https://avatars.discourse-cdn.com/v4/letter/j/bb73d2/32.png) [@joshwilliams](https://discourse.nodered.org/u/joshwilliams)\
**Post date:** [12 March 2025 16:27 UTC](https://discourse.nodered.org/t/array-to-table-from-api-response/95951/1 "2025-03-12T16:27:11Z")

</div>

Hi there,

I'm trying to make something that can loop through multiple pages of this API response and display it into a table. Here's an example of the data returned:

```auto
{"activities":[{"id":9109,"subject":"Test Activity","description":"","location":"","regarding_id":null,"regarding_type":"","owned_by":560,"starts_at":"2025-03-11T14:05:00.000Z","ends_at":"2025-03-11T14:05:00.000Z","priority":0,"type_id":1001,"activity_type_name":"Call","status_id":2001,"activity_status_name":"Scheduled","completed":false,"time_status":1,"time_status_name":"Busy","pinned?":false,"opportunity_item_asset_id":null,"created_at":"2025-03-11T14:04:30.982Z","updated_at":"2025-03-11T14:04:30.982Z","custom_fields":{},"regarding":null,"owner":{"id":560,"uuid":"2c1f81f0-df63-013a-3819-0a907833e252","name":"Josh Williams","description":"","active":true,"bookable":true,"location_type":0,"locale":"en-GB","day_cost":"0.0","hour_cost":"0.0","distance_cost":"0.0","flat_rate_cost":"0.0","membership_id":6,"membership_type":"User","lawful_basis_type_id":11005,"lawful_basis_type_name":"Employee","sale_tax_class_id":null,"sale_tax_class_name":null,"purchase_tax_class_id":null,"purchase_tax_class_name":null,"tag_list":[],"custom_fields":{},"icon_exists?":false,"mapping_id":null,"created_at":"2022-07-06T14:09:29.338Z","updated_at":"2023-08-10T12:19:45.307Z"},"opportunity_item_asset":null,"participants":[{"id":12226,"uuid":"ad3da470-e0af-013d-8663-16fcca30152d","assignment_id":9109,"assignment_type":"Activity","member_id":560,"member_name":"Josh Williams","member_email":"josh@sxxxxxxxxx.co.uk","mute":false,"created_at":"2025-03-11T14:04:30.990Z","updated_at":"2025-03-11T14:04:30.990Z"}]},{"id":9111,"subject":"Test Activity 2","description":"","location":"","regarding_id":null,"regarding_type":"","owned_by":560,"starts_at":"2025-03-11T14:05:00.000Z","ends_at":"2025-03-11T14:05:00.000Z","priority":0,"type_id":1001,"activity_type_name":"Call","status_id":2001,"activity_status_name":"Scheduled","completed":false,"time_status":1,"time_status_name":"Busy","pinned?":false,"opportunity_item_asset_id":null,"created_at":"2025-03-12T16:22:27.415Z","updated_at":"2025-03-12T16:22:30.375Z","custom_fields":{},"regarding":null,"owner":{"id":560,"uuid":"2c1f81f0-df63-013a-3819-0a907833e252","name":"Josh Williams","description":"","active":true,"bookable":true,"location_type":0,"locale":"en-GB","day_cost":"0.0","hour_cost":"0.0","distance_cost":"0.0","flat_rate_cost":"0.0","membership_id":6,"membership_type":"User","lawful_basis_type_id":11005,"lawful_basis_type_name":"Employee","sale_tax_class_id":null,"sale_tax_class_name":null,"purchase_tax_class_id":null,"purchase_tax_class_name":null,"tag_list":[],"custom_fields":{},"icon_exists?":false,"mapping_id":null,"created_at":"2022-07-06T14:09:29.338Z","updated_at":"2023-08-10T12:19:45.307Z"},"opportunity_item_asset":null,"participants":[{"id":12231,"uuid":"1ccb7540-e18c-013d-8d9e-16fcca30152d","assignment_id":9111,"assignment_type":"Activity","member_id":560,"member_name":"Josh Williams","member_email":"josh@sxxxxxxon.co.uk","mute":false,"created_at":"2025-03-12T16:22:27.422Z","updated_at":"2025-03-12T16:22:27.422Z"}]}],"meta":{"total_row_count":2,"row_count":2,"page":1,"per_page":20}}

```

Of course, I only intend to show certain fields in the table.

Many thanks,

---

<div class="post-metadata">

**Author:** ![E1cid](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/e1cid/32/77971_2.png) [@E1cid](https://discourse.nodered.org/u/E1cid)\
**Post date:** [13 March 2025 10:33 UTC](https://discourse.nodered.org/t/array-to-table-from-api-response/95951/2 "2025-03-13T10:33:17Z")

</div>

Both dashboard 1 & 2 have a contrib table nodes that can use Tabulator functions, [dashboard 2 contrib node](https://flows.nodered.org/node/@omrid01/node-red-dashboard-2-table-tabulator) runs the newest tabular version, while [dashboard 1 contrib node](https://flows.nodered.org/node/node-red-node-ui-table) is about V4.7. Both can paginate the input array. Or you can use [Tabulator](https://www.tabulator.info/) direct in the template nodes of each dashboard

There are a variety of examples for each on the forum.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [12 April 2025 10:33 UTC](https://discourse.nodered.org/t/array-to-table-from-api-response/95951/3 "2025-04-12T10:33:33Z")

</div>

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