All Users with Role Report Mapping

You can map DaaS data to the All Users with Role Textura report with the following query.

Query

query{
  user(organizationID:xxx, offset:0, next:1){
    id
    firstName
    lastName
    email
    isActive
    role
    jobTitle
    projectManager
    complianceManager
    signer
    invoiceApprover
    disburser
    enterpriseDisburser
    ownerFundingManager
    classifiedAttachmentsManager
    tpaManager
    projectCreator
    interfacesManager
    allProjectsViewer
    notary
    lastLoginDate
    dateCreated
    phone
    altPhone
    fax
    enterpriseDisburser
    notaryStateProvince
    notary
    notaryExpiration
    dateModified
    projectUserRoles{
      authorizer
      parallelApprover
      project{
        segmentID
        projectNumber
        name
        ownerContract{
          organization {
            texturaCustomerNumber
            name
            address1
            address2
            city
            stateProvince
            postalCode
            phone
            taxID   
          }
        }
      }
    }
  }
}  

Mapping Table

Use the table below to map report output column fields to DaaS fields. Note that cells with a DaaS Field of Not Applicable do not have a DaaS equivalent to an available report field.

Column Number

Report Column

DaaS Field

1

Last Name

user.lastName

2

First Name

user.firstName

3

User ID

user.id

4

Username

Not Applicable

5

Email

user.email

6

Status

user.isActive

7

Type

user.role

8

Title

user.jobTitle

9

PM

user.projectManager

10

CM

user.complianceManager

11

Signer

user.signer

12

Invoice Approver

user.invoiceApprover

13

Authorizer

projectUserRoles.Authorizer

14

Disburser

user.disburser

15

Enterprise Disburser

user.enterpriseDisburser

16

Owner Funding Manager

user.ownerFundingManager

17

Classified Attachments Manager

user.classifiedAttachmentsManager

18

EPP Manager

user.tpaManager

19

Project Creator

user.projectCreator

20

Interface Manager

user.interfacesManager

21

View All Org Projects

user.allProjectsViewer

22

Textura Analytics

Not Applicable

23

View Only

user.docWriterViewOnly

24

Publisher

user.docWriterPublisher

25

Editor

user.docWriterEditor

26

Notary

user.notary

27

Last Login

user.lastLoginDate

28

Date Created

user.dateCreated

29

Created By

Not Applicable

30

Last Deactivation Date

Not Applicable

31

Deactivated By

Not Applicable



Last Published Friday, February 6, 2026