Zoho sprints work item update to Zoho Projects task through Zoho flow

Zoho sprints work item update to Zoho Projects task through Zoho flow

Hi,

In my company, we will use Zoho sprint and Zoho project in accordance, thanks to the integration between both of them on the work item (in Sprint) and the task (in Project)

But as mentioned in the comment here (https://help.zoho.com/portal/en/community/topic/sync-issues-in-zoho-sprints) the synchronization of status is not automatically made.

I am a developer and I would try to use Zoho Flow and custom function to make it possible.

But it seems that even if the task (in Project) is linked to a work item (in Sprint), I can't get the ID of the task based on a work item.

A small example with data from a Project task and the linked Sprint work item
  1. Extract of data from Sprint work item (with a flow)
  2. {
  3. "zsaction": "ITEM_UPDATE",
  4. "actionby": 1654000000049015,
  5. "ProjectId": 1654000000048039,
  6. "zoid": 20069044770,
  7. "ItemCreatorName": "Julien  GOBBI",
  8. "SprintId": 1654000000046829,
  9. "fieldsUpdated": "[STATUS_ID]",
  10. "EndDate": -1,
  11. "ItemId": 1654000000046817,
  12. "ItemDescription": "",
  13. "StartDate": -1,
  14. "Points": 0,
  15. "ItemNumber": 4,
  16. "TagObject": -1,
  17. "isdebug": true,
  18. "ReleaseObject": -1,
  19. "StatusId": 1654000000002613,
  20. "ItemName": "test",
  21. "ItemCreator": 1654000000024019
  22. }

  1. Extract of data from Project task (with webhook)
  2. {
  3. "project":"63583000000528099",
  4. "milestone":"None",
  5. "tasklist":"63583000000525021",
  6. "taskstatus":"On going",
  7. "taskid":"63583000000527009",
  8. "tasknumber":"A4Q3-T4"
  9. }

Does anyone know about the possibility to get the project id and the task id of a Project task in Flow, based on data from Sprint work item?