Eazybi rest api. Data from Jira apps are not supported.

Eazybi rest api I recently succeeded (with quite some help from eazybi support, thx for this) to import absences into eazybi jira cube through the rest interface of our absence management You can export one eazyBI report results in CSV format using REST API (https://docs. Here is another community topic on REST API result modification with JavaScript: eazyBI REST API data contains nest arrays. Fixed import of subtask measures when using Oracle. Unfortunately, I don’t have any examples. Since version 4. The “measure” values are in an array that you can iterate through and check the metric name. Since I am seeing an anomaly in my analysis I would l Tempo Timesheets. Large Jira data import using REST API is slower than import using Jira Java API. Unfortunately, I can not advise how to modify the REST API of other apps like Fiesta or what are alternative options to retrieve data from the Fiesta app. I And you can always reach out to eazyBI support if you have specific questions about creating the cube or mapping your data from an excel sheet. Home Import from REST API. I have placed a simple XML file on a Confluence page and used the link adress as the Rest path. Regards George We would assume that an endpoint is handling API keys within authorization headers, not the request body, and we have a dedicated authorization section for these. reporter: map as new dimension “Reporter” assignee: map as new dimension “Assignee” choose option Append row count measure where? (its Jira onPremise) Result: Given the JSON structure returned by the REST API, I would recommend using the path $. Here are some general rules of data mapping when creating a new cube. com Hello, I have a scenario in which the data is in the json file. Map your data columns as you want to use them in the reports to group data and aggregate quantitative values. See In addition, additional data can be imported from other data sources using REST API or SQL. 4) After saving new application you will be provided by Application ID and Secret. Create eazyBI dashboards. com - you Define a REST API source and retrieve parent issues using Get REST API request. The goal of this report is to track the velocity versus team hours (capacity) across sprints. I would like to create an eazybi You can also analyze and visualize your data from external data sources like SQL databases, Rest API, spreadsheets, and CSV files. If I create a separated account from API I’m successful in importing Is some limitation from eazby? Having two data sources? Is it possible to automatically delete old dimensions before the imports. It integrates with Jira through its Jira app, enabling users to harness eazyBI's powerful features for Jira data. ), each SQL Database, and each REST API source is a separate data source. what settings will i have to use here, to diplay Team Name, Role, User name and commitment Percent in rows? Right now i display only Team name and Users. Hi @MikeS, If you are using eazyBI on the Jira Server/Data Center, could it be that . please let me know how to import these data, thanks a lot! Annie Gao Uses Jira REST API to import Jira issues. googleapis. Training eazyBI data cube of Jira issues can help with some use cases for the Jira administrators but is insufficient for more advanced cases. REST API additional source application is available by default, but you It says that you will grant complete read/write access to the API, including all groups and projects. Tempo Timesheets The eazyBI community provides comprehensive documentation for those looking for more detailed technical instructions on how to set up this dashboard. Calculated measures and members. Create charts. @Danilo. Data mapping is the process where you assign “data columns” from imported data to Dimensions, Measures, and Properties of a multi-dimensional data cube eazyBI support data import from external data sources with REST API and SQL. Dashboards and reports visible to non-Confluence users I can't understand if you want to retrieve eazyBI report results via REST API, import data from a REST API source, or something else entirely Nevertheless, the two options I mentioned are eazyBI provides a report result export URL that you can use to execute the specified report and download the report results. Hi there, Since eazyBI version 6. com Hi there, We need a solution to import data from JIRA Insight. When you will save eazyBI settings then a database connection will be established and a database will be created. I tried importing this source and adding data to the worklog dimension but it does not Hi, Thanks for the clarification. 1 Like. com eazyBI provides a report result export URL that you can use to execute the specified report and download the report results: Note this export API works for retrieving a report data but does not work for a dashboard. Currently, you can’t have automated imports from Excel files. The implementation of additional data remains the same regardless of the data source (REST Wow thanks ! I was a little bit confused, I really appreciate your feedback ! eazyBI doesn’t have a native integration with BigPicture; thus there is no out-of-the-box solution, and currently, we don’t have exact plans on the roadmap to make this a default integration. Is there anything similar for the the general REST API import? The data source is Hi, I’m integrating testrail to the eazyBi using Rest API, and I’m a bit stuck with adding multi-value dimension. I’m trying to create a REST API connector to a SmartSheet with data I’d like to make use of in EazyBI. com/eazybi/set-up-and-administer/customization/report-results-export-api, but always receiving 404, even I have a Postgresql datasource that is brining in data that contains user id(s). com You may import data using SQL SELECT, REST API, or from Excel files, Google Spreadsheets, and source systems Jira, Highrise, Basecamp, Zendesk, Freshdesk, FreshBooks, Harvest, Monday. See attached image for more details. Data from Jira apps: eazyBI supports data import from several Jira apps. Please, contact support support@eazybi. If you have the Tempo Timesheets app installed then in eazyBI Jira import options tab Add-ons you will see Hi, I’m trying to get the JIRA Rest API to be a data source using OAuth 2. the eazyBI app was initially built for Jira Cloud using Jira REST APIs to create custom Jira reports and customized calculations @Gurumoorthi The Rest API to get TestCases is provided by another app vendor Smartbear. com key : map as new dimension “Issues”. For other tools with the same name, we have not heard about such a solution from our customers yet. Fixed potential infinite loop problem in REST API import if custom JavaScript code is used. Fixed several source data mapping problems for REST API, SQL, and file import. txt upload. The data that I bring in from sql contains User IDs however, I would like to be able report on User Name. Can EazyBI handle hierarchical (nested) JSON and JSON arrays or does EazyBI only support flattened JSON? Note that the JSON file has been tested with Postman Hi!, I’m currently working on activity reports in EazyBI and facing a challenge in identifying inactive users within our Jira instance. Hi EazyBI Community, Is there a way to import devops data (commits, merge requests, pipelines) from multiple gitlab projects and map it to correct Jira project, issues dimensions? Ideally, with one REST:API data source. component. The rest api pulls out the following data: Project keys Repos belong to Project keys Branches belong to each repo Branch count for each repo Repo size for each repo Branch Age (days since last commit was made) of each branch inside the repo Everything looks fine but, eazyBI recommended partners from all around the world. Hi @prepetti. eazyBI Demo account - report templates ready to use and get ideas on how to build reports. Training Demo account: SLA overview - Jira Service Management Demo - eazyBI. Hi, I am setting up a Data Source to a REST API. , 120 seconds: REST API. com with the Atlassian site and eazyBI account details to check the problem in more detail. Copy first one in Client ID field in eazyBI REST API definition and second in Client secret field. Regarding data import from REST API or other external data sources, there is no standard solution. best, Gerda // support@eazyBI. Please see the documentation and a training video for more details on those: Publish Reports. In Looks like it was being blocked by a squid proxy I didn’t realize was in-between. Currently, it only supports authentication using the Atlassian user email and API token. If you have shared the report with a public token then you can add the request Fetching Timepiece Data with REST API. com Kindly, Janis Hello all, Is there a way to access the raw data imported from an REST API source? I am aware that there are 30 records shown in a preview when doing a fresh import. as new feature there is: getDocument function in REST API import custom JavaScript code for requesting additional data from another REST API end-point. Check out the full list of supported eazyBI data sources . Martins / eazyBI. According to the Sprint reports for sprint week cycles guide, I need to add Jira as an additional REST API source application. I can visit the api end point via a browser - firefox and chrome and can see the valid json response. baiza September 29, 2023, 3:05pm 5. eazyBI is a powerful tool, providing easy-to-use drag-and-drop creation of custom reports, charts, and dashboard gadgets. I’m having trouble importing an XML file with EazyBI’s Rest API. com/eazybi/set-up-and-administer/customization/report-results-export-api, but always receiving 404, even REST API. eazyBI Community REST:API with POST to Monday. Or the CSV format in the REST API data import - Import from REST API. Slides: Power-up-reports-with-additional-data-import. Excel and CSV file upload. I’ve been using a Jira filter that works well, but I’m struggling to replicate the same functionality in EazyBI. This way you can import new measures and new properties to Issue dimension members. If you would like to allow REST API import or SQL import access to some IP addresses in the same local network, then specify the allowed I’m adding a source application of type REST API that needs authentication. eazyBI’s Jira data importer has a function “Import issue change history”, which enables historical measures in reports. "eazyBI" is in the tags because I'd eventually want to use eazyBI's REST API feature to pull data from Opsgenie. Make the request using Basic authentication for REST API with your Atlassian account email and API token. com/eazybi/set-up-and-administer/customization/report-results-export-api). S. Fixed connection to remote headless Google Chrome by ignoring proxy server settings. 3. Here are some rules to guide you through the data mapping ActivityTimeline REST API - in eazybi. The data mapping is guided by available data and the intention of how to create the data cube. The option to add Projectrak API keys will be available if Data import is similar to Excel and CSV file upload and Import from REST API. Map this column to some user dimension. An alternative is to use the integrated Jira data source, not REST API. In a second api I have the return in JSON but this time with idteam and team details. Learn More. The videos on this page explain how to import additional data to "Issues" cube or create custom cubes in eazyBI from different data sources. The example explained below is based on the REST Yes, you can import the scenario outline as a Test issue property with additional data import from REST API, file, or other available sources. eazyBI in Confluence pages. As I know there is no default solution, so I tried REST API import. 1 and on eazyBI Cloud there is an option to create a custom hierarchy in the Assignee, Reporter, Logged by, project and Sprint dimensions. Page view events (only new events available since eazyBI installation) Search queries (only new events available since eazyBI installation) REST API, SQL source application data import, CSV, Excel source file import. Hello, I am very new to eazyBI, I have a question related to brining in data from an external Postgresql data source. By utilizing built-in adapters, eazyBI can also import Timepiece - Time in Status for Jira data, providing a comprehensive Hi, I am using Rest API to export the report created in EazyBI. You can use postDocument function to request additional data pulled in by GET request with POST request eazyBI gathers data through optimized API requests that collect data as quickly as possible with minimal resource usage. I would like to have only the “real” dimensions present Example I import via rest api a “user” dimension that represents tempo timesheet users with their team I would like these dimensions to be updated with user deactivated and user reactivated. baranovska, Can u post a standar mapping for REST imports from JQL imput? I think it can be interresting. toml configuration file. Best regards, Jānis. On Is there a way to apply filter for Project/Board/Issue Type in the dashboard using a parameter in the URL, similar to such filter in REST API Report Export? We’re using On-Prem version of EazyBI for JIRA DC. Specify the "Jira Service Management Assets" REST API user email and API token granting eazyBI access to Assets data during import. I want to take these user id(s) and use the Jira REST API to look up the Jira user object so that I can pull more user related data into my repot. com eazyBI is a cloud-based Business Intelligence service that offers advanced data analysis and reporting across various platforms. But for now I'm trying to establish a connection. Problem is that seems that eazyBI import mechanism cannot import from hierarchical json? I see there is some Custom JavaScript code After registration, you will get your application Client ID and Client Secret - please paste them in eazyBI REST API source parameters page corresponding fields. When using eazyBI for Jira Cloud then use the Embed report action to see the account_id Power BI uses data connectors and Rest API for import. svante September 12, 2017, 10:17am 3 In addition, eazyBI can accept data from Jira apps, SQL databases, REST API and other data sources. To extract Timepiece data using its REST API, users must construct a REST API call that encapsulates all parameters of the Every application (Jira, Highrise, Git, etc. For example, a colleague of yours could know it enough to help you access the elements in the “conditions” array. REST API and SQL Incremental Imports. You can define additional import options both for REST API and SQL to identify changes in your data and then import only updates instead of performing a full data reimport. In eazyBI It seems to be a Jira Cloud-related API. With it, you can replicate one eazyBI account Jira source application import options and re-use them Hi @Manolo_RecheGiraldez. eazyBI uses optimized APIs to import large datasets from Jira reliably and significantly faster. You can import this attribute as additional property for any user with additional data import. I’m having trouble finding a way to get this to work. All Paws on Deck: Discover Data Mapping. A budget should be imported and mapped to custom field Cost Center and Time. Nevertheless, If you are interested only in pull request analysis, it might be possible to use the Bitbucket REST APIs and eazyBI REST API data source to get just that information that you are looking to analyze. ActivityTimeline REST API - in eazybi. eazyBI for sure will use only read-only access. You can also schedule regular daily import from the provided sheet. Each team has a different name for their first sprint (team a sprint 1, team b sprint 1, team c sprint 1, and team d sprint 1). A third table is populated with future sprints’ data (this table I have working fine). Edit your API and make sure that the offline access for your API is enabled, if not then enable it eazyBI supports GET requests with REST API source data import. In the report, Sprint dimension, choose to add custom hierarchy and select property “Weekly cycle” (Create reports). Martins / eazyBI support. 5: 1314: August 20, 2024 Issue Type and Issue Delete custom field values for bug issues. I wanted to let you know that we have released eazyBI version 6. There is no REST API for publishing reports. customfield_NNNNN] data_type = "text" Adjust the REST API source parameters (URL, authentification) to match your Jira instance (Import from REST API) Import data. Questions & Answers. After registration, you will get your application Client ID and Client Secret - please paste them in eazyBI REST API source parameters page corresponding fields. Please see the comments and commented examples for each section in this file. We want to calculate the count of reporter and such fields, based on strings in those fields. I. Maybe it could help me to import hierarchical data in two steps: simply import plain list of data without hierarchy (relations); using getDocument we could request additional relations for Hi EazyBI Community, Is there a way to import devops data (commits, merge requests, pipelines) from multiple gitlab projects and map it to correct Jira project, issues dimensions? Ideally, with one REST:API data source. eazyBI also supports data import from popular web applications like Highrise, Harvest, Zendesk, Git, Freshbooks, etc. You can use/define any of them. For my example, I have a Requirement Issue Type with which I have a linked Feature with the ‘relates to’ relationship chosen. This URL comes in as a relative URL but it is missing the first part of At this point, you should have an Auth0 REST API which you would like to import into eazyBI. Here are some general rules of Hey, I am using eazyBI for some licensing reporting. So what about other external sources such as Database, Rest API, file, etc? No problem, let’s connect to the world with external data sources. com. Confluence’s Rest API uses the _links. 89 Feb 2020 Hi @sefa. Thanks in advance, Krisztián. 2GB Storage. janis. Answer. I need to build a report with Test case key dimension as 1st column & option selected in the test cases on the 2nd column & also the count of test cases associated with the select list Hi, good afternoon, I’m new to EazyBI reporting. Providing expertise and support for eazyBI implementations and solutions. Hello, I would like to be able to get the “hours spent” approved and the “hours spent” not approved in eazybi. g. Fixed user authentication from an external OAuth provider when mixed-case emails are used. Kindly, Janis, eazyBI support To give you better ideas and to help you generate reports more efficiently, we've created several eazyBI Demo accounts containing report templates, samples, and calculations. , 120 seconds: I’m new to eazyBI, and I think this is not a trivial task unfortunately. gerdan , A warm welcome to the eazyBI community! JavaScript is pretty common knowledge. Check out the official list here. The problem I have is with the authentication parameters. Use the Fixed several source data mapping problems for REST API, SQL, and file import. then if you can find a way to access BigPicture data using Rest API endpoints or SQL selects, perhaps you can extend the Issues cube with The workaround is exploring the TestRail data import from their REST API or the database. That way, you would also have a key and name value to use as a dimension. In I tried to create a SmartSheet REST source and was successful with these settings: Test URL https://api. Now you should create a "Regular web applications" Auth0 Application for eazyBI. Ii tried with per page =100 and checked on the pagination option Hi @Ssun, If the REST API returns data for a single user, it is not convenient to have a separate data source for each user. I saw examples how to do it for a single pair of gitlab and Jira project, but curious to see if anyone achieved and have examples of single I’m trying to parse this REST API response: { "expand": "names,schema", "startAt": 0, "maxResults": 50, "total": 1, "issues": [ { "expand": "operations Import from REST API. kicas We don’t yet have a built-in GitLab DevOps integration. We included the support of POST requests for the REST API applications in this version. 77 Feb 2020,security,15. It is already developed integration. Also, I added your reference to an internal improvement request to enable monday. Welcome to the eazyBI community! Currently, there is no such REST API for audit logs. Do not fail import when empty custom JavaScript code is provided. Members, [CustomName Import data from external data sources like SQL databases, Rest API, Google Sheets, CSV, or Excel spreadsheets and include them in your Jira reports. Please see the JAvaScript example here: Import from REST API. e. I’ve added your vote to the ticket in our backlog for this idea, but there is no clear timeline if or when this will be implemented. 0 / Released Jul 17, 2024 New in this release: Audit log of report definitions, calculated members, access rights, and other changes. Now you should create a So i add a new source as rest api and now im stack at Cube and dimention page. Best, Zane / support@eazyBI. This problem with the getDocument may indicate that there are other problems also with the access of Jira REST APIs that may have effects on the data import. In this api I have the idmember and idteam values with member details. 6 recently. Later when additional eazyBI accounts are created, then each account data will be stored in separate databases with names eazybi_jira_dwh_N where N is the account ID number. ; report_id – ID of the eazyBI report (when you open the report in the Analyze tab, then visible in URL after /reports/ and before -). Indeed, there are problems exporting report specific calculated to XLS and CSV using Report results export API in the current version (6. Currently, eazyBI does not import the attribute “active” (and “inactive”) for any user dimension. Please see the Zephyr Scale documentation on the API what parameters it requires to retrieve data and what data on tests cases it returns: REST API (overview) | Zephyr Scale Cloud Documentation To access the data through Rest API, you might want to use the option “Offset is there a way to get EazyBI audit log entries by means of REST API calls ? Thanks Pierangelo. smartsheet eazyBI Demo account - report templates ready to use and get ideas on how to build reports. Regards, Oskars / support@eazybi. I Also, I added your reference to an internal improvement request to enable monday. For example In eazyBI for Jira Server/Datacenter and Private eazyBI, you can import source files automatically from a directory. Beyond the woefully slow import, the subsequent import indicates only a couple of top-level arrays that can be mapped. When I’m doing the data mapping some values are URLs that also needs authentication. Hello, I am a new EazyBI user and am having a hard time consolidating information from two rest apis and displaying it in a report. The XMLHttpRequest(); is not available in the eazyBI JavaScript for the source applications. 33 Feb 2020,UAT,2. Fixed access limitations in internal REST APIs to cubes, folders, reports and dashboards when data access roles are Hi EazyBI Community, Is there a way to import devops data (commits, merge requests, pipelines) from multiple gitlab projects and map it to correct Jira project, issues dimensions? Ideally, with one REST:API data source. Still you can explore the option to import the SonarQube data into eazyBI via REST API. Hi @rolandas. com I have created a scriptrunner custom rest api for importing the Bitbucket data to EasyBI. For the best performance, eazyBI recommends using the default data storage location in the EU (GCP Europe-West1 data center in Belgium) that has the best performance and scalability capacity. There could be an option for data import if Sharepoint can serve the files through REST API. The data source should contain two columns: issue key of a Test - use this column for data mapping to Power BI uses data connectors and Rest API for import. If the REST API returns data for a single user, it is not convenient to have a separate data source for each user. Nevertheless, there are workarounds on how to import values from the table in the custom field to eazyBI. rest-api-javascript. Import GitLab merge request information using additional REST API application. Hislop In my example, I used the “Username & password” Authentication type. The method is to generate a separate row for each account_id and product combination received with REST API, not a single row for each account. com/apis/library/analytics. Import data from external data sources like SQL databases, Rest API, Google Sheets, CSV, or Excel spreadsheets and include them in your Jira reports. The eazyBI community provides comprehensive documentation for those looking for more detailed technical instructions on how to set up this dashboard. Fix "result set is not updatable" errors in SQL import from MS SQL Server. Fixed detection of installed headless Google Chrome on Linux servers. I’ve added you’re vote to it and we’ll You should contact support for more detailed checking of why the host does not work in your case. 4: You can specify eazyBI advanced settings in the config/eazybi. Below solution works fine, but, we feel it is slower to calculate. I’ve got my (GET) API call working great from a browser, from Postman and everywhere else I’ve tried but EazyBI. Here’s what I’ve tried so far: In Jira, I’m using the following JQL filter to find inactive users: " assignee in (inactiveUsers()) AND Import from REST API. All data files together (XLSX, CSV) are considered as one data source. This is for filtering deactivated users based on a previous support question here: (Remove deactivated Assignees - #2 by Hi @Liam. As a data source I’m using a json file from a web service imported to eazyBI via the REST-API import. There under the host input will be visible IP list: image 1560×526 65. Please explore the eazyBI REST API data source documentation and try adding TestRail REST API endpoints as a data source - Import from REST API. Data import from integrated Jira data source supports issue custom field import (Data from Jira). Hi, The des url is supported post method only, how to import data thr rest api? and the same time I need send request data with json. Fixed in this release: Improvements and fixes for Jira localhost URL detection that is used for local REST API requests. You might want to get the following columns of data for the best results: a user name that has a vacation. All eazyBI products: Imported data Hi, Im trying to export my report using the docs. This might be a more elegant solution. google. But eazyBI supports several methods for sharing and publishing individual reports or dashboards (collections of reports) on Jira dashboards, web pages, and wallboards. How will be the standar mapping for columns key, summary, reporter and assignee? thanks. Is it possible ? Tempo provides a REST API “servlet/tempo-getWorklog/” which provides all worklogs with “jira_worklog_id” and approval status for each worklog. These videos cover topics explained on the documentation pages: Rest API or creating custom hierarchies. At this point, you should have an Auth0 REST API which you would like to import into eazyBI. If you have created already another similar REST API data source then you can export its definition and past Enable desired API's for your Google project. But JIRA Insight can export (using REST API) all objects with relations only in hierarchical json format. 5: 1314: August 20, 2024 Issue Type and Issue Hi @Ssun,. Will the getDocument function allow me to do this? I read this After registration, you will get your application Client ID and Client Secret - please paste them in eazyBI REST API source parameters page corresponding fields. etc. If I create a separated account from API I’m successful in importing Is some limitation from eazby? Having two data sources? Jira Cloud access. Use them separately or combine them with the Jira issues information! Dedicated eazyBI admins and Jira administrators are the most powerful roles in eazyBI. Specify Projectrak API key ID and API key from t he API integration page granting eazyBI access to Projectrak data during import. Please at first read about eazyBI cubes, dimensions and measures as well as the eazyBI Jira data model - you will need to understand the multi If the same REST API configuration and sprint property "Week cycle" mapping to the Sprint dimension is done, you may import / export available Sprint by weeks reports (burn-down, velocity, sprint balance) from the eazyBI Demo Training account and use them with your data! Then needed calculated members and measures will be imported as well. eazyBI Community Import Project Properties add-on custom fields. account_id – ID of the corresponding eazyBI account (visible in URLs after /accounts/). 1. Tempo Timesheets is a time tracking and reporting solution that seamlessly integrates with jira to help software, IT, service desk, and business teams and managers track time for accounting, payroll, client billing, enhanced efficiency, and forecasting. I need more information for consideration to initiate an idea in our backlog. All eazyBI products: Imported data from REST API, SQL databases, Google spreadsheets; Uploaded CSV, Excel files; I was wondering if there is an easier way to combine multiple teams sprints into one? For example, lets say there are 4 scrum teams in the project I am pulling in. The connection and data is working. . It also supports additional external data sources like SQL, Rest API, Google Sheets, Excel, and CSV, so you can analyze data from different sources and eazyBI is a Business Intelligence tool in a cloud. 1: 19: August 28, 2024 eazyBI REST API data contains nest arrays. com data import into eazyBI for Jira Data Center. Read more So i add a new source as rest api and now im stack at Cube and dimention page. For now, I have to manually delete all data and For the best performance, eazyBI recommends using the default data storage location in the EU (GCP Europe-West1 data center in Belgium) that has the best performance and scalability capacity. Hi, I’m evaluating eazyBI with respect to project monitoring. I am using EasyBI for Jira Cloud, and I use my Google account Hi, I am trying to pull data into my EazyBi for JIRA using the Confluence REST API. com (Replace secret with a chosen password). You can also see some examples on our documentation page - Import from REST API. Did you use your actual custom field ID instead of NNNNN? Does it work if you import the field as property with data_type = “text”? [jira. I don’t have pages in the report it’s a simple table with ~100K rows. Start a free 30 day trial, no credit card, no risk. Watch. Demo accounts. On Import from REST API. If you would like to delete some field values and do not import them in eazyBI then use undefined. The purpose of this field is to be able to show linked issues to a certain Issue Type. 2) of eazyBI. Cheers. Analyze & Visualize. The Since eazyBI version 6. ©2023 eazyBI All rights Hi, I am trying to add a source data from a REST API end point. If you will create several Google Analytics REST API sources in your eazyBI account then you can use the same Client ID and Client Secret for all these REST API sources. Authentication seems to work fine but the columns preview doesn’t It seems that eazyBI has a problem finding the Jenkins server. 0 as the authentication. If you use eazyBI for Jira Data Centero and wish to import custom fields provided by Checklist for the Jira app, you could find this thread useful. You might want to look for another REST API or data source to get data on user vacations. Some Jira custom fields might not expose all the necessary information in Jira REST API results. eazybi. Embed as iframe. I am currently trying to create an advanced custom field. There is more information about steps in data mapping in the topic of CSV data If network connections are allowed, please send eazyBI log files (Troubleshooting) to our support email support@eazybi. Is there an API available for doing this? We will of course use Template-Accounts, but there are some Features missing in this Templating Specify additional HTTP headers for REST API data import. Unfortunately, we haven’t studied enough this question and don’t have much to share about importing data from Snowflake using Rest APIs. Raimonds Simanovskis, CEO and founder of eazyBI, never wanted the company to be a typical startup. If the problem persists, please contact support@eazybi. com/eazybi/set-up-and-administer/customization/report-results-export-api, but always receiving 404, even Hi, At the moment there is no standard integration for importing AWS Cost Explorer data into eazyBI. We can work further from there. Then there are account-specific roles like report admin, user, and viewers. Now you can analyze the Confluence content from the viewer’s and the author’s perspectives. In order to access Analytics API, you have to enable it in your google project https://console. Any help is Late to the party (as always) I can't understand if you want to retrieve eazyBI report results via REST API, import data from a REST API source, or something else entirely Nevertheless, the two options I mentioned are achievable. This is why love our community. eazyBI uses Projectrak REST API for data import. Fixed support for dimensions containing a dot in the name. Have you ever tried to create a SQL source data querying the eazyBI DB ( also of another instance ) ? Or a REST API source data that has an url that correspond to an eazyBI report export ? What do you think about it? Do you thin is all possible on cloud? eazyBI does not have an integration with the iDalko Table Grid Editor custom fields. Publish Reports. One of my awesome colleagues pointed me to the DISPLAY_KEY property in the eazyBI data mapping - Data mapping. For columns, i have Time and Measures. The HTTP call will be made to the same REST API the data source is configured for, but to a different endpoint. Import your data from excel, CSV file, Google Spreadsheets or using REST API, or SQL select. The “Source File” does not seem to process the json files Are there alternate ways to do this ? Regards Balaji However, there is an option to use eazyBI report results export REST API which provides report results in different formats: Report results export API Probably, you can use this REST API to build your specific solution. Since I am seeing an anomaly in my analysis I would l I am trying to build a account in eazybi with two source applications: Jira and REST:API, but I can’t running import from API. Most of the reports are well within the limit of rest api response size, but I have few reports which exceeds the response size and i can only receive ~8000 rows after that I get some weird text written on the csv file. Using concurrent apis and the pagination. next property of the results to provide the URL of the next page. Power BI does not support incremental data import via Rest API or connector. I need to generate a single report with the data Import from REST API. Tips & Tricks. Only I am very new eazyBI and we have imported data from 4 different project using the Jira option, since we need to restrict the data by project, we are trying to use the Rest API To add additional source applications in eazyBI for Jira Datacenter add the following advanced settings. REST API documentation page I don’t find that it would be possible to run the query for more than 1 project simultaneously. Whether you’re configuring custom fields, integrating with the Easy Agile Program app, or importing data through the REST API, you can find all the guidance you need there. 07 Jan 2020,performance,10. Please see the REST API source data documentation page - Import from REST API. You can map data from different data sources using different data import options into one cube. Budget import. Best, Roberts // support@eazybi. In any case, if this tool has REST API, you may try to import data and map them to dimensions and measures: Import from REST API eazyBI Community discussion forums. eazyBI Community discussion forums. You should add the MySQL JDBC (Replace secret with a chosen password). eazybi, dataimport, javascript, jira. Best, I was wondering if there is an easier way to combine multiple teams sprints into one? For example, lets say there are 4 scrum teams in the project I am pulling in. REST API and SQL sources, data access roles. Fixed REST API OAuth2 authorization from Jira servers. Also I’m looking for a solution to delegate the Jira Admin role to a person however I’m concerned that I have in eazyBI I can help you with data mapping once data are retrieved in eazyBI. I’ve A nice point about Jira EazyBI is that aside from the Atlassian tools like Jira, you can also connect it to some add-ons like Insight, Tempo, Zephyr, Xray, and more. How this could be a solution for your use case? REST API or SQL SELECT to some database. Thanks for your replying, i have resolved it by developing rest api. Currently, I am going into the Sprint dimension and creating a new calculated I am trying to build a account in eazybi with two source applications: Jira and REST:API, but I can’t running import from API. Hi @MikeS, If you are using eazyBI on the Jira Server/Data Center, could it be that Fixed REST API OAuth2 authorization from Jira servers. ilze. I can pull the data I need and have the mapping all done but unfortunately I cannot find a way to get paging working. (by importing data from the original source using Rest API or SQL select as source applications). eazyBI supports additional data import to any existing default field dimension and single select custom field dimensions as properties or measures. Jira provides REST API to access the audit log records allowing the creation of many useful reports by importing the audit records in a custom data cube of eazyBI. For more details, see the I want to import the Sprint ID as a custom hierarchy for Sprint, in order to combine sprints from several team boards into one. Jira custom Hi, Im trying to export my report using the docs. I think the problem is multiple values I had tried it , but not working in eazy BI Hi Team, I have a select list custom field in Zephyr, i have imported it as as custom property in eazybi but i am unable to fetch the Test cases count associated with this single list field. dataimport, rest-api-javascript. Best, Hello, I am new to eazybi and with that comes many challenges :). To import all items from the checklist field, you could use this code in your advanced settings: (use Jira custom field ID instead of NNNNN in following codes) #all items as comma separated string from Checklist @Swapna_R. You should add the MySQL JDBC In the “Content Parameters” section, you can add JavaScript to modify the REST API result to make it more suitable for data mapping. The case is as follows: I have an api that returns JSON with team members. Any better suggestions to make it faster: Aggregate({ Filter( [CustomName Reporter]. I can create custom eazyBI code just for you where we are not setting the header for JIRA Licence REST API. 0: 3: December 5, 2024 How to calculate number of resolved tickets that were at specific statuses previously eazyBI has launched a new product on the Atlassian Marketplace—eazyBI for Confluence. REST API additional source application is available by default, but you can change default configuration parameters through advanced settings. Go to Source Data tab and Add new source application and select REST APIapplication type. You might read more about the REST API data adjustments here -Data adjustments using (Replace secret with a chosen password). eazyBI imports data incrementally, to further reduce the impact. eazyBI Community Tips & Tricks Getting Started Email Course. Edit your API and make sure that the offline access for your API is enabled, if not then enable it and press "Save". There you can see an example where a new column “full_name” is created by combining the columns “first_name” and “last_name”. Best, Ilze, support@eazybi. Appears that the proxy was I’m trying to parse this REST API response: { "expand": "names,schema", "startAt": 0, "maxResults": 50, "total": 1, "issues": [ { "expand": "operations Hi @knayak,. There is no standard integration in eazyBI allowing data import from Sharepoint files. com As I see in 4. Fixed database migrator when using Oracle and "Preserve original IDs". When importing data from a custom data source, the first Delete custom field values for bug issues. Automatic data import Automatic data import at a specified time every day. Fixed HTML injection via eazyBI macro parameters. Data protection. 7. This rest api end point is public and there is no authentication involved. In the case of Jira, The standard solution is to use Jira as the data source in eazyBI: Data from Jira. devops, rest-api-javascript, git. Please see a list of all changes: Changelog - eazyBI for Jira. Regards George I’m trying to create a REST API connector to a SmartSheet with data I’d like to make use of in EazyBI. eazyBI for Confluence macros for publishing local eazyBI reports and dashboards in Confluence pages. When you save eazyBI settings, then a database connection will be established, and a database will be created. I tried importing this source and adding data to the worklog dimension but it does not You can enrich the Issues data cube with additional data from external data sources, like files, REST API, or SQL SELECT to a database. Please at first read about eazyBI cubes, dimensions and measures - you will need to understand the multi-dimensional data model to be able to map source file columns to cube dimensions and measures. summary : map as property for the “Issue”. Then you can use this property to filter out active users only by creating a new calculated member which aggregates user dimension If network connections are allowed, please send eazyBI log files (Troubleshooting) to our support email support@eazybi. Unfortunately, eazyBI doesn’t have an option to manage eazyBI accounts, source data import options, and reports via command-line interface nor API. Appears that the proxy was Hi @knayak,. See more details on how to import data from REST API and how to map the data to eazyBI dimensions and measures in the eazyBI documentation page links below. Other options are Google Sheet data import - Google Sheets. , 120 seconds: eazyBI is a Business Intelligence tool in a cloud. com Useful examples of eazyBI reports, calculated members, data imports that you would like to share with other eazyBI users. pdf. Hi, as we must split our one big account into several smaller accounts (estimated 20-30) to have an acceptable performance of eazyBI again, we came across the problem of automating the creation of those accounts. Create reports. cloud. Dashboards and reports visible to non-Confluence users. getconnected. Currently, I am going into the Sprint dimension and creating a new calculated Hi, Im trying to export my report using the docs. Let me know if there is anything else we can help you with! best, Gerda // support@eazyBI. Thank you for this question. See more here: Import from REST API But you will need to find someone in the company who knows this server better and can help you with this REST API. The custom JavaScrpt code could look similar to the one below: Please replace the JIRA_BASE_URL as well as the following parameters:. Later, when additional eazyBI accounts are created, then each account data will be stored in separate databases with names eazybi_jira_dwh_N where N is the account ID number. See the eazyBI documentation page for more details - Import source files from directory. com eazyBI is a Latvia based company with an easy-to-use app for powerful visualization and project analysis in Jira. Use Custom JavaScript code with function postDocument to access all sub-tasks of each parent issue with custom field color to calculate the hottest There is no REST API for publishing reports. My question is: Is it possible to make a report from data obtained from two applications? In this case, I generated a cube with data obtained through a Rest: Api from JiraDesk, and another cube with JiraSoftware data obtained with the source application “JIRA”. 3. Refreshing the data requires a completely new I have a Postgresql datasource that is brining in data that contains user id(s). I am wondering if there is a way in eazyBI for me to use the User ID that I have from the external data source, which is also the Jira User ID, and I don’t have any examples specific to TestRail, but I can assist you with eazyBI-specific questions. Original field example: device_types: [1, 2, 3] I’ve mapped its ids and transformed them into string, resulting in: device_types_mapped: “Item 1, Item 2, Item 3” For my report, I need to have the ability to calculate a number of cases that have specific device When you import data from CSV or MS Excel files, SQL databases, Google Sheets or REST API, you will have to map your data columns to the eazyBI data cube so you could later analyze those data from different perspectives. I’ve added you’re vote to it and we’ll In Jira Cloud, eazyBI uses the "Jira Service Management Assets" REST API for data import. You can easily import REST Make the request using Basic authentication for REST API with your Atlassian account email and API token. Import from REST API; Data mapping Hello, I would like to be able to get the “hours spent” approved and the “hours spent” not approved in eazybi. 6, eazyBI now supports incremental data imports from REST API and SQL data sources. Feel free to explore them (authorization is not required): SQL, Rest API, and Google Spreadsheets Demo account; Sales (CSV) Demo account; Map chart Demo account Well, JSON object from JQL output via REST is standard, I believe there can be a minimal definition of an issue like “key,summary,reporter,assignee”. Hello all, Is there a way to access the raw data imported from an REST API source? I am aware that there are 30 records shown in a preview when doing a fresh import. Regards, Jānis Baiža. But eazyBI supports several methods for sharing and publishing individual reports or dashboards (collections of reports) on Jira With the getDocument function, you can pass a different path of the same BASE URL and the same header will be used as for the REST API call, so you can get additional I’m working on creating a report in eazyBI with data sourced from a REST API. All eazyBI products: Imported data from REST API, SQL databases, Google spreadsheets; Uploaded CSV, Excel files; I don’t have any examples specific to TestRail, but I can assist you with eazyBI-specific questions. The configuration file uses TOML format. eazyBI Community Topic Replies Views Activity; Importing Absences from REST API into Jira Cube. Tempo Timesheets I’m trying to create a REST API connector to a SmartSheet with data I’d like to make use of in EazyBI. The best option to get the eazyBI Cloud IP address list is to create an empty REST API application. 2. How this could be a solution for your use case? You can do this with additional data import from Google Sheets, XLS file, REST API or SQL SELECT to some database. Training Attempting to import a hierarchical-structured JSON file via the rest get method. Thank you for noticing and reporting this. eazyBI does not have integration with Bitbucket and only git log file format will be recognized in the Source file . Another burn down is populated with the most recent sprint for that board. Importing large numbers of Jira issues can be unreliable and slow. showing the current number of users in my Atlassian instances. If you want to give a try for that, please write back to support@eazybi. leite July 2, 2024, 2:28pm 2. Please post some examples. Please see the eazyBI documentation page about importing data from REST API or SQL data sources. However, I need to make an additional HTTP call for each row I processed to get additional data. Data import from REST API is similar to Excel and CSV file upload, except you don’t have to export your data before importing it into eazyBI. Create eazyBI REST Application Here is another community topic on REST API result modification with JavaScript: eazyBI REST API data contains nest arrays. com Hi How do I get more than 1000 records using rest API in eazy I import. eazyBI doesn’t have a native integration with SonarQube. If the REST API needs longer to return the result, you can change the default timeout parameter for rest_api from 60 seconds to, e. REST API. In Jira Cloud it would be: Import Your Data from REST API and Create Compelling Reports. You should add the MySQL JDBC Solved: Hi! I'm trying to get familiar with using Opsgenie's APIs ( the alert APIs in particular ), and I haven't been able to get any results at Products Groups P. 1 KB. Start 30-Day Free Trial eazyBI support data import from external data sources with REST API and SQL. a Unfortunately, there is no REST API endpoint to call and trigger the import. Power Hello, I am a new EazyBI user and am having a hard time consolidating information from two rest apis and displaying it in a report. GetConnected provides tailor-made solutions based on the Atlassian suite, starting from client needs and managing projects from initial analysis to You could either upload a file, import data via REST API, or SQL, or use Google Sheets in the same way. eazyBI is hosted in the customer's infrastructure and the customer is responsible for data protection controls including but not limited to: data backup and recovery, user accesses and roles administration and maintaining the security of Hi, We are using eazyBI REST APIs import for pulling JSON bug data. Training Ultimate goal: have a shared Pages filter on a dashboard where board is selected, then a burn down chart is populated with the active sprint for that board. Hey guys @Marlen_Arias, @zane. One thing that could come in handy is the Jira Source application definition export and import. Here are several reports in eazyBI Demo Training account created based on this custom hierarchy: However, there is an option to use eazyBI report results export REST API which provides report results in different formats: Report results export API Probably, you can use this REST API to build your specific solution. Data from Jira apps are not supported. it. Hi, I am trying to import data thr rest api, response json as below, please help to get the datas for “row_positioins” field and “values” field, thanks a lot Below are the target data trying to be imported: date,projectCategory,testDelivery Jan 2020,UAT,1. hfuhexav fcbj llwx wea jzrjy zzw vsshdjj iukl xmydx eodmk