# WebService Connector Aggregation - no accounts **URL:** \ **Category:** SHF Discussion and Questions\ **Tags:** webservice-connector, identity-security-cloud, aggregation\ **Created:** [May 30, 2024, 5:53pm UTC](https://developer.sailpoint.com/discuss/t/webservice-connector-aggregation-no-accounts/58586 "2024-05-30T17:53:13Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![brent\_peterson](https://avatars.discourse-cdn.com/v4/letter/b/a6a055/32.png) [@brent\_peterson](https://developer.sailpoint.com/discuss/u/brent_peterson)\ **Post date:** [May 30, 2024, 5:53pm UTC](https://developer.sailpoint.com/discuss/t/webservice-connector-aggregation-no-accounts/58586/1 "2024-05-30T17:53:13Z")
I’m working on a new WebService connector and the test connection is working fine but when I run the aggregation it is successful but with no accounts being pulled in. The API works fine with results in Postman. I’ve attached some screenshots showing the config and what the sample results are supposed to be. What am I missing? ![image](https://global.discourse-cdn.com/sailpoint/original/2X/1/12c3942a106adb562a11bab095268cc9d2ea91c2.png) ![image](https://global.discourse-cdn.com/sailpoint/original/2X/b/b9ceccab9ba714fc523a3ab8dbe2cdd3ddc4db98.png) ![image](https://global.discourse-cdn.com/sailpoint/original/2X/6/66e6559518ed1e74c6b2690e28df4b4070a8b7c6.png) ![image](https://global.discourse-cdn.com/sailpoint/original/2X/9/95a864ffa6fb3604db27081eb167772bfb3d2128.png) ---
**Author:** ![zachm117](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/zachm117/32/3883_2.png) [@zachm117](https://developer.sailpoint.com/discuss/u/zachm117)\ **Post date:** [May 30, 2024, 6:04pm UTC](https://developer.sailpoint.com/discuss/t/webservice-connector-aggregation-no-accounts/58586/2 "2024-05-30T18:04:39Z")
Hey Brent! Try changing your Root Path to $.d[\*] Hope this helps! - Zach ---
**Author:** ![brent\_peterson](https://avatars.discourse-cdn.com/v4/letter/b/a6a055/32.png) [@brent\_peterson](https://developer.sailpoint.com/discuss/u/brent_peterson)\ **Post date:** [May 30, 2024, 7:51pm UTC](https://developer.sailpoint.com/discuss/t/webservice-connector-aggregation-no-accounts/58586/3 "2024-05-30T19:51:36Z")
> [@zachm117](#): > > $.d[\*] Thanks Zach, I tried that just now but unfortunately, same results. ---
**Author:** ![Arshad](https://avatars.discourse-cdn.com/v4/letter/a/b9e5f3/32.png) [@Arshad](https://developer.sailpoint.com/discuss/u/Arshad)\ **Post date:** [May 30, 2024, 8:01pm UTC](https://developer.sailpoint.com/discuss/t/webservice-connector-aggregation-no-accounts/58586/4 "2024-05-30T20:01:26Z")
@brent_peterson Can you share the GetUserList API response here as shown in the above screenshot? ---
**Author:** ![brent\_peterson](https://avatars.discourse-cdn.com/v4/letter/b/a6a055/32.png) [@brent\_peterson](https://developer.sailpoint.com/discuss/u/brent_peterson)\ **Post date:** [May 30, 2024, 8:03pm UTC](https://developer.sailpoint.com/discuss/t/webservice-connector-aggregation-no-accounts/58586/5 "2024-05-30T20:03:35Z")
``` { "d": [ { "UserName": "admin1", "UserType": "2", "AuthenticationType":"2", "DomainName":"", "HomePhone": "", "MobilePhone": "", "City": "", "State": "", "ZipCode": "", "Email": "", "Address1": "", "Address2": "", "Comments": "", "Roles": "" }, { "UserName": "User", "UserType": "0", "AuthenticationType":"2", "DomainName":"", "HomePhone": "9876543210", "MobilePhone": "9876543210", "City": "krr", "State": "tn", "ZipCode": "639004", "Email": "admin@admin.com", "Address1": "krr1", "Address2": "krr2", "Comments": "comments", "Roles": " Role1, Role2" } } ] } ``` ---
**Author:** ![Arshad](https://avatars.discourse-cdn.com/v4/letter/a/b9e5f3/32.png) [@Arshad](https://developer.sailpoint.com/discuss/u/Arshad)\ **Post date:** [May 30, 2024, 8:10pm UTC](https://developer.sailpoint.com/discuss/t/webservice-connector-aggregation-no-accounts/58586/6 "2024-05-30T20:10:38Z")
@brent_peterson, I see that your sample JSON from `/api/GetUsersList` is incorrect and has a parsing error at the closing brackets due to which connector is unable to parse the information. The JSON response should be corrected as below: ```auto { "d": [ { "UserName": "admin1", "UserType": "2", "AuthenticationType": "2", "DomainName": "", "HomePhone": "", "MobilePhone": "", "City": "", "State": "", "ZipCode": "", "Email": "", "Address1": "", "Address2": "", "Comments": "", "Roles": "" }, { "UserName": "User", "UserType": "0", "AuthenticationType": "2", "DomainName": "", "HomePhone": "9876543210", "MobilePhone": "9876543210", "City": "krr", "State": "tn", "ZipCode": "639004", "Email": "admin@admin.com", "Address1": "krr1", "Address2": "krr2", "Comments": "comments", "Roles": " Role1, Role2" } ] } ``` And then configure the root path as `$.d[*]` in Account Aggregation \> Response Information \> Root Path Let me know on how it goes. Thanks, Arshad. ---
**Author:** ![ipobeidi](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/ipobeidi/32/16000_2.png) [@ipobeidi](https://developer.sailpoint.com/discuss/u/ipobeidi)\ **Post date:** [May 30, 2024, 8:17pm UTC](https://developer.sailpoint.com/discuss/t/webservice-connector-aggregation-no-accounts/58586/7 "2024-05-30T20:17:28Z")
Brent, Add the roothPath $.d[\*] as they said, but allso add in the attribute mapping a DOT just before the attribute like that “.Comments”. Best! ---
**Author:** ![zachm117](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/zachm117/32/3883_2.png) [@zachm117](https://developer.sailpoint.com/discuss/u/zachm117)\ **Post date:** [May 30, 2024, 11:11pm UTC](https://developer.sailpoint.com/discuss/t/webservice-connector-aggregation-no-accounts/58586/8 "2024-05-30T23:11:37Z")
@Arshad good catch on that bracket error! I am not sure if you just had a very keen eye, but I put that into [JSONPath](https://jsonpath.com/) to see the error also. I just wanted to mention the tool in this post for @brent_peterson or anybody else to use when testing JSONPathing for responses. ---
**Author:** ![brent\_peterson](https://avatars.discourse-cdn.com/v4/letter/b/a6a055/32.png) [@brent\_peterson](https://developer.sailpoint.com/discuss/u/brent_peterson)\ **Post date:** [June 10, 2024, 3:44pm UTC](https://developer.sailpoint.com/discuss/t/webservice-connector-aggregation-no-accounts/58586/9 "2024-06-10T15:44:25Z")
Still no luck. Thanks for the note on the sample JSON, that was off the company’s documentation page, the JSON result from Postman looks like your corrected example. ---
**Author:** ![KRM7](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/krm7/32/2685_2.png) [@KRM7](https://developer.sailpoint.com/discuss/u/KRM7)\ **Post date:** [June 15, 2024, 8:44am UTC](https://developer.sailpoint.com/discuss/t/webservice-connector-aggregation-no-accounts/58586/10 "2024-06-15T08:44:36Z")
I am also facing same issue. Connector used is Web Services SaaS connector. Strange is that, it is working fine in SailPoint IdentityIQ. Informed SailPoint support, even they couldn’t find the root cause, recommended to use Web Services connector with Operation Rules to see the response in logs. I suggest you to add After Operation Rule and see the rawResponse object and processedResponse object. Thanks Krish ---
**Author:** ![Arshad](https://avatars.discourse-cdn.com/v4/letter/a/b9e5f3/32.png) [@Arshad](https://developer.sailpoint.com/discuss/u/Arshad)\ **Post date:** [June 20, 2024, 9:53am UTC](https://developer.sailpoint.com/discuss/t/webservice-connector-aggregation-no-accounts/58586/11 "2024-06-20T09:53:55Z")
@KRM7 Even I’ve noticed SaaS connectors have a lots of such issues. I’ve encountered such issues on Web Services SaaS, Workday SaaS and many others where the exact same configuration works with normal connector but not SaaS connectors. @brent_peterson as suggested above, best would be use normal web service connector and leverage operation rules as it would be your best bet at this point. ---
**Author:** ![brent\_peterson](https://avatars.discourse-cdn.com/v4/letter/b/a6a055/32.png) [@brent\_peterson](https://developer.sailpoint.com/discuss/u/brent_peterson)\ **Post date:** [June 28, 2024, 5:28pm UTC](https://developer.sailpoint.com/discuss/t/webservice-connector-aggregation-no-accounts/58586/12 "2024-06-28T17:28:35Z")
I’ve escalated to support and will see what they can find in the logs and if it needs to go the route of rules. ---
**Author:** ![KRM7](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/krm7/32/2685_2.png) [@KRM7](https://developer.sailpoint.com/discuss/u/KRM7)\ **Post date:** [June 28, 2024, 5:38pm UTC](https://developer.sailpoint.com/discuss/t/webservice-connector-aggregation-no-accounts/58586/13 "2024-06-28T17:38:51Z")
I have used WebService SaaS connector for multiple applications, It is not like it never worked. The issue is inconsistent, please do let us know once you get the response from SailPoint. Thanks Krish ---
**Author:** ![brent\_peterson](https://avatars.discourse-cdn.com/v4/letter/b/a6a055/32.png) [@brent\_peterson](https://developer.sailpoint.com/discuss/u/brent_peterson)\ **Post date:** [July 15, 2024, 4:33pm UTC](https://developer.sailpoint.com/discuss/t/webservice-connector-aggregation-no-accounts/58586/14 "2024-07-15T16:33:31Z")
Feeling a bit foolish on this one, but it turns out my base URL was not correct. ---
**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\ **Post date:** [September 13, 2024, 4:34pm UTC](https://developer.sailpoint.com/discuss/t/webservice-connector-aggregation-no-accounts/58586/15 "2024-09-13T16:34:25Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.