Hi Fivetran Team,

Current RELTIO connector does not include workflow data as per Fivetran ERD (https://docs.google.com/presentation/d/1IaEORESqg3jeJlRK7sYj3dts2kd9KJudUJrR0bq0HLw/edit#slide=id.g27365556477_0_164)

We need this Workflow data on high priority. And below are the RELTIO Api details where it can be fetched from.

Open change requests API:

https://{{env}}-workflowui.reltio.com/services/workflow/{{mdmTenant}}/tasks

input payload:

{

    "ascending": false,

    "orderBy": "assignee",

    "open": true,

    /* "variables": [

        {

            "entityType": "Accounts"

        }

    ],

    "objectURIs": [

        "entities/{entity_id}"

    ],*/

    "processTypes": [

        "acrWithNotifications"

    ],

    "showTaskVariables": true,

    "offset": 0

}

Historical workflow details:

https://{{env}}-workflowui.reltio.com/services/workflow/{{mdmTenant}}/tasks/history

input payload:

{

    "ascending": false,

    "orderBy": "createTime",

    "open": false,

    "completed": true,

    "variables": [

        {

            "entityType": "Accounts"

        }

    ],

    "processTypes": [

        "acrWithNotifications"

    ],

    "showTaskVariables": true,

    "offset": 0,

    "max": 25

}

first API gives the open tasks and second one gives closed ones.

Regards,

Srikar