Sailpoint IDN Postman api call pagination issue

I need one help. I am trying to run get workflow executions api from postman, like - {{baseUrl}}/workflows/:id/executions

I tried various combinations like {{baseUrl}}/workflows/:id/executions?limit=250&offset=4 by chaing limit and offset value but still result is only for 3 days.

I am getting records for last 3 days only. However, in the api documentation, it says we can pull records up to 90 days.

List Workflow Executions
GET
https://sailpoint.api.identitynow.com/v3/workflows/:id/executions
Use this API to list a specified workflow’s executions. Workflow executions are available for up to 90 days before being archived. By default, you can get a maximum of 250 executions. To get executions past the first 250 records, you can do the following:

Could you please help me how can I use pagination and offset value to get data for last 30 days.

Hi @hranjan3

Can you try the below API for the same.

https://{Base URL}/v3/workflows/:id/executions?searchAfter=:executionID

As part of the every API call you can pass the last executionid to searchafter in API it will fetch the next 250 records.

Thank you.

Did you try to see how many executions is API returning?
you can get that by including this param: X-Total-Count: true
Based on that you can switch your offset value and see if it returns anything promising that can be determined to see if it actually contains the executions from past 90 days…

Moreover you can directly see if those executions are present by using start_time query parameter.

Example: Please change the date to proper formatting it should be like this:
2022-02-07T20:13:29Z

  • Gets you the records which executed before 2024-10-23rd. {{baseUrl}}/workflows/:id/executions?start_time lt 2024-10-23

  • Gets you the records which executed at the given time…
    {{baseUrl}}/workflows/:id/executions?start_time eq 2024-10-23

  • To your question for getting for last 30 days only… you can use this filter string and then do pagination as you were doing earlier:
    {{baseUrl}}/workflows/:id/executions?start_time gt 2024-09-23
    Gives you the records for last 30 days now to do pagination:

  • Gets you the records count from [250-499] {{baseUrl}}/workflows/:id/executions?start_time gt 2024-09-23&offset=1&limit=250

Thanks

1 Like

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