Preview not pulling data for Web Service Connector in SailPoint IIQ

Implement & Extend
1

Hi,

I have configured a simple web service application in SailPoint IIQ 8.5 version  and able to do Test Connection successfully.

Added Account Aggregation operation and mapped the response and when trying to Preview, it is not showing any values.

I am getting response as below when I try to hit the /users url in chrome:

[    {        “id”: 118,        “name”: “Ram”,        “email”: “ram@gmail.com”,        “groupname”: “Admin”,        “costcenter”: “1001”    },    {        “id”: 245,        “name”: “Alok”,        “email”: “alok@gmail.com”,        “groupname”: “Reins”,        “costcenter”: “1002”    },    {        “id”: 345,        “name”: “Bhas”,        “email”: “bhas@gmail.com”,        “groupname”: “Dev”,        “costcenter”: “1001”    }] Not Sure what should be in Root Path -- I tried $, $. , $.users,$.users[*],$.data, $.data[*]. All the examples are mapped to some variable holding the json response which is not in my case. Appreciate , if some one can point out what went wrong with my mapping.

2

If the Test Connection is successful and still not getting data mean check one of the few things:

  1. Schema mapping of identity Attribute might be wrong.
  2. Response mapping for the Account Aggregation might be not correct.
  3. As per the above json response $ should suffice for root path.
  4. Verify your logs once when you are doing preview or Account Aggregation which might give you some clue.
3

@shaikshavali Is it only preview not working, or even account aggregation is also not working?

Please share your app xml to review.

Note: Found a fix? Mark it as a solution! Want to say thanks? Give Kudos to anyone who helped you understand or solve the problem. Thanks..!!!

4

Hi neel193,

Both the preview and account aggregation are not working.

Attaching the app xml
cafe-ws.xml (11.5 KB)

5

Hi pvnkamesh,

I verified the identity mapping and values which all seems to be valid.

As you suggested verified logs during Preview/Account Aggregation and see the below error :

6

I see only cafe-ws.xml file…no logs attached.

7

@pvnkamesh

See attached logs

cafe-ws-logs.png
cafe-ws-logs.png993×452 12.5 KB

8

@shaikshavali

Use “$.*” as root path.

Schema (don’t use “id” as an application schema attribute):

image.png
image.png916×753 16.4 KB

image.png

Account Aggregation:

image.png
image.png1155×711 22 KB

image.png

Console Aggregation:

image.png
image.png926×647 21.1 KB

image.png

9

@shaikshavali Have you already tried setting rootPath to “$.”?

Note: Found a fix? Mark it as a solution! Want to say thanks? Give Kudos to anyone who helped you understand or solve the problem. Thanks..!!!

10

Hi @shaikshavali

The error highlights that employeeId is not valid attribute, verify the case sensitivity of it  again or else try with any other primary key attribute like email and see if the issue still persists.

As Paul mentioned, rest all config looks ok as per application.xml  and update  it to $.

11

Thanks @pvnkamesh , tried with email after which it is working..

12

Thanks Paul… After trying with email… I deleted and created new app with proper mapping of id which worked…thanks for your detailed example…