cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
svella
Regular Visitor

Slim down a data pull from jira

Hi,

 

Looking to slim down the search query to jira via the solution everyone is currently using.

 

It seems to pull all records and in my case its in the millions.

 

Can I some how isolate and match a search query I would do in Jira ?

 

Is it a matter of me using a differnt URL with the ssearch query in the url ?

 

Currently if I try to change the url with any aditional syntaax, it errors out.

 

thanks.

3 REPLIES 3
Lipin
Regular Visitor

Hi @svella - Did you find any approach to filter the issues for a particular project or criteria instead of pulling all the issues?

And can you also please provide me the format of the url used please?

 

As part of my project I tried using the url (e.g. - https://jira.companyname.com.au) and I am continuously receiving the following error

 

An error occurred in the ‘FetchPage’ query. DataSource.Error: Web.Contents failed to get contents from

'https://jira.companyname.com.au/rest/api/2/search?maxResults=500&startAt=0' (502): Proxy Error
Details:
DataSourceKind=Web
DataSourcePath=https://jira.companyname.com.au/rest/api/2/search
Url=https://jira.companyname.com.au/rest/api/2/search?maxResults=500&startAt=0

v-ljerr-msft
Microsoft
Microsoft

Hi @svella,

 

Could you try the M query below to see if it works in your scenario? Smiley Happy

 

let
    FetchPage = (url as text, pageSize as number, skipRows as number) as table =>
    let
        //Here is where you run the code that will return a single page
        contents = Web.Contents(url&"/rest/api/2/search",[Query = [maxResults= Text.From(pageSize), startAt = Text.From(skipRows)]]),
        json = Json.Document(contents),
        Value = json[issues],
        table = Table.FromList(Value, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
    in
        table meta [skipRows = skipRows + pageSize, total = 500]
in
    FetchPage

In addition, the Content Pack for Jira PBI Desktop is for your reference. Smiley Happy

 

Regards

Hello,

 

Thanks for your response. I am a bit confused. This looks like the same sample I am using from the content pack. 

I am running the full content pack but the minuite I apple the solution, it starts polling the whole jira site and downloading all entires. I am looking for a way to target that seacrh and limit it. For example I have 500 clients with jira tickets, I want to pull just 1 client.

I am guessing its a matter of changing the syntax for the search but not sure how to.

 

Does this make sense ?

 

thanks

shane

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Kudoed Authors