DOORSNEXTGEN is it possible to export with Publishing Engine PUB the roles assigned to users in DNG/RM project area

Hi all
I'm creating a PUB report that lists the electronic signatures of the selected baseline in DNG.
Getting the users who signed is easy, but the cusomer also wants the role related to the user in the project area.
Is there a way to achive this with PUB?
In general is it possible to get the team members in a DNG project area?
Thanks in advance
Luca
Accepted answer

There's no official published end point for this, but you can retrieve the data and manually define a data source.
You can retrieve the list of users and their roles for a project area using the following URL, and teams within a project area are similar:
https://<server>/<rm, ccm or qm>/process/project-areas/<project ID>/members
If you try this with your own server you'll see the format of the XML and you'll then need to define a schema that you can use for your data source in PUB. It's pretty simple, with the basic format being:
<?xml version="1.0" encoding="UTF-8"?>
<jp06:members xmlns:jp06="http://jazz.net/xmlns/prod/jazz/process/0.6/" xmlns:jp="http://jazz.net/xmlns/prod/jazz/process/1.0/" jp:total-members="261">
<jp06:member>
<jp06:url> internal user ID url </jp06:url>
<jp06:user-url> external user ID url </jp06:user-url>
<jp06:role-assignments-url> internal user ID url /role-assignments</jp06:role-assignments-url>
<jp06:role-assignments>
<jp06:role-assignment>
<jp06:url>internal user ID url /role-assignments/commenter</jp06:url>
<jp06:role-url>project url /roles/commenter</jp06:role-url>
</jp06:role-assignment>
<jp06:role-assignment>
<jp06:url>internal user ID url /role-assignments/default</jp06:url>
<jp06:role-url> project url /roles/default</jp06:role-url>
</jp06:role-assignment>
</jp06:role-assignments>
<jp06:role-assignments-editor-url> role assignemnt editor url </jp06:role-assignments-editor-url>
</jp06:member>
...
</jp06:members>
It looks virtually the same for teams except for the team ID url. From this you can then format a document report
2 other answers

I am not a PUB user, but I assume you can use APIs in PUB. Here the available APIs: https://jazz.net/wiki/bin/view/Deployment/ELMProductAPILanding
The APIS I would investigate are

Hi Davyd thank you!
From your hint I was able to get the user ID urls (easy to greb the User ID from that)
and all the related roles in the projects area
But is there a way to get the real user names? (the one that is exposed by REST in eletronic signature)
Or somebody knows a way to query the user informations in DNG (or JTS) with PUB?
Thanks in any case
Luca