JIRA REST API Tutorial - JQL Basic

preview_player
Показать описание
How to use JQL to do complex search in JIRA REST API. Example how to build up a valid JQL string and pull the JIRA search result to Excel sheet via JIRA REST API using Excel VBA.
Рекомендации по теме
Комментарии
Автор

Thanks a lot for this useful set of videos.. really helped me to put together a Jira REST API retrieval mechanism

prashantbala
Автор

Hi
Is there anyway you can highlight to pull the worklogs on the basis of dates and userID .
My devs are logging time in jira.
I want to set a cron job to get data on daily basis as per dates.
Please help

sachitsharma
Автор

What is the code for the rest call to fetch records more than 50? How do I paginate?

jammerules
Автор

This worked: ActiveSheet.Cells(i, 5) = Json("issues")(i)("key")

But this didn't work: ActiveSheet.Cells(i, 5) =

If I can figure out how to move around the data, this would work perfectly! I got a Run-time error '13', but now I am getting a Run-time error '5'.

Any help is appreciated. :)

bendains
Автор

Hi,
I'm running the code below, to extract the summary of a list of issue
ActiveSheet.Cells(j, 3) = Json("fields")(j)("summary")
but failed, Run-time error '13': Type mismatch is shown.
So, how should I correct it?

chaitengong
Автор

Hi,
may I know how to get the date on the status change like from Created > In Progress > In Review > Resolved > Closed?
For now, I just can get the created date and resolved date

chaitengong
Автор

Hi. I get a run-time error 424: object required

iamkonde
Автор

Hello Once again, Can you please tell me how to overcome Maximum count limitation?

iamkonde