Using a query as a parameter as a URL part for a data query

[PaulN]

Hi all,

I have been reading posts related to using parameters in a query URL (to a web data source) but none of them do what I want to do.

Let me explain my predicament.

I'm building a PowerBI report for Jira, I've created a dashboard to show KPI's related to the current sprint. This works great, I can use the openSprints() function in Jira to make sure I always get the current sprint. This makes it dynamic and maintenance free What I did was to use the "printable" export of the Issue Navigator as a data source (using a saved query):

https://agile.someurl/sr/jira.issueviews:searchrequest-printable/35420/SearchRequest-35420.html?tempMax=4000

jquery for my saved query is:

sprint in openSprints() AND project = PROJ AND cf[14313] in ("MyTeam") AND type = "Solution Story" ORDER BY rank ASC

So far so good.

Now I want to do the same for the next sprint, to help with sprint planning and communicating to stake holders.

Now I want to build a "next sprint query" where the sprint name of the next sprint is calculated based on the name of the current sprint (which was returned by my "current sprint query"). So I have built yet another query which returns the current sprint (from my first query), transforms that to replace the last characters (numbers) with one higher and that is then the name of the next sprint. The name of the next sprint is returned as a single value. I then want to use a parameter in the "next sprint query". This parameter uses the query that returns the next sprint name.

The sprint name is part of the query URL that I use for the "next sprint query":

https://agile.someurl/sr/jira.issueviews:searchrequest-printable/temp/SearchRequest.html?jqlQuery=sprint+%3D+"[sprint name]"&tempMax=4000

However, when I try this, I get the following error:

Formula.Firewall: Query 'Query1' (step 'Step1') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

I can't rewrite this to not get the formula firewall error (or at least I don't know how). So my question is simple: how can I make this work? I don't want/need to use a parameter but I think this is the only way to get it to work, except that it doesn't work  

Thanks in advance for your help!

/Paul

[Anonymous]

Hi @PaulN ,

I think it may related connector security setting so it no allow you to use external query string on url string.
In my opinion, I'd like to suggest you use move these query string to httprequest header.

OAuth2 REST API as data source

Regards,

Xiaoxin Sheng