Simple query to pagerduty_incident table fails about steampipe-plugin-pagerduty HOT 6 CLOSED

@arruw Yes, you can try setting the created_at column in your queries, which then sets the Since and Until parameters. This should help reduce the number of results we try to get.

In the meantime, we'll also take a look at the error you're getting and see if we can handle it better and/or expose it better (depending on what the SDK returns).

from steampipe-plugin-pagerduty.

Hi @arruw, thanks for using Steampipe! Sorry to see that you are running into issues.
From the error HTTP response failed with status code 400, message: Arguments Caused Error, it seems like a bad request.

To investigate more around this issue we would like to understand a few things first:

• What happens if you try to list all incidents without passing any filter? For example:

select id, summary from pagerduty_incident limit 10

• If the above query works, can you please check the below query?

select id, summary from pagerduty_incident where created_at >= current_date

The above points will definitely help us to reproduce the issue. 👍

from steampipe-plugin-pagerduty.

Hi @Subhajit97, the first query works, but the second query fails exactly the same as in the example I give before.

Also, is it possible to attach and debug live plugin? Or in general how do you debug a plugin?

from steampipe-plugin-pagerduty.

Found the root cause, well we have a lot of noise in our pagerduty. This is the problematic request:
https://api.pagerduty.com/incidents?limit=100&offset=10000&since=2022-09-20T00%3A00%3A00Z

{
    "error": {
        "message": "Arguments Caused Error",
        "code": 2002,
        "errors": [
            "Offset+limit exceeds maximum allowed value of 10000. Please try to refine your search to reduce the returned set of records below this number, like adding a date range."
        ]
    }
}

One option to work around this would be to manipulate since & until parameters, wdyt?

from steampipe-plugin-pagerduty.

'This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.'

from steampipe-plugin-pagerduty.

'This issue was closed because it has been stalled for 90 days with no activity.'

from steampipe-plugin-pagerduty.