Import/update many role assignments per template task

Question

Hi Fusion Community,

I'm looking to update a large number of template tasks with job roles. All of these updates are for many roles per task.

Is this possible to do via Fusion? I haven't had success with Kickstarts and have been working with Support on it, but curious if this can be done using Fusion instead?

I set up a scenario for this as follows:

Download document module to kick things off
Parse CSV to separate out the columns/fields within my CSV file
Update record module.
- For the Record Type field, I was thinking of using the 'Assignment' object, but I can't seem to get a list of assignment ID's from template tasks - at least not from frontend reporting.
- I then thought maybe I'll use the 'Template Task' Record Type, but it only allows you to map to the 'Assigned To ID' field, which is the primary assignee. I have many assignees I need to assign to individual tasks.

Thoughts? Ideas?

Thanks!

Nick

lgaertner · Answer

Hello Nick,

I hope I did not get you wrong, but to get a list of assignments to template tasks, you can use the Search module on the endpoint TTSK and add assignments:* to the fields.

You can also go the other way round and talk to the endpoint TASSGN to get all assignments to template tasks.

To create an assignment to a template task, I use the Custom API module sending a POST request to TASSGN

with a body like this:

{
  "assignmentPercent": 0.0,
  "customerID": "<customerID>",
  "isPrimary": true,
  "isTeamAssignment": false,
  "objID": "<templateTaskID>",
  "objObjCode": "TTSK",
  "roleID": "<roleID>",
  "teamID": null,
  "templateID": "<templateID>",
  "templateTaskID": "<templateTaskID>",
  "work": 0.0,
  "workRequired": 0
}

This can be done multiple times to assign more than one role to a single template task.

Regards

Lars

Cadastre-se

Fazer o login com rede social

Bem-vindo

Fazer o login com rede social

Verificando arquivo em busca de vírus

Este arquivo não pode ser baixado