Is there an API that retrieves all open Tasks for the user?

Jonathan Amiran · 2025-07-03T16:05:15+00:00

There was an error rendering this rich post.

Hi,

I'm looking for an API in Infor CloudSuite that can retrieve all open tasks assigned to the currently logged-in user - similar to what’s shown in the Inbox or Task widget in the portal.

I’m aware of:

/IONSERVICES/process/user/v1/task/{id} (but this requires a specific task ID)
/IONSERVICES/process/user/v1/workflow/{workflow}/tasks (but this requires the workflow ID and MANAGE permissions)

What I’m looking for is a way to programmatically retrieve the entire task list for the user, ideally with filters for status (e.g., open/active).

Is there a documented endpoint for that?

Can this data be retrieved using DataLake?

Thanks,

Jonathan

Find more posts tagged with

ION Connect

ION Workflow

ION API Gateway

API Usage

Accepted answers

Kiran Kolluri

Hi @Jonathan Amiran ,

If we enable the ION settings, then there may be a chance to retreive the data from Data Fabric.

Screenshot 2025-07-11 095125.png

All comments

Kiran Kolluri

Hi @Jonathan Amiran ,

If we enable the ION settings, then there may be a chance to retreive the data from Data Fabric.

Screenshot 2025-07-11 095125.png

Jonathan Amiran

Hi @Kiran Kolluri ,

Thanks! I was able to create a Data Fabric query that retrieves open tasks for {userGuid}:

SELECT

task."eventTimeStamp" AS taskEventTime,

task."id" AS taskId,

task."eventType" AS taskEventType,

wf_latest."eventType" AS latestWorkflowStatus,

wf_latest."eventTimeStamp" AS workflowStatusTime,

wf_latest."instanceName",

wf_latest."name",

wf_latest."sourceInfo"

FROM "ION_PulseTaskEvent" AS task

JOIN (

SELECT *

FROM (

SELECT *,

ROW_NUMBER() OVER (PARTITION BY "id" ORDER BY "eventTimeStamp" DESC) AS rn

FROM "ION_WorkflowEvent"

) wf

WHERE wf.rn = 1

) AS wf_latest ON wf_latest."id" = task."sourceId"

WHERE

task."distributionUsers" = '{userGuid}'

AND task."source" = 'Workflow'

AND wf_latest."eventType" = 'Started'

ORDER BY

task."eventTimeStamp" DESC;

However, I'm not sure about the timing of the Data Archiving process. Sometimes it takes over an hour for the Data Fabric to refresh.

Thanks 😀

Jonathan

Jonathan Amiran

Hi @Kiran Kolluri ,

Thanks! I was able to create a Data Fabric query that retrieves open tasks for {userGuid}:

SELECT

task."eventTimeStamp" AS taskEventTime,

task."id" AS taskId,

task."eventType" AS taskEventType,

wf_latest."eventType" AS latestWorkflowStatus,

wf_latest."eventTimeStamp" AS workflowStatusTime,

wf_latest."instanceName",

wf_latest."name",

wf_latest."sourceInfo"

FROM "ION_PulseTaskEvent" AS task

JOIN (

SELECT *

FROM (

SELECT *,

ROW_NUMBER() OVER (PARTITION BY "id" ORDER BY "eventTimeStamp" DESC) AS rn

FROM "ION_WorkflowEvent"

) wf

WHERE wf.rn = 1

) AS wf_latest ON wf_latest."id" = task."sourceId"

WHERE

task."distributionUsers" = '{userGuid}'

AND task."source" = 'Workflow'

AND wf_latest."eventType" = 'Started'

ORDER BY

task."eventTimeStamp" DESC;



Thanks 😀
Jonathan

Jonathan Amiran

Hi @Kiran Kolluri ,

Thanks! I was able to create a Data Fabric query that retrieves open tasks for {userGuid}:

SELECT

task."eventTimeStamp" AS taskEventTime,

task."id" AS taskId,

task."eventType" AS taskEventType,

wf_latest."eventType" AS latestWorkflowStatus,

wf_latest."eventTimeStamp" AS workflowStatusTime,

wf_latest."instanceName",

wf_latest."name",

wf_latest."sourceInfo"

FROM "ION_PulseTaskEvent" AS task

JOIN (

SELECT *

FROM (

SELECT *,

ROW_NUMBER() OVER (PARTITION BY "id" ORDER BY "eventTimeStamp" DESC) AS rn

FROM "ION_WorkflowEvent"

) wf

WHERE wf.rn = 1

) AS wf_latest ON wf_latest."id" = task."sourceId"

WHERE

task."distributionUsers" = '{userGuid}'

AND task."source" = 'Workflow'

AND wf_latest."eventType" = 'Started'

ORDER BY

task."eventTimeStamp" DESC;



Thanks 😀
Jonathan

Copyright © 2025 Infor. All rights reserved.