Array to Table from API Response

Dashboard
1

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:

{"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,

2

Both dashboard 1 & 2 have a contrib table nodes that can use Tabulator functions, dashboard 2 contrib node runs the newest tabular version, while dashboard 1 contrib node is about V4.7. Both can paginate the input array. Or you can use Tabulator direct in the template nodes of each dashboard

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