Forum Discussion

svella's avatar
svella
Regular Visitor
9 years ago

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...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi svella,

 

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

 

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. :smileyhappy:

 

Regards

svella's avatar
svella
Regular Visitor
9 years ago

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