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

{
    "data": {
        "getPsoRecords": {
            "totalCount": 534,
            "edges": [
                {
                    "node": {
                        "externalId": "9abd803c-f333-4473-b021-f8be622fc9fd",
                        "createdAt": "2019-07-11T09:38:42Z",
                        "psoAlias": "usr",
                        "fieldAliasAndValue": {
                            "professional_phone": "null",
                            "usr_last_name": "Talend",
                            "username": "admin.talend.orchestrate",
                            "usr_first_name": "Admin",
                            "professional_email": "[email protected]"
                        }
                    },
                    "cursor": "Ng=="
                },
                {
                    "node": {
                        "externalId": "a76fe2de-0492-4222-b263-995648deab4d",
                        "createdAt": "2019-07-11T09:39:08Z",
                        "psoAlias": "usr",
                        "fieldAliasAndValue": {
                            "professional_phone": "null",
                            "usr_last_name": "Consultant",
                            "usr_first_name": "Admin",
                            "username": "admin.consultant.orchestrate",
                            "professional_email": "[email protected]"
                        }
                    },
                    "cursor": "Nw=="
                },
                {
                    "node": {
                        "externalId": "049d56e4-e1aa-44ff-9d3e-6f4b147b7a87",
                        "createdAt": "2023-05-17T11:58:59Z",
                        "psoAlias": "usr",
                        "fieldAliasAndValue": {
                            "professional_phone": "06 27 71 71 78",
                            "usr_last_name": "Paul",
                            "username": "[email protected]",
                            "usr_first_name": "Nicole",
                            "professional_email": "[email protected]"
                        }
                    },
                    "cursor": "MTAz"
                },
                {
                    "node": {
                        "externalId": "1478c6e2-d975-41c2-92f3-4572fa1114f7",
                        "createdAt": "2023-05-17T11:59:00Z",
                        "psoAlias": "usr",
                        "fieldAliasAndValue": {
                            "professional_phone": "06 27 71 71 72",
                            "usr_last_name": "Gregoire",
                            "professional_email": "[email protected]",
                            "usr_first_name": "Camille",
                            "username": "[email protected]"
                        }
                    },
                    "cursor": "MTA0"
                },
.................
.................

                {
                    "node": {
                        "externalId": "92a4720f-7fc6-4e7f-a9d0-d661828574da",
                        "createdAt": "2023-05-17T11:59:38Z",
                        "psoAlias": "usr",
                        "fieldAliasAndValue": {
                            "professional_phone": "07 89 50 86 57",
                            "usr_last_name": "Sonard",
                            "username": "[email protected]",
                            "usr_first_name": "Kevin",
                            "professional_email": "[email protected]"
                        }
                    },
                    "cursor": "MjAw"
                }
            ]
        }
    },
    "errors": null
}

Query To retrieve the following 100 user data:

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

Get a user PSO Data

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

Query

query GetPsoRecords {
    getPsoRecords(
        alias: "usr"
        fields: [
            "user_id"
            "username"
            "professional_phone"
            "professional_email"
            "usr_first_name"
            "usr_last_name"
            "usr_position_start_date"
            "usr_poste"
            "division"
        ]
        first: 100
        filter: { externalId: "91a50097-6564-4f23-8db6-4bf7c8228f0e" }
    ) {
        totalCount
        edges {
            node {
                externalId
                createdAt
                psoAlias
                fieldAliasAndValue
            }
        }
    }
}

Response:

{
    "data": {
        "getPsoRecords": {
            "totalCount": 1,
            "edges": [
                {
                    "node": {
                        "externalId": "91a50097-6564-4f23-8db6-4bf7c8228f0e",
                        "createdAt": "2023-05-17T12:24:13Z",
                        "psoAlias": "usr",
                        "fieldAliasAndValue": {
                            "division": "3174",
                            "professional_phone": "06 99 34 19 27",
                            "usr_position_start_date": "2013-07-20",
                            "usr_poste": "53",
                            "usr_last_name": "Bisson",
                            "professional_email": "[email protected]",
                            "usr_first_name": "Colin",
                            "username": "[email protected]"
                        }
                    }
                }
            ]
        }
    },
    "errors": null
}

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

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

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])

{
    "data": {
        "getPsoRecords": {
            "totalCount": 534,
            "edges": [
                {
                    "node": {
                        "externalId": "a76fe2de-0492-4222-b263-995648deab4d",
                        "createdAt": "2019-07-11T09:39:08Z",
                        "psoAlias": "usr",
                        "fieldAliasAndValue": {
                            "professional_phone": "null",
                            "user_id": "a76fe2de-0492-4222-b263-995648deab4d",
                            "usr_last_name": "Consultant",
                            "username": "admin.consultant.orchestrate",
                            "usr_first_name": "Admin",
                            "professional_email": "[email protected]"
                        }
                    }
                },
                {
                    "node": {
                        "externalId": "049d56e4-e1aa-44ff-9d3e-6f4b147b7a87",
                        "createdAt": "2023-05-17T11:58:59Z",
                        "psoAlias": "usr",
                        "fieldAliasAndValue": {
                            "professional_phone": "06 27 71 71 78",
                            "usr_position_start_date": "2023-05-01",
                            "usr_last_name": "Paul",
                            "usr_first_name": "Nicole",
                            "professional_email": "[email protected]",
                            "username": "[email protected]"
                        }
                    }
                },
....