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)
- In Jira, open Apps → OneFeed and click New feed.
- Give it a name and a JQL query, for example
project = ENG AND created >= -365d. - Choose datasets: Issues, Status changes, Worklogs, or any combination. Add any custom fields you want as columns.
- Click Create feed. Copy the key now: it is shown only once.
- Paste the connection URL into your BI tool (steps below).
Connect your BI tool
Power BI (Desktop or Service)
- Get data → OData feed.
- Paste the feed URL shown in OneFeed (it ends with the feed ID).
- When asked for credentials choose Basic. Username:
onefeed. Password: your feed key. - Select Issues, StatusChanges and/or Worklogs in the navigator and click Load.
- 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
- Every feed has its own secret key. OneFeed stores only a SHA-256 hash of it. Use New key to rotate a key; the old key stops working immediately.
- Jira admins can create feeds over any project and see and manage every feed on the site.
- Other users can create feeds only over projects they can browse at the time they save the feed. Issues with an issue security level are always excluded from their feeds.
- Worklogs restricted to a group or project role are never returned by any feed.
- OneFeed stores no Jira issue data. Data goes straight from Jira to your BI tool when the tool requests the feed URL with a valid key.
- OneFeed runs on Atlassian Forge. It has read-only access to Jira.
Limits
- Large feeds are paged automatically for OData clients (Power BI, Excel, Tableau): about 2,000 rows per page.
- CSV and Google Sheets responses return up to 25,000 rows. For larger datasets, split into several feeds (for example by project or year) or use OData.
- Filtering and sorting happen in the feed's JQL. OData
$filter,$orderby,$expand,$applyand$searchare not supported.$topworks for previews. - Up to 50 feeds per Jira site.
Troubleshooting
| Message | Fix |
|---|---|
| 401 Missing or wrong feed key | Use 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 needed | A Jira admin can start a trial or subscription in Manage apps. |
| 404 Feed not found | The feed was deleted. Create a new one. |
| 501 $filter is not supported | Remove the filter step in your BI tool, or put the condition in the feed's JQL. |
| Issues are missing | Feeds 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.