We are working on building out Wrike reporting for our team in PowerBI. We have been able to have success in pulling project information for our request system, but are getting stuck in reporting information out from our recurring reports.
We would like to show our recurring report projects and highlight when the next recurring task is due. Only problem is that we cannot tie any ID field in the GET API call for tasks to a project. We can tie it to a folder, but not to the correct project. Is there any way to do this or something we are missing? It doesn't make sense if the overall hierarchy of Wrike is/was task --> project --> folder --> space that there is no way to see what project a task is a part of.
We have tried to download the work_project_to_task BI Export and use this, but the IDs from this API functionality are different than what comes back from GET calls.
Any help is appreciated!