How to List All ClickUp Spaces and Their Lists (Including Lists Inside and Outside Folders)?

How To
,
1

Hello, I’m building a Make.com scenario to fetch and structure all my ClickUp data in this hierarchy:

  1. Spaces
  • Contain Folders
    • Each Folder contains Lists
  • Some Lists may exist directly under the Space, not inside a Folder

I’d like to generate a structured output like this:

Space: [Space Name] (ID: xxx)
Folder: [Folder Name] (ID: yyy)
- List: [List Name] (ID: zzz)
- List: [List Name] (ID: zzz)
Lists without Folder:
- List: [List Name] (ID: zzz)
- List: [List Name] (ID: zzz)

It might be too complicated, but the one thing I want right now is to know how the data should be displayed or modules be structured when using the List All Spaces module along with the other “List” modules in between in order to bring all the “Space”, “Folder”, and “List” data into the final JSON module.

The problem I’m facing right now is that data from a previous module can only be retrieved if it’s directly before the current module, but not if there are other modules in between.

image
image1760×652 67.7 KB

Is there a better way to do this? Please advise.

2

Hey there,

your aggregation logic is wrong. The List all folderless lists at the moment will run as many times as there are lists. Also you don’t need the array aggregator at all and you need to set the source of the Aggregate to JSON to be the list all spaces module.

I suggest list spaces first, then folders, then lists, then aggregate the results, then separate from that list spaces and lists folderless lists, then aggregate that one to JSON as well and combine the two JSONs in the structure you need.