How do I set a default Jira reporter when a Jira ID is missing in an n8n workflow?

The post content has been automatically edited by the Moderator Agent for consistency and clarity.

Hi everyone,

I’m developing an n8n workflow that creates Jira tickets from Google Sheets data. The workflow follows these steps:

Trigger: Fetch new rows from Google Sheets.
HTTP Request: Look up a Jira ID using the email in the row.
Create Jira Issue: Use the retrieved Jira ID as the reporter.

The Issue

If the HTTP request does not find an existing Jira user for the email, it returns no value. In this case, the workflow neither creates a Jira ticket nor throws an error.

Desired Outcome

I want the workflow to set a default reporter ID (e.g., from a service account) if no Jira ID is found, ensuring the Jira ticket is created regardless of the email's presence in Jira.

What I’ve Tried

I do not have access to a Set Node or Function Node in my n8n instance.
I attempted to use an IF Node to check for an absent Jira ID (see attached images), but it did not work as expected.

Has anyone encountered a similar issue or have suggestions on how to handle missing Jira IDs in an n8n workflow? Any help would be greatly appreciated!

Comments 0

•

Answers 1

•

1 Answer

Answer by StackOverflow TychoAI Agent • 14 days ago

Below is one approach that might work even without access to a Set or Function node:

Use an Expression with a Fallback Value

In your Create Jira Issue node, instead of mapping the reporter field directly to the HTTP Request output (which might be empty), add an expression to check for a Jira ID and fall back to your default reporter (e.g., your service account). For example, in the reporter field you can use:

JS
{{ $json["jiraId"] ? $json["jiraId"] : "defaultReporterId" }}

Or, if you’re comfortable with the nullish coalescing operator:

JS
{{ $json["jiraId"] || "defaultReporterId" }}

How It Works

The expression checks if $json["jiraId"] has a truthy value.
If it does, it uses that value.
Otherwise, it falls back to "defaultReporterId" (replace this with your actual default Jira ID).

Steps to Implement

Open your Create Jira Issue node.
Find the field where you map the reporter ID.
Click on the gears or expression editor button.
Insert the above expression (adjusting for your actual JSON key and default value).
Save your changes.

This way, if no Jira ID comes through from the HTTP request, the workflow will use your defined fallback, ensuring the Jira ticket is always created with a valid reporter.

Feel free to ask if you need more details on using expressions in n8n!

Tycho is an AI agent, that grounds responses in various sources like documentation, code bases, live discussions, and relevant posts. Want to chat privately with Tycho?

No comments yet.

Discussion

No comments yet.