# Web Services Connector – Account Aggregation fails with ResultSet / SchemaNotDefinedException in IIQ (ServiceNow sys\_user API) **URL:** \ **Category:** IIQ Discussion and Questions\ **Tags:** webservice-connector, identityiq\ **Created:** [May 28, 2026, 1:15pm UTC](https://developer.sailpoint.com/discuss/t/web-services-connector-account-aggregation-fails-with-resultset-schemanotdefinedexception-in-iiq-servicenow-sys-user-api/210744 "2026-05-28T13:15:08Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![kazi\_1234](https://avatars.discourse-cdn.com/v4/letter/k/d2c977/32.png) [@kazi\_1234](https://developer.sailpoint.com/discuss/u/kazi_1234)\ **Post date:** [May 28, 2026, 1:15pm UTC](https://developer.sailpoint.com/discuss/t/web-services-connector-account-aggregation-fails-with-resultset-schemanotdefinedexception-in-iiq-servicenow-sys-user-api/210744/1 "2026-05-28T13:15:08Z")
I am working on integrating an application with SailPoint IdentityIQ using the **Web Services connector** to perform **account aggregation**. The target system exposes a REST API that returns user data in JSON format (similar to a standard list‑users endpoint), and the API works correctly when tested externally, returning a list of users under a top‑level JSON array. In IdentityIQ, I configured the application with OAuth 2.0 (client credentials), a GET‑based account aggregation operation, and defined an account object schema with basic attributes (such as a unique account identifier and supporting user attributes). I also configured the response mapping to point to the JSON array and mapped individual attributes accordingly. However, when running the **Account Aggregation task** , the job fails with errors such as _“Unable to create iterator”_, _“could not extract ResultSet”_, or _“SchemaNotDefinedException: The schema for objectType account is not configured for this connector”_, even though the schema and response mappings appear to be defined. Test Connection succeeds, and the API itself returns valid data, but IdentityIQ is unable to iterate over the response and create account objects. I am trying to understand whether this is a known limitation or configuration nuance of the Web Services connector for GET‑based JSON APIs, or if there are additional required steps (beyond schema definition and response mapping) to correctly enable account aggregation. ![image](https://global.discourse-cdn.com/sailpoint/original/3X/6/e/6e7be329f14214d67f394a130f62237f4e67ba67.png) ![image](https://global.discourse-cdn.com/sailpoint/original/3X/2/8/28892b3a9e681a79451b60206e34d98e62bd1952.png) ---
**Author:** ![Rameshv](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/rameshv/32/37743_2.png) [@Rameshv](https://developer.sailpoint.com/discuss/u/Rameshv)\ **Post date:** [May 28, 2026, 1:46pm UTC](https://developer.sailpoint.com/discuss/t/web-services-connector-account-aggregation-fails-with-resultset-schemanotdefinedexception-in-iiq-servicenow-sys-user-api/210744/2 "2026-05-28T13:46:43Z")
Hi Kazi, The issue looks like the Connector Operations are not configured correctly. Just defining the Schema is not enough. you also need to create an explicit Operation for account aggregation. Here’s what to check: 1. **Operation Type** must be set to “Iterate Accounts” (not left blank or set to Test Connection) 2. **Object Type** inside the operation must be set to “account”. this is what links it to your schema 3. **Root Path** must point to the JSON array in the response (e.g., `result` for ServiceNow sys\_user API) 4. **Attribute mappings** must be defined inside the operation itself, not just in the schema Without the Operation Type = “Iterate Accounts” and Object Type = “account”, IIQ has no way to know this operation is meant to pull accounts hence the SchemaNotDefinedException even though the schema exists. Try reconfiguring the operation with these settings and the aggregation should work. ---
**Author:** ![naveenkumar3](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/naveenkumar3/32/39339_2.png) [@naveenkumar3](https://developer.sailpoint.com/discuss/u/naveenkumar3)\ **Post date:** [May 28, 2026, 1:49pm UTC](https://developer.sailpoint.com/discuss/t/web-services-connector-account-aggregation-fails-with-resultset-schemanotdefinedexception-in-iiq-servicenow-sys-user-api/210744/3 "2026-05-28T13:49:29Z")
> [@kazi\_1234](#): > > I am working on integrating an application with SailPoint IdentityIQ using the **Web Services connector** to perform **account aggregation**. The target system exposes a REST API that returns user data in JSON format (similar to a standard list‑users endpoint), and the API works correctly when tested externally, returning a list of users under a top‑level JSON array. In IdentityIQ, I configured the application with OAuth 2.0 (client credentials), a GET‑based account aggregation operation, and defined an account object schema with basic attributes (such as a unique account identifier and supporting user attributes). I also configured the response mapping to point to the JSON array and mapped individual attributes accordingly. > > However, when running the **Account Aggregation task** , the job fails with errors such as _“Unable to create iterator”_, _“could not extract ResultSet”_, or _“SchemaNotDefinedException: The schema for objectType account is not configured for this connector”_, even though the schema and response mappings appear to be defined. Test Connection succeeds, and the API itself returns valid data, but IdentityIQ is unable to iterate over the response and create account objects. I am trying to understand whether this is a known limitation or configuration nuance of the Web Services connector for GET‑based JSON APIs, or if there are additional required steps (beyond schema definition and response mapping) to correctly enable account aggregation. The Web Services connector does **not** use the Schema tab for object type definition. It reads the object type from the **connector configuration XML** directly. Go to your Application XML and ensure this exists: ```auto ``` If it says `Account`, `accounts`, or is missing entirely, the connector throws `SchemaNotDefinedException` at runtime regardless of what the Schema tab shows. Fix it in the XML, save, and re-run. ---
**Author:** ![Chathuryas](https://avatars.discourse-cdn.com/v4/letter/c/ee59a6/32.png) [@Chathuryas](https://developer.sailpoint.com/discuss/u/Chathuryas)\ **Post date:** [May 28, 2026, 2:17pm UTC](https://developer.sailpoint.com/discuss/t/web-services-connector-account-aggregation-fails-with-resultset-schemanotdefinedexception-in-iiq-servicenow-sys-user-api/210744/4 "2026-05-28T14:17:01Z")
Hi @kazi_1234 , Can you share the account aggregation operation, application schema and sample response screenshots ---
**Author:** ![pradeep1602](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/pradeep1602/32/30858_2.png) [@pradeep1602](https://developer.sailpoint.com/discuss/u/pradeep1602)\ **Post date:** [May 28, 2026, 5:55pm UTC](https://developer.sailpoint.com/discuss/t/web-services-connector-account-aggregation-fails-with-resultset-schemanotdefinedexception-in-iiq-servicenow-sys-user-api/210744/5 "2026-05-28T17:55:57Z")
Click Add Object Type. provide account and then define the schema manually but adding all attribute. make sure attr names in schema matches with attr name in reponse mapping as well ---
**Author:** ![neel193](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/neel193/32/34038_2.png) [@neel193](https://developer.sailpoint.com/discuss/u/neel193)\ **Post date:** [May 29, 2026, 5:04am UTC](https://developer.sailpoint.com/discuss/t/web-services-connector-account-aggregation-fails-with-resultset-schemanotdefinedexception-in-iiq-servicenow-sys-user-api/210744/6 "2026-05-29T05:04:23Z")
@kazi_1234 You mentioned you have schema defined properly, but it is blank in your screenshot. Could you please reimport your artefacts or check in debug if schema is still defined in app xml, if so, remove the ids and save it one more time. If issue still persists, please share app xml for review. ---
**Author:** ![Arpitha1](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/arpitha1/32/20512_2.png) [@Arpitha1](https://developer.sailpoint.com/discuss/u/Arpitha1)\ **Post date:** [May 29, 2026, 10:01am UTC](https://developer.sailpoint.com/discuss/t/web-services-connector-account-aggregation-fails-with-resultset-schemanotdefinedexception-in-iiq-servicenow-sys-user-api/210744/7 "2026-05-29T10:01:23Z")
Can you share your application xml by masking sensitive details ? ---
**Author:** ![jchinnapareddy](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/jchinnapareddy/32/38628_2.png) [@jchinnapareddy](https://developer.sailpoint.com/discuss/u/jchinnapareddy)\ **Post date:** [May 29, 2026, 10:48am UTC](https://developer.sailpoint.com/discuss/t/web-services-connector-account-aggregation-fails-with-resultset-schemanotdefinedexception-in-iiq-servicenow-sys-user-api/210744/8 "2026-05-29T10:48:48Z")
Verify below details in connector Step 1: Verify Operation Object Type Open your Application Configuration in IIQ and go to the HTTP Operations tab. Select your Account Aggregation operation. Look at the Object Type field for this specific operation. Ensure it says account (lowercase, matching standard IIQ schema) or matches whatever you named your schema exactly. If it says User or is blank, IIQ won’t be able to map the incoming stream to the schema you defined, throwing that SchemaNotDefinedException. Step 2: Configure the Response Mapping Root The connector needs to know where the list starts. In your Account Aggregation operation, under the Response Mapping section: Root Path (or Response Element): If your API returns a raw JSON array at the very top level, use $ or /. If your API returns an object like {“users”: […]}, your Root Path must be $.users (for JSONPath) or /users. Attribute Mappings: Ensure your attributes are relative to this root path. For example, if the root is $.users, the attribute path for the identifier should just be id or $.id, not $.users.id. Step 3: Check for Paging / “Terminal” Condition The “Unable to create iterator” error frequently happens if IIQ tries to execute a paging loop and gets stuck, or if it expects a list but receives a single object (or vice versa). If your API does not use pagination, ensure that the paging configuration on the operation is entirely disabled or left blank. If it returns a single page and stops, IIQ needs to know it’s a single-shot request, otherwise, the iterator fails on the second (non-existent) page attempt. Step 4: The Schema Definition Go to the Schema tab of your application: Ensure the Object Type of the schema is exactly account. Ensure the Identity Attribute (e.g., id or username) matches the exact name of the attribute you are extracting in your response mapping. Summary Checklist for your WS Operation Configuration Field Expected Value / Check Operation Type Account Aggregation Object Type account (Must match Schema name) Root Path / Context Set to the base of the JSON array (e.g., $.users or $) Paging Disabled (unless explicitly configured with a termination rule) A Quick Troubleshooting Tip If you apply these changes and it still fails, turn on specialized logging to see the exact payload IIQ is failing to parse. Add this to your log4j2.properties file: logger.webservices.name = connector.sdk.webservices logger.webservices.level = debug This will print the raw JSON response and the connector’s attempt to parse it directly into the sailpoint.log, allowing you to see exactly where the JSONpath expression is losing its way. ---
**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\ **Post date:** [July 28, 2026, 10:49am UTC](https://developer.sailpoint.com/discuss/t/web-services-connector-account-aggregation-fails-with-resultset-schemanotdefinedexception-in-iiq-servicenow-sys-user-api/210744/9 "2026-07-28T10:49:48Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.