CyberArk Account filter URL

[jezzanuena]

Hi Everyone! Im trying to filter accounts based on its name. In postman, this URL works:

⁠Https://cyberark123/PasswordVault/api/Accounts?filter=safename eq P-US-*⁠

However, I am not sure how to put in connection under import JSON. It has some spaces and a wildcard to get the response. Please help.

[NM]

@jezzanuena instead of space add %20 and for wildcard .. use blackslash to escape it.

[rushikeshvartak]

Please share JSON

⁠Https://cyberark123/PasswordVault/api/Accounts?filter=safename%20eq%20P-US-%2A%E2%81%A0⁠

[jezzanuena]

Thank you, @rushikeshvartak I used filter=safename%20eq%20P-US-%2A%E2%81%A0 , however all accounts has been marked as suspended even though I am getting results in Postman. I can import all the accounts with the filter but the requirement is to get specific safe names only.

Here's my actual URL: /PasswordVault/api/Accounts?offset=0&limit=1000&filter=safename%20eq%20P-US-%2A%E2%81%A0⁠

Hi @NM like this?  ⁠Https://cyberark123/PasswordVault/api/Accounts?filter=safename%20eq%20P-US-\ I am getting error saving the connection with this one. 😞

[stalluri]

@jezzanuena 

Make sure you have the status config present in the import and mapped in the 
Account import Config

"statusConfig": {
          "active": "true",
          "inactive": "false"
        },

STATUS_THRESHOLD_CONFIG: Status Config 

{
                "statusAndThresholdConfig": {
                "accountThresholdValue": 100,
                "inactivateAccountsNotInFile": true,
                "statusColumn": "customproperty30",
                "activeStatus": [
                "true",
                "1"
                ],
                "inactivateEntsNotInFeed": true,
                "entThresholdValue": {
                "entType": {
                "Group": {
                "ent": 100
                },
                "Role": {
                "ent": 100
                }
                }
                }
                }
        }

[rushikeshvartak]

Please share logs in text format

[jezzanuena]

hi @rushikeshvartak and @stalluri, I can't find the logs of import:

2024-09-11T16:07:35+08:00-ecm-domain.FlatViewJobcontrolController-http-nio-8080-exec-12-cdlz8-DEBUG-Inside fireJobAction params = [triggername:CyberArkSafesAcctImp, triggergroup:GRAILS_JOBS, jobname:ApplicationDataImportJob, jobgroup:DATA, actn:6, job_name:, job_group:, controller:flatViewJobcontrol, action:fireJobAction]

2024-09-11T16:07:26+08:00-ecm-certificatemgmt.CertificateManagementService-http-nio-8080-exec-5-cdlz8-DEBUG-sslCert = CyberArk UAT

2024-09-11T16:07:26+08:00-ecm-integration.ExternalConnectionCallService-http-nio-8080-exec-12-cdlz8-DEBUG-in testExternalConnection for External Connection : CyberArk Safe US

Here is the accountparams that I am using. statusAndThresholdConfig is also in the STATUS_THRESHOLD_CONFIG,  still not working. 

Spoiler

"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"accountThresholdValue": 50000,
"deleteLinks": true,
"statusColumn": "customproperty7",
"activeStatus": [
"true"
],
"inactivateAccountsNotInFile": false,
"correlateInactiveAccounts": true

},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://uat-cyberark.abc.com/PasswordVault/api/Accounts?offset=0&limit=1000&filter=safename%20eq%20P...",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "value",
"keyField": "accountID",
"statusConfig": {
"active": "true",
"inactive": "false"
},
"colsToPropsMap": {
"accountID": "id~#~char",
"name": "userName~#~char",
"displayName": "name~#~char",
"status": "secretManagement.automaticManagementEnabled~#~char",
"customproperty1": "userName~#~char",
"customproperty2": "platformId~#~char",
"customproperty3": "address~#~char",
"customproperty4": "secretType~#~char",
"customproperty5": "platformAccountProperties.ApplicationID~#~char",
"customproperty6": "platformAccountProperties.ActiveDirectoryID~#~char",
"customproperty7": "secretManagement.automaticManagementEnabled~#~char",
"customproperty9": "secretManagement.lastModifiedTime~#~char",
"customproperty10": "createdTime~#~char",
"customproperty11": "name~#~char",
"customproperty12": "safeName~#~char",
"customproperty13": "id~#~char",
"customproperty31": "STORE#ACC#ENT#MAPPINGINFO~#~char"
},
"pagination": {
"nextUrl": {
"nextUrlPath": "${(response?.completeResponseMap?.nextLink == null) ? null : 'https://uat-cyberark.abc.com/PasswordVault/' + response?.completeResponseMap?.nextLink}"
}
}
}
},
"acctEntMappings": {
"Safes": {
"listPath": "safeName",
"idPath": "",
"keyField": "entitlementID"
}
}
}

[rushikeshvartak]

Please share postman screenshot and curl command [Refer https://codingnconcepts.com/postman/how-to-generate-curl-command-from-postman/ ]



⚠️‼️‼️Do not upload any attachments that contain sensitive information, such as IP Addresses, URLs, Company/Employee Names, Email Addresses, etc.‼️‼️⚠️