Issue with API Filtering

[Deepu]

We are experiencing issue with filtering user accounts based on their prefixes ("sa-" and "ea-")

we need to filter user accounts where the u_account_name starts with "sa-" or "ea-"

ImportUserJSON

{
"connection": "acctAuth",
"successResponses": {
"statusCode": [
200,
201,
202,
203,
204,
205
]
},
"url": "",
"httpMethod": "GET",
"httpHeaders": {
"Authorization": "${access_token}"
},
"userResponsePath": "result",
"colsToPropsMap": {
"username": "u_account_name~#~char",
"customproperty21": "u_action~#~char"
},
"filter": "u_account_name.startsWith('ea-')"
}

-------------------------------------------------------------------------------

{
"u_account_name": "sa-TzP6989",
"sys_id": "80edf07047a3861049cfafb4116d4315",
"u_user_display_name": "Test PrivlegedSA",
"sys_updated_by": "JzB4889",
"sys_created_on": "2024-07-19 16:33:13",
"sys_mod_count": "2",
"u_action": "",
"sys_updated_on": "2024-07-19 16:38:14",
"sys_tags": "",
"sys_created_by": "JzB4889",
"u_manager_name": ""
},
{
"u_account_name": "ea-TzP9064",
"sys_id": "84edf07047a3861049cfafb4116d4314",
"u_user_display_name": "Test PrivilegedAccount",
"sys_updated_by": "JzB4889",
"sys_created_on": "2024-07-19 16:33:13",
"sys_mod_count": "1",
"u_action": "certify",
"sys_updated_on": "2024-07-24 13:29:41",
"sys_tags": "",
"sys_created_by": "JzB4889",
"u_manager_name": ""
}

The filter should correctly segregate the accounts shwoing only "ea-" accounts .

[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.‼️‼️⚠️

[NM]

Hi @Deepu , is the filter supported by target application?