Is there an option to fetch the report from Wiz IO on ServiceNow via the GraphQL API?

[Kannan Nair]

We had a scenario where we need to load the csv report from the Wiz IO app to ServiceNow. As per our understanding Wiz IO only support Graphql API call and not the REST/SOAP. There are some capabilities in ServiceNow to generate the Graphql queries but that is to build the payload for ServiceNow data so that if can be used to fetch the data from ServiceNow on a third party tool. Our objective is to call the Wiz API in ServiceNow to get the report generated on the Wiz IO application.

[Punit S · Accepted solution]

Hi Kannan Nair, 

If Wiz IO only supports GraphQL API calls, and you need to call that API from ServiceNow, you will need to create a custom integration in ServiceNow that uses GraphQL to communicate with Wiz IO.

Here are the general steps you would need to follow:

1. Create a custom GraphQL query: Using the ServiceNow GraphQL API capabilities, create a custom GraphQL query that will retrieve the data you need from Wiz IO. This query should be tailored to the specific requirements of your use case, and should conform to the GraphQL schema used by Wiz IO.

2. Build the API call: Using ServiceNow's Scripting capabilities, build the API call to Wiz IO using the custom GraphQL query you created in step 1. You may need to use a third-party library to handle the GraphQL requests and responses.

3. Process the response: Once you receive a response from Wiz IO, you will need to process it to extract the relevant data and create records in ServiceNow. Depending on the format of the response, you may need to use JavaScript functions to parse the data and create records.

4. Schedule the integration: To automate the process of retrieving data from Wiz IO, you may want to schedule the integration to run at regular intervals. This can be done using ServiceNow's Scheduled Jobs functionality.

Overall, this approach requires some advanced expertise in working with GraphQL and JavaScript in ServiceNow. However, once set up, it can provide a way to retrieve data from Wiz IO and integrate it with your ServiceNow instance.

Hope this information is beneficial. 

Thanks,

Punit