ConnectALL automation with flow filter at ServiceNow side won't sync any records after upgrading from 2.11 to 4.1

Products

• ConnectAll SaaS
• ConnectALL
• ConnectAll On-Prem

Issue/Introduction

ServiceNow automations using flow filters fail to synchronize records following an upgrade to ConnectALL version 4.1. This typically occurs when the flow filter contains special characters that require specific encoding in the updated API handler.

Flow filter -

#sysparmquery#state=Open

com.go2group.connectall.model.transformer.servicenow.ServiceNowConnectionManager: Error while getting modified records due to the error Exception occurred in get operation:. Returning records of size : 0

Environment

• ConnectALL 4.1.x
• ServiceNow Integration

Cause

ConnectALL version 4.1 and higher requires strict URL encoding for API requests. The hash character (#) used in legacy flow filters is no longer automatically handled and must be manually encoded.

TechDoc ServiceNow Flow Filter

Resolution

Replace the legacy filter syntax with the encoded equivalent.

1. Navigate to the Automation configuration in ConnectALL.
2. Locate the Flow Filter field for the ServiceNow entity.
3. Replace #sysparm_query# with %23sysparm_query%23.

Example:

• Old Filter: #sysparm_query#state=Open
• New Filter: %23sysparm_query%23state=Open