I am downloading Jira details into Excel using power query. I am struggling to get all the fields.

[adrian_slater]

I have no idea how to specify all the fields that I want.  Is there a way to request all fields?

Currently using "fields=summary,description,benefit".  I need more though.  I have a filter that specifies the fields.  Can I use this filter in the JQL and then request all fields somehow?

[Mohamed Benziane · Accepted solution]

Hi,

By default all field are returned if you're using the Get Issue API

Can you tell us which endpoint are you using ?

[adrian_slater]

Hi Mohamed

I connect using this:

Json.Document(Web.Contents("https://mydomain.atlassian.net/rest/api/3/search/jql?jql=project=IOP AND status != DONE ORDER BY created DESC&fields=summary,description,benefit"))

which loads the data into power query, but not all the fields that I am after. 

From which applications can I call Get Issue?  Ideally I wan my results to end up in Excel

Thanks

[Mohamed Benziane]

Hi,

It seeams that you're using this endpoint : The Jira Cloud platform REST API
So you replace :

fields=summary,description,benefit

by

fields=*all

[adrian_slater]

Hi, 

Thanks - the answer makes sense and the syntax works.  You have answered my question.

I guess I have a different problem because with fields set to all, it does not return all fields.

Is there a better way to get the data than what I am using?  I know I can download from Jira to Excel via a filter, but I was hoping to just refresh a query in Excel to update.

Thanks for the info to date.  Really useful.