CyberArk Pagination issue

[jezzanuena]

Hi I'm trying to import accounts from CyberArk from this URL: https://abc123/PasswordVault/api/Accounts?offset=0&limit=1000

I'm using below paginations:

paginations #1

"pagination": {
"offset": {
"offsetParam": "offset",
"batchParam": "limit",
"batchSize": 1000,
"totalCountPath": "20000"
}
}

paginations #2

"pagination": {
"nextUrl": {
"nextUrlPath": "${response?.completeResponseMap?.done==true?null:'https://abc123/PasswordVault/'+response.completeResponseMap.nextLink}"
}
}

I used the above paginations but I can get all the accounts. I adjust the numbers in totalCountPath but it marked other accounts as suspended. Please help.

[rushikeshvartak]

pagination": {
"nextUrl": {
"nextUrlPath": "${(response?.completeResponseMap?.get('nextLink')==null)? null : response?.completeResponseMap?.get('nextLink')}"
}
}

[stalluri · Accepted solution]

@jezzanuena 
Try the below  Snip.

  "pagination": {
    "nextUrl": {
      "nextUrlPath": "${(response?.completeResponseMap?.nextLink == null) ? null : 'https://abc123/PasswordVault/' + response?.completeResponseMap?.nextLink}"
    }
  }


or

"pagination": {
"nextUrl": {
"nextUrlPath": "${(response?.completeResponseMap?.get('nextLink')==null)? null : response?.completeResponseMap?.get('nextLink')}"
}
}

[Amit_Malik]

Hi @jezzanuena ,

For your API call, below one should work

"pagination": {
"nextUrl": {
"nextUrlPath": "${(response?.completeResponseMap?.get('nextLink')==null)? null : response?.completeResponseMap?.get('nextLink')}"
}

If you decide to use CyberArk ootb connector, this works

"pagination": {
"offset": {
"offsetParam": "skip",
"batchParam": "take",
"batchSize": 100,
"totalCountPath": "completeResponseMap.total"
}
}

[NM]

Hi @jezzanuena , try this 

pagination": {

"nextUrl": {

"nextUrlPath": "${(response?.completeResponseMap?.get('nextLink')==null)? null : response?.completeResponseMap?.get('nextLink')}"

}

}

Using the same for cyberark rest connector

[jezzanuena]

Thank you, all! It worked using the below:

Spoiler

  "pagination": {
    "nextUrl": {
      "nextUrlPath": "${(response?.completeResponseMap?.nextLink == null) ? null : 'https://abc123/PasswordVault/' + response?.completeResponseMap?.nextLink}"
    }
  }

[rushikeshvartak]

Can you share full json