nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Efficient way to get task count per project via API

Stephen Remillard

Hello,

We’ve integrated Wrike with our ERP system via the API, and overall it’s working well. However, we occasionally run into synchronization issues, and I’ve been asked to build a “difference report” between both systems.

For projects, this was straightforward (~600 total). I can easily compare presence and identify mismatches between the two systems.

Where I’m struggling is with tasks.

At this stage, I don’t need a detailed comparison of individual tasks. A simple task count per project is sufficient to identify discrepancies.

Current approach

Right now, I’m calling the Tasks API for each project:

let url = `${WRIKE_URL}/folders/${project.wrike_project_id}/tasks?descendants=true`;

We have ~600 projects with an average of ~30 tasks each, so while the total volume isn’t huge, this still results in ~600 API calls (one per project), which:

Risks hitting rate limits
Requires throttling with artificial delays
Causes my n8n workflow to sometimes timeout

My question

Is there a more efficient or “smarter” way to retrieve the task count per project/folder?

For example:

A way to get counts without retrieving full task lists?
A bulk or aggregated endpoint?
Any best practices to reduce the number of API calls in this scenario?

I’d really appreciate any suggestions or patterns others have used in similar integrations.

Thanks in advance!

Stephen..

Find more posts tagged with

tasks

automation

api

best-practices

Comments

Sven Passinger

Hi @Stephen Remillard, I do not know any such function in the API that would help you. Perhaps it would be better to use the Data / BI Export functionality of Wrike? There you can export the whole account. It is no live like the API but it will redcue call drastically to one.

Stephen Remillard

Thank you for your answer Sven,

I wasn’t aware of the Data / BI Export functionality in Wrike, so that’s definitely a great lead.

I took a quick look at the /data_export API and the associated data model, and my first impression was… “oh boy” 😅 — the level of normalization is quite something! It looks powerful, but it will take me some time to fully understand how to extract the specific information I need (especially task counts per project).

What I’m ultimately trying to build is something along the lines of:

project_id, project_name, task_count

Or alternatively:

project_id, project_name, task_id, task_name
(from which I could derive the counts on my side)

I may try leveraging an A.I. assistant to help explore the schema more efficiently.

In the meantime, I’ll adjust the timeout settings in my n8n workflow to keep things moving with my current approach.

Thanks again for pointing me in this direction — much appreciated!

If anyone has worked with the export model and can suggest the simplest way (i.e., minimal number of joins) to retrieve this kind of dataset, I’d be very interested.