Error: wiz: graphql: Cannot query field "action" on type "ServiceTicket". (SQLSTATE HV000)

[sycophantic]

Describe the bug Execute select id from wiz_issue; and it returns Error: wiz: graphql: Cannot query field "action" on type "ServiceTicket". (SQLSTATE HV000)

Steampipe version (steampipe -v) v0.21.4

Plugin version (steampipe plugin list) v0.2.0

To reproduce select id from wiz_issue;

Expected behavior A list of issues.

Additional context I granted every read: permission to the oauth tokens and others queries work on other tables.

[jlgore]

I am seeing something similar on my end. Same version numbers as above. Was able to get some logs today. Not sure if they are helpful, but will continue to poke around and see what else I can come up with. Other fields can be queried with no problems.

2024-01-26 16:43:03.630 UTC [DEBUG] steampipe-plugin-wiz.plugin: [DEBUG] 1706287383145: Creating access token: connection=wiz 2024-01-26 16:43:03.630 UTC [DEBUG] steampipe-plugin-wiz.plugin: [DEBUG] 1706287383145: GetAccessToken: EXTRA_VALUE_AT_END="Getting access token..." 2024-01-26 16:43:05.240 UTC [ERROR] steampipe-plugin-wiz.plugin: [ERROR] 1706287383145: wiz_issue.listWizIssues: query_error="graphql: Cannot query field \"action\" on type \"ServiceTicket\"." 2024-01-26 16:43:05.240 UTC [WARN] steampipe-plugin-wiz.plugin: [WARN] 1706287383145: doList callHydrateWithRetries (wiz-1706287383145) returned err graphql: Cannot query field "action" on type "ServiceTicket". 2024-01-26 16:43:05.240 UTC [WARN] steampipe-plugin-wiz.plugin: [WARN] 1706287383145: QueryData StreamError graphql: Cannot query field "action" on type "ServiceTicket". (wiz-1706287383145) 2024-01-26 16:43:05.240 UTC [INFO] steampipe-plugin-wiz.plugin: [INFO] 1706287383145: rowData chan returned nil - wait for rows to complete (wiz-1706287383145) 2024-01-26 16:43:05.240 UTC [INFO] steampipe-plugin-wiz.plugin: [INFO] 1706287383145: buildRowsAsync goroutine returning (wiz-1706287383145) 2024-01-26 16:43:05.240 UTC [INFO] steampipe-plugin-wiz.plugin: [INFO] 1706287383145: QueryData streamRows DONE (wiz-1706287383145) 2024-01-26 16:43:05.240 UTC [WARN] steampipe-plugin-wiz.plugin: [WARN] 1706287383145: streamRows execution has failed: wiz-1706287383145 - calling queryCache.AbortSet (wiz: graphql: Cannot query field "action" on type "ServiceTicket".) 2024-01-26 16:43:05.240 UTC [WARN] steampipe-plugin-wiz.plugin: [WARN] 1706287383145: QueryCache AbortSet - aborting request with error wiz: graphql: Cannot query field "action" on type "ServiceTicket". (1 subscriber) (wiz-1706287383145) 2024-01-26 16:43:05.240 UTC [INFO] steampipe-plugin-wiz.plugin: [INFO] 1706287383145: QueryCache AbortSet pendingItemComplete (wiz-1706287383145) 2024-01-26 16:43:05.241 UTC [INFO] steampipe-plugin-wiz.plugin: [INFO] 1706287383145: QueryCache AbortSet - deleting 0 pages from the cache (wiz-1706287383145) 2024-01-26 16:43:05.241 UTC [INFO] steampipe-plugin-wiz.plugin: [INFO] 1706287383145: QueryCache AbortSet done (wiz-1706287383145)

[misraved]

Apologies for the delayed response @sycophantic and @jlgore!!

The GraphQL query used to retrieve the Wiz issues had changed since we had initially released the plugin.

The fix involved removing the action subfield from the ServiceTickets header in the GraphQL query.

Please feel free to test the fixes using the latest Wiz plugin.

Happy to help if you have questions or if the fix doesn't work as expected 👍 !!

[sycophantic]

I created a PR, one of the instances was missed. Thanks again!

[nogarab]

Hello, I am still getting this bug with the latest plugin versions (0.3.0, 1.0.0). even when selecting columns other than service_tickets. are you able to query this table now? would appreciate your assistance, thanks a lot 🙏