David Nickell Expert

I think I understand... In my case, I have an org that has a relationship with Atlassian. In this case, I am a one-man show and have the domain splitdimedata.com. As the admin for SplitDimeData@Atlassian, I could say my users can't use API tokens, That's my read. If i am way off, please let me know and thank you for the…

I appreciate your warm response. you can shoot me an email if you want a ready to use .pbix. All you will need is a URL and an API key (and 5 minutes ago I documented that process in another thread). or you can add me (dnickell@splitdimedata.com) to your installation and I'll run a report for you. There would be no charge…

I may be missing something or using the wrong terms. But I just created a token a minute ago and it works fine.... * go to the API Token screen of your profile with Atlassian (Under security): https://id.atlassian.com/manage-profile/security/api-tokens * Generate a token and grab the resulting string * Encode it with your…

step 1 - get a list of your projects, api-rest-api-3-project-search-get Step 2 - loop through the projects to get the versions -api-rest-api-3-project-projectidorkey-version-get If you do this in Excel or Power BI, you can get something like this: There may be other variations of these api calls you wan to use, but this…

you may find some help here: api-labels-id-pages-get if you are comfortable with REST APIs and Pagination, you would have to execute this a few times (since you can only get 250 pages per executions).

I know I sound like the REST API Avenger ;-) ...more specifics on what you want to accomplish would be helpful. One way to do this is schedule a pull of all tickets meeting your criteria at whatever frequency you need. For example, I have a client that has their data refreshed 3x a day. But if you wanted an hourly recap of…

I am truly glad you asked because WORKLOGS is one of my more satisfying REST API uses. My "Canadian Client" reports time in JIRA by Story and has some great reports when it comes to Work Completed. They are also meticulous when it comes to estimating their effort. The "problem" in my view is pre-assigning people to…

Thanks for the encouragement :-) 

I took some records out of Gist #1 and did the import without any issues.... Some Important Notes: * I only used the Start Date column. (being lazy, I already had that test more or less ready) * And I used the task column as the Summary. You have to have a summary field. * Date format used was M/d/y I noticed when I pulled…

Good morning. Please understand I just want to help and I’m not trying to make a hard sell here. So I won’t mention the rest API again On this topic beyond this comment on this ticket. But the API’s are built-in features you have access to already. They are well documented by Atlassian. And, they are free. So I guess it…

With the REST APIs there are there with all kinds of possibilities. If the application you want to integrate with also supports REST (like ServiceNow does), its pretty straight forward to have each application notify another on an event. Here's a trick that may save you some time..... if you figure out how to trigger the…

This was so much tougher than I thought it would be ... but I have a (verifiable) answer. I tried many times to get the the CSV to honor the suggested format but no matter what I did, the date was still stored in a format Excel preferred. I finally decided to see if I could get Jira to understand the Excel format. So -- in…

Your Template should be in the Templates Section of your Space Settings. It can have whatever content you want. When the Rule in Jira fires, it will take your template and add a page under the parent you specify. I don't know if you can then move it to a folder automatically... but the steps I've outlined here are I helped…

here's an answer I would personally need an extra cup of coffee before I tried it. As comfortable as I am with the REST calls, this one may exceed my technical comfort zone. Confluence also has APIs If you have massive amounts of content to move (e.g pages), you may want to look into the "Gets" and "Puts" along with some…

So I looked at my first answer and then some of the others and realize I was giving you an "down in the details" solution without a clear indication of the possibilities. I am colorblind so if the follow looks hideous, I apologize up front. I added a new tab to the BI Solution I've started sharing here: (feel free to…

I'm not clear on your issue (sorry). I think you are saying you have all your attachments from the past month, but only data that is a month old in a snapshot database. The attachments (working from memory here) are in folders on your server with names the same as the issue they belong to (I think). But I cannot imagine…

As a GET call, you can troubleshoot in your browser. I just ran this call against my instance and it worked as expected: https://splitdimedata.atlassian.net/rest/api/3/search?jql=Project=GTMS2&maxResults=20&startAt=0 Have you used your REST call before? I can get close to your response (ID only) if I add the "&fields=id"…

And I'm not trying to add to any sales pitch - this Power BI is running in my own environment and this copy of the report holds 4,100 issues which represents all the tickets in the COMPASS, JRACLOUD, and JSDCLOUD projects that were updated in the past 30 days. it takes about 30 minutes to complete all the REST calls and…

I have connect the API for change logs with Power BI (and would work for Excel too)... I actually posted screenshots late last week as someone wanted to gather time in status metrics (as I recall). Here are those screen shots. The process would work the same for any field in the system. You can see the screen shots below…

Let me start by saying "I do not have an answer -- only some intuition" Are we talking about PARENT or PARENT LINK? I am also showing EPIC LINK below because that is how old school I am: Since the Parent Field is engrained in JIRA as you mention, I wonder if this check box on the CREATE transition validator is a factor:…

Not to go too far off topic -- but your comment and questions are great! I recently set up my first JSM Project and Portal and prompting users reporting bugs (or questions in this case) to provide the level of detail you mention is vital to investigating an issue. That said -- maybe a "Form" like concept or "Template" can…

You might first double check the account id (or have that person do it for you with the rest MYSELF endpoint). Otherwise, I don't know the answer but I know where to look.... if you are comfortable with Postman, the libraries are linked on the API document page. My guess is you can get a clean "body" format there 

REST REST REST :-) ..... I might approach it this way.... * Sprints are tied to boards * Boards are located in projects This Endpoint Gives you all the boards: https://splitdimedata.atlassian.net/rest/agile/1.0/board This one gives you all the sprints per board…

The REST API (or maybe even just the issue navigator) could be your friend here. Step 1. Create a filter (or JQL) for Q4 2023. Step 2. Create a filter (or JQL) for Q4 2024. Step 3. Export the issues either with the Issue Navigator (if not too many) or using the REST API call : yoursite/rest/api/3/search?jql=filter=10000.…

As normal, my answer will lean heavily on the REST APIs. In particular, I use the REST APIs in Power BI and I am able to see the data from multiple instances in the same Power BI file. The trick is (1) dynamic URLS and (2) appending a site key in your API results. In the 1st screen shot I am showing the Project List for…

1. If this is something you know you will be doing regularly, you should be able to create an automation rule based on the issue moved trigger. 2. If you prefer to be more "hands on" in the process, you could set up a new status on sending side and then transition to the status before your move. The benefit here is you…

I use that feature all the time in CONFLUENCE but never knew it was available on issue comments. I will start using it now that I see it. That said I notice I can't use panels in this reply because the editors between issues and confluence are different. Issues Confluence my last bit of research, there is a recently opened…

it just occurred to me -- I could publish the Power BI for all to see. So here it is. Feel free to play with it all you want and then let me know if you want to take next steps: REST API Change Log in Power BI

Timing is everything :-) ... I just added a screenshot to my website on this very topic. While I haven't done the METRICS coding yet, it will be easy (and yes, basically free) using the REST API Calls that are done and working. By extracting the change log for an issue, you will get every modification of every field. You…

always like to see a REST API solution :-). Since these are GET calls, you can submit them in a browser. you might need three calls as follows: 1. Search fields based on the name. In your case you will use your URL and the term "Domain". These are all case sensitive so be sure to spell it correctly…