Filters in workday source

Hi All,

I want to aggregate only test users starting with the first name prefixed “Test” e.g. First Name : Test_paul

Can any one help with the steps that would be required to setup this filter in the workday source? Is there any connector attribute that needs to be set in the source? If yes, what is the attribute name?

Is there any documentation that explains the steps in details? Apart from the connector documentation because i was not able to find any examples in the connector documentation.

Thanks,
Shivam Bahl

Hi Shivam,
Here you can find documentation which shows what kind of filters you can use OoTB in Workday connector
https://documentation.sailpoint.com/connectors/workday/help/integrating_workday/aggregation_settings.html

Hi Kamil,

I have already gone through the filters mentioned here but was not able to find any proper implementation example that can help me implement the filter.

Thanks,
Shivam bahl

Did you maybe try this solution?

https://developer.sailpoint.com/discuss/t/filter-in-workday-source/2656/5

Hi Kamil,

I did look into this post but unfortunately what key needs to be updated is not mentioned in that post. Can you help and share an example for the update json request that needs to go in the ‘POST /api/source/update/[SOURCEID]’ API request.

Hi @SBahl ,

Are you looking for json body for put-source | SailPoint Developer Community or update-source | SailPoint Developer Community?

1 Like

I am looking for the connector attribute name that needs to be added or updated in the source.

If you can share the example json body for updating the source that will be helpful.

{
  "id": "2c91808568c529c60168cca6f90c1324",
  "name": "My Source",
  "description": "This is the corporate directory.",
  "owner": {
    "type": "IDENTITY",
    "id": "2c91808568c529c60168cca6f90c1313",
    "name": "MyName"
  },
  "cluster": {
    "type": "CLUSTER",
    "id": "2c9180866166b5b0016167c32ef31a66",
    "name": "Corporate Cluster"
  },
  "accountCorrelationConfig": {
    "type": "ACCOUNT_CORRELATION_CONFIG",
    "id": "2c9180855d191c59015d28583727245a",
    "name": "Directory [source-62867] Account Correlation"
  },
  "accountCorrelationRule": {
    "type": "RULE",
    "id": "2c918085708c274401708c2a8a760001",
    "name": "Example Rule"
  },
  "managerCorrelationMapping": {
    "accountAttribute": "manager",
    "identityAttribute": "manager"
  },
  "managerCorrelationRule": {
    "type": "RULE",
    "id": "2c918085708c274401708c2a8a760001",
    "name": "Example Rule"
  },
  "beforeProvisioningRule": {
    "type": "RULE",
    "id": "2c918085708c274401708c2a8a760001",
    "name": "Example Rule"
  },
  "schemas": [
    {
      "type": "CONNECTOR_SCHEMA",
      "id": "2c9180835d191a86015d28455b4b232a",
      "name": "account"
    },
    {
      "type": "CONNECTOR_SCHEMA",
      "id": "2c9180835d191a86015d28455b4b232b",
      "name": "group"
    }
  ],
  "passwordPolicies": [
    {
      "type": "PASSWORD_POLICY",
      "id": "2c9180855d191c59015d291ceb053980",
      "name": "Corporate Password Policy"
    },
    {
      "type": "PASSWORD_POLICY",
      "id": "2c9180855d191c59015d291ceb057777",
      "name": "Vendor Password Policy"
    }
  ],
  "features": [
    "SYNC_PROVISIONING",
    "MANAGER_LOOKUP",
    "SEARCH",
    "PROVISIONING",
    "AUTHENTICATE",
    "GROUP_PROVISIONING",
    "PASSWORD"
  ],
  "type": "OpenLDAP - Direct",
  "connector": "active-directory",
  "connectorClass": "sailpoint.connector.LDAPConnector",
  "connectorAttributes": {
    "healthCheckTimeout": 30,
    "authSearchAttributes": [
      "cn",
      "uid",
      "mail"
    ]
  },
  "deleteThreshold": 10,
  "authoritative": false,
  "managementWorkgroup": {
    "type": "GOVERNANCE_GROUP",
    "id": "2c91808568c529c60168cca6f90c2222",
    "name": "My Management Workgroup"
  },
  "healthy": true,
  "status": "SOURCE_STATE_HEALTHY",
  "since": "2021-09-28T15:48:29.3801666300Z",
  "connectorId": "active-directory",
  "connectorName": "Active Directory",
  "connectionType": "file",
  "connectorImplementationId": "delimited-file"
}

Hi Kavinder,

I am looking for the connector attribute name that needs to be set in workday source for setting the filter to aggregate only test users starting with the first name prefixed “Test” e.g. First Name : Test_paul

solved in this post.

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.