Jira to ServiceNow Integration - How to Get Jira Space/Project Information in Worklog Events for Tim

[Mohan Reddy]

Hi Team, 

I am working on an integration between Jira and ServiceNow to automatically create Time Cards in ServiceNow based on the hours logged in Jira.

Current Setup

• Projects are initially created in ServiceNow.
• During project creation, a corresponding Jira Space/Project is created through the integration.
• Under the Jira project, users create and work on:
  • Epics
  • Stories
  • Tasks
  • Defects

Business Requirement

When a user logs work hours in Jira:

1. The worklog should be sent to ServiceNow.
2. ServiceNow should identify the corresponding Project.
3. A Time Card should be created against the same Project in ServiceNow.
4. Logged hours should populate the Time Card automatically.

Issue

I need the Jira Space/Project details when a worklog is created.

I noticed the following behavior:

Working Scenarios

When the following events occur, I can see the Jira Project/Space information in the payload:

• New Epic creation
• New Story creation
• Comments added to an issue
• Issue updates

Problem Scenario

When a Worklog Created event is triggered:

• The payload contains worklog details.
• I am unable to get the associated Jira Space/Project information directly.
• Without the project information, I cannot map the worklog to the correct ServiceNow Project and create the Time Card.

Questions

1. Has anyone implemented Jira Worklog → ServiceNow Time Card integration?
2. How do you retrieve the Jira Project/Space details when a worklog event is received?
3. Is there a Jira API that can be called from the worklog event using the Issue Key/Issue ID to retrieve the related Project?
4. Do I need an additional lookup from:
   • Worklog → Issue
   • Issue → Project/Space before creating the Time Card?
5. Are there recommended best practices for maintaining the relationship between:
   • ServiceNow Project
   • Jira Project/Space
   • Jira Issues
   • Jira Worklogs
6. • Has anyone implemented Jira Worklog → ServiceNow Time Card integration?
   • How do you retrieve the Jira Project/Space details when a worklog event is received?
   • Is there a Jira API that can be called from the worklog event using the Issue Key/Issue ID to retrieve the related Project?
   • Do I need an additional lookup from:
     • Worklog → Issue
     • Issue → Project/Space before creating the Time Card?
   • Are there recommended best practices for maintaining the relationship between:
     • ServiceNow Project
     • Jira Project/Space
     • Jira Issues
     • Jira Worklogs

[Viswanathan Ramachandran]

hi @Mohan Reddy 

I believe this is common design limitation with default worklog_created webhook payload.Have you tried/considered the following options?

• URL Parameter Substitution in Jira Webhook?
• or Enrich the Payload using Jira Automation ?
  • set webrequest URL to ServiceNow rest api endpoint
• or Fetch the Issue/Project via Jira REST API in ServiceNow (Backend Callback)

  • Extract the issuedetails from the worklog_created incoming payload.

  • Trigger an outbound HTTP call from ServiceNow to Jira's REST API
  • Parse the returned JSON to extract your fields
  • Create the ServiceNow Time Card using the fetched project details