GetPsoRecords - Common Queries

  • Get PSO Field Records

  • Get a user PSO Data

    • Get Related PSO data

  • Notes & Usage

Get PSO Field Records

Query

Get the first 100 records for the fields: username professional_phone, professional_email, usr_first_name, usr_last_name

query GetPsoRecords {
    getPsoRecords(
        alias: "usr"
        fields: [
            "username"
            "professional_phone"
            "professional_email"
            "usr_first_name"
            "usr_last_name"
        ]
        first: 100
        
    ) {
        totalCount
        edges {
            node {
                externalId
                createdAt
                psoAlias
                fieldAliasAndValue
            }
            cursor
        }
    }
}

In this query, the cursor parameter is added, so that we can use the pagination for subsequent calls.

Response

Query To retrieve the following 100 user data:

Get a user PSO Data

to get data of a give user, use the filter criteria “externalId”

Query

Response:

Get Related PSO data

In the user PSO response, the key usr_poste returns the value 53.

to get the value, query the corresponding PSO.

Query:

In progress - Currently not usable

Notes & Usage

If a field in a given PSO is empty, the Key/Value will not be added in the return JSON Payload.

Query

Response

Note in the first node, the field usr_position_start_date is not provided in the response (for the user admin.consultant.orchestrate). whereas for the second, the field is provided [email protected])

Last updated