Task Dependency API (Proyects, Tasks and Subtasks)
Hello.
I'm working with API and its integration with power bi but got stuck in an issue.
With API I have 2 origins:
1. Folders: https://www.wrike.com/api/v4/folders
2. Tasks: https://www.wrike.com/api/v4/tasks
However, i don't obtain the relationship between proyects and task or Task and Subtasks, in other words, the tasks hierarchy is incomplete.
The only hierarchy i can use is the one between folders and proyects (with parent and child relationship) obtained from "Folders" API, but the proyects doesn´t have a childs reationship, so I can´t relate tasks to their respective folders or projects.
Checking the diagram (which is in this URL: https://developers.wrike.com/schema-reference/), this indicates that there are 2 tables I should be able to import, which is "Task Dependency" and "Project to task", but I can't find them.
I would like to know if any one has had the same problem.
I'll appreciate any help about it.
Regards!
Hi Esteban Alvarez, to obtain information about parent projects/folders and subtasks, I'd suggest using
GET/tasks/{taskId}method. In the response, please refer to the parameters below:parentIds- shows the list of task parent folder IDssubTaskIds- shows the list of subtask IDsAlternatively, you can perform
GET/taskscall with additional parametersfieldsset to[parentIds, subTaskIds].Hope it would work for you!As for BI export, it's available only for Enterprise accounts. Please check that you have a sufficient subscription type in order to use the feature. If needed, we will be happy to enable a trial for your team. Don't hesitate to reach out!😊
Lisa K. Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover
Lisa K. Wrike Team member Become a Wrike expert with Wrike Discover
Hi Lisa, thanks for your answer.
My subscription is Bussiness, and acording to the saler, I'm able to use API to work with BI tools.
Regarding the solution you indicate I tried before, but it doesn't work for me since is not efficient because I would have to run a query for each task created (currently I have many and will create more proyects and task every day). The objective of working with API and Bi tools is to automate processes and don´t do manual work.
Is there any method of having the parent-childs relationship of all the tasks with their respective folders and / or projects without having to perform queries one by one?
I´ll appreciate your answer
Regards
Hi Esteban Alvarez, as I have mentioned above, only Enterprise accounts can use the BI export feature, while it's not available for the Business subscription. This page describes Wrike subscription types in more detail.
BI export helps users easily pull out the parent-child relationship of Tasks and Folders and automate the manual export. To generate the CSV files, Enterprise admins with the right to “Export account data” can use the /data export API method💪 Hope it helps!
Lisa K. Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover
Lisa K. Wrike Team member Become a Wrike expert with Wrike Discover