Webservices connector- Aggregation fetch single record only

Identity Security Cloud (ISC) ISC Discussion and Questions
, , ,
1

Hello ISC members

I am facing account aggregation issue where I can fetch 1300 accounts from postman using the same API call but when I do the same aggregation in SailPoint ISC webservices connector I can fetch only 2 accounts.

Below is the API response:

 [    
     [
        {
            "AppointmentID": "56663156",
            "Archived": false,
            "DepartmentID_1": "5ae5d6e7",
            "Resigned": null,
            "SectionID": null
        }, 
        {
            "AppointmentID": "26663132",
            "Archived": false,
            "DepartmentID_1": "5ae5d6e7",
            "Resigned": null,
            "SectionID": null
        }
    ],
    [
        {
            "BirthDate": "04/12/1990",
            "DegreeID_1": "d5808535",
            "FirstName": "ABC",
            "LastName": "PQQR",
            "MiddleName": null,
            "ProviderID": "165d6b2e",
            
        },
       {
            "BirthDate": "04/6/1993",
            "DegreeID_1": "d58085365",
            "FirstName": "ABC1",
            "LastName": "PQQR1",
            "MiddleName": null,
            "ProviderID": "645d6b6f",
            
        }
    ]
]

I have 1300 such records needs to be aggregated but I can fetch only 2 records.
1st record contains information from first array block and 2nd account contains second array block.

I have done the following config:

image
image2134×1394 231 KB

Pagination
$limit$ = 10
TERMINATE_IF $RECORDS_COUNT$ < $limit$
$offset$ = $offset$ + 1
$endpoint.fullUrl$ = $application.baseUrl$ + “api/test/query/batch”
$request.page$ = $offset$

Please help me if you have faced the similar case and handled it OOTB way.

Thanks
MB

2

$[0][*] seems to be the culprit here. What have you configured under “Response Information”?

3

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.