OneFeed documentation

OneFeed turns any Jira query into a live data feed for Power BI, Excel, Tableau and Google Sheets. One app covers every BI tool.

Quick start (2 minutes)

  1. In Jira, open Apps → OneFeed and click New feed.
  2. Give it a name and a JQL query, for example project = ENG AND created >= -365d.
  3. Choose datasets: Issues, Status changes, Worklogs, or any combination. Add any custom fields you want as columns.
  4. Click Create feed. Copy the key now: it is shown only once.
  5. Paste the connection URL into your BI tool (steps below).

Connect your BI tool

Power BI (Desktop or Service)

  1. Get data → OData feed.
  2. Paste the feed URL shown in OneFeed (it ends with the feed ID).
  3. When asked for credentials choose Basic. Username: onefeed. Password: your feed key.
  4. Select Issues, StatusChanges and/or Worklogs in the navigator and click Load.
  5. Set up scheduled refresh as you would for any OData source.

Tip: do filtering in the feed's JQL, not in Power Query. If Power Query sends a filter to OneFeed you'll see "$filter is not supported"; remove that step or move the condition into the JQL.

Excel (Windows and Mac with Power Query)

Data → Get Data → From Other Sources → From OData Feed, paste the feed URL, choose Basic authentication (username onefeed, password = feed key).

Tableau

Connect → OData. Server: the feed URL. Authentication: Username and Password (username onefeed, password = feed key).

Google Sheets

Paste the formula from the Google Sheets tab in OneFeed into cell A1, for example:

=IMPORTDATA("https://…?feed=<id>&entity=Issues&format=csv&key=<key>")

The first time, Google Sheets shows "Warning: Some formulas are trying to send and receive data from external parties". Click Allow access and the data loads.

Google Sheets refreshes IMPORTDATA about every hour. Anyone who can open the sheet can see the URL, including the key, so share the sheet only with people who may see the data.

In CSV and Google Sheets, date-time columns (Created, Updated, Resolved, ChangedAt) are written in UTC as YYYY-MM-DD HH:MM:SS and date columns (DueDate) as YYYY-MM-DD, which Sheets recognises as dates automatically. They arrive as real dates in UTC, so they sort and filter correctly. Google Sheets may display them as numbers such as 46292.78. Select those columns and choose Format → Number → Date time to show them as dates.

Looker Studio

Connect Looker Studio to the Google Sheet above.

Anything else (CSV)

Use the URLs on the CSV tab. Any tool that can read CSV from a URL works.

Datasets

Issues (one row per issue)

Key, IssueId, Project, ProjectName, IssueType, Status, StatusCategory, Priority, Summary, Assignee, Reporter, Created, Updated, Resolved, Resolution, DueDate, Labels, Components, FixVersions, ParentKey, TimeSpentHours, OriginalEstimateHours, RemainingEstimateHours, plus the custom fields you select. Number and date custom fields keep their types; column names follow the Jira field name (spaces become underscores).

StatusChanges (one row per status transition)

IssueKey, IssueId, Project, TransitionIndex, FromStatus, ToStatus, ChangedAt, Author, HoursInFromStatus. HoursInFromStatus is the time the issue spent in FromStatus before this transition (from creation for the first transition). Use it for cycle time, lead time and bottleneck analysis.

Worklogs (one row per worklog)

WorklogId, IssueId, IssueKey, ProjectKey, AuthorAccountId, AuthorName, Started, TimeSpentSeconds, TimeSpentHours, Created, Updated. TimeSpentHours is TimeSpentSeconds divided by 3,600, rounded to 2 decimals. The rows cover the issues your feed's JQL returns. Worklog comments are not included. Worklogs that are restricted to a group or project role in Jira are never included, in any feed, so a feed cannot show time entries that Jira hides. Use it for time reporting by person, project or week, for example total TimeSpentHours by AuthorName and month of Started.

Security and permissions

Limits

Troubleshooting

MessageFix
401 Missing or wrong feed keyUse Basic authentication with any username and the feed key as password, or check the key= in the URL. If the key was lost, click New key and update your BI tool.
402 subscription neededA Jira admin can start a trial or subscription in Manage apps.
404 Feed not foundThe feed was deleted. Create a new one.
501 $filter is not supportedRemove the filter step in your BI tool, or put the condition in the feed's JQL.
Issues are missingFeeds created by non-admins include only projects the creator could browse when saving, and never issues with a security level. Ask a Jira admin to save the feed.
Sheets shows "Resource at url contents exceeded maximum size"Split the feed so each returns fewer rows.
Sheets shows dates as numbers (for example 46292.78)Select the date columns and choose Format → Number → Date time. The values are correct UTC dates.

Pricing

Free for up to 10 users. $1.00 per user per month for 11 to 100 users, with lower per-user rates above 100. One subscription covers every BI tool. 30-day free trial.

Support

Email hello@selana.io. We reply within one business day. OneFeed is built by Selana Technologies LLC.

Guides