Channels

Overview

The Channels page allows you to register and manage channels to receive notifications sent by QueryPie. Currently, QueryPie provides four channel types: Slack, Agit, HTTP, and Email, and preliminary work for integration is required before channel registration.

Viewing Registered Channels

You can view the list of currently registered channels in the Administrator > General > Company Management > Channels page. You can search by channel name and filter by Channel Type.

Clicking on items in the list allows you to view and modify detailed information.

Registering Channels

Click the Create Channel button in the top right corner of the Channels page to display the channel creation modal.

• Title : Channel name
• Channel Type : Select the channel type to receive notifications. Additional input fields below vary depending on the selection.
  • Slack : Send notifications to Slack channel
  • Agit : Send notifications to Agit
  • HTTP : Direct request to HTTP API such as Zapier, Okta Workflows
  • Email : Send notifications via email

When Channel Type is set to Slack

The input content for channel creation is as follows.

• Message Sending Method : Message sending method
  • API : Send messages using Slack API
    • When API is selected, assignee mentions are possible in New Request Alerts. (After version 10.2.2)
    • Bot User OAuth Token : Bot User OAuth Token of the Slack App to send messages
    • Channel ID : Slack Channel ID where the Slack App to send messages is invited
  • Webhook : Send messages via webhook
    • Request URL (required) : URL to send requests to
      • Must copy and paste Webhook URL information after setting up Webhook in Slack App

When Channel Type is set to Agit

The input content for channel creation is as follows.

• Request URL (required) : URL to send requests to
• Agit Channel : Enter the name to display for the Agit channel

When Channel Type is set to HTTP

The input content for channel creation is as follows.

• Request URL (required) : URL to send requests to
• Request Header (JSON) : Enter request headers for calls if needed (JSON format)
• Body Template : Request body template
  • Default value : {{message}}
  • Enter content to add commonly before and after messages defined in Alert

When Channel Type is set to Email

The input content when creating a channel is as follows.

• Email Recipients (required) : Email recipients
  • You can select users registered in QueryPie, and emails will be sent to registered email addresses
• Body Template : Request body template
  • Default value : {{message}}
  • Enter content to add commonly before and after messages defined in Alert

Deleting Channels

Select the channel you want to delete with a checkbox in the channel list within the Channels page, and the Delete button will appear. Click the button to display a deletion confirmation modal. Click the OK button to complete the deletion.

Slack App Setup Method for Slack Integration

1. Creating an App

1. Go to https://api.slack.com/apps .
2. Click the Create an App button.
3. Select the App Name and Slack Workspace to send notifications to in the above screen.
4. Click Create App.

2-1. Integrating with Webhook Type

1. Navigate to the Incoming Webhooks menu within the app page.
2. Enable the Activate Incoming Webhooks option.
3. Click Add New Webhook to Workspace at the bottom.

1. Select the channel to send alerts to within the Workspace and click the Allow button.
2. Copy the generated Webhook URL information and paste it into the QueryPie channel creation modal.

2-2. Integrating with API Type

1. Click the created App to enter the app’s Settings page, then navigate to the App Manifest menu.
2. Add chat:write, users:read, users:read.email to the scopes area and save.
3. Restart the app through Reinstall your app via the yellow notification bar at the top. (Required)
4. Click the Reinstall to {Workspace_name} button to select the Slack channel to send notifications to, then click the Allow button.
   1. To apply after changing scopes, you must perform this step again.
5. Go to the corresponding Slack channel and add the created app. (If the app is already added, you can skip this step)
6. Click the channel name to open the Channel Detail modal, and copy the Channel ID from the bottom of the modal. Paste the copied Channel ID into the QueryPie channel creation modal.
7. Copy the Bot User OAuth Token from the OAuth & Permissions page and paste it into the QueryPie channel creation modal.