ServiceNow Import | Data Import | Zoho Sprints Help

ServiceNow Import

ServiceNow is a cloud-based platform that uses AI to streamline tasks, automate and manage workflows, enabling work to be completed faster with better visibility.

Securely import agile products belonging to Agile Development 2.0 plugin from ServiceNow to Zoho Sprints. The tool extracts products, backlogs, epics, user stories, tasks and sprint information using authorized APIs and maps product-related data with Zoho Sprints. The import can be initiated multiple times as needed.

Info
Availability: All plans
Warning
Accessibility: Workspace owner can configure and initiate import.

Generate API key in ServiceNow

To generate API key in ServiceNow, switch to the ServiceNow application and follow the below mentioned steps:

Create an Inbound Authentication Profile

  1. Navigate to All > System Web Services > API Access Policies > Inbound Authentication Profile.
  2. Click New.
  3. Click Create API Key authentication profiles.
  4. Provide a descriptive name in the Name field.
  5. In the Auth Parameter field, select Auth Header record for x-sn-apikey.

  6. Click Submit.

Create API Access Policy

  1. Navigate to All > System Web Services > API Access Policies > REST API Key.
  2. Click New.
  3. Provide a descriptive name and select the required REST API.
  4. Create Rest API policies for Table, Attachment, and  Aggregate. Refer to the screenshots below for better understanding:
    Rest API policy for Table: 


    Rest API policy for attachment:

    Rest API policy for aggregate:

Create a Rest API Key 

  1. Navigate to All > System Web Services > API Access Policies > REST API Key.
  2. Click New.
  3. Provide a descriptive name and select a user.

  4. Use the form menu and choose Submit.

The system automatically generates a token and it is saved in the Token field. View the token by clicking the lock icon and then copy the contents. This is your header value when your other system sends a REST API request to ServiceNow.
Notes
Note: Secure the user credentials by setting up an expiry date for the API key. 
    Now, copy the generated API Key from ServiceNow and use here.

Import products to Zoho Sprints as projects

  1. Click the gear icon at the top-right corner. The settings window will appear.
  2. Click Project under Imports.
  3. Select ServiceNow.
  4. Enter the ServiceNow URL and API key.
  5. Select the checkbox to agree to the terms and conditions.
  6. Click Authorize. The authorization will be validated.
  7. After authorization, the products in the Agile Development 2.0 plugin will be listed.
  8. Select the products to be imported. You can import up to 50 products in one attempt.
  9. Click Import.
  10. Confirm your action and click the Import button.
The import process will be initiated, and you will receive in-app and email notifications once the process is complete.

After successful import, the imported products will be listed on the All Projects tab in Zoho Sprints. You can access the projects and manage them as agile projects. A 'ServiceNow' label will be included with the project title for easy identification.

Field mapping from ServiceNow to Zoho Sprints

Terminologies

Zoho Sprints vs ServiceNow
ServiceNow
Zoho Sprints
Project (Product) 
Name
Short Description
Owner
Name
Description
Owner
 Item (Task)
Theme
Story
Scrum Task
Defect
Documentation Task
Enhancement

Story

Task

Bug
Task Priority 
Item Priority
Task State
Item Status
Users
Users with 'scrum_user' role
Project Users
Sprint (Sprint associated with a product stories)
Short description
Description
State
Start Date
End Date
Name
Description
State
Start Date
End Date

Release
Release State
Release Stage
Short description
Description
State
Planned Start date
Planned End date
Assigned to
Created by
Created on
Name
Description
Stage
Start date
Release date
Owner
Created by
Created on
Release comments
Release comments
Epic
Short description
Description
Created By
Created On
Name
Description
Created By
Created On
Epic comments
Epic comments

Work item (Task)
Short description
Description
Sprint
Epic
Release
State
Priority
Assigned to
Start date
End date
Created by
Created on
Name
Description
Sprint
Epic
Release
Status
Priority
Assignee
Start date
End date
Created by
Created on
Task hierarchy: Theme > Story > Scrum Task
Sub tasks 
Task comments
 Work item comments 
Task attachments 
Work item attachments

Remove authorization for ServiceNow import

  1. Click the gear icon at the top-right corner. The settings window will appear.
  2. Click Project under the Imports section.
  3. Click ServiceNow.
  4. Click the Remove Authorization button.
  5. Confirm your action and click Remove.