Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,293,564
Community Members
 
Community Events
165
Community Groups

Jira Align Rest API - Filter Changes using Last Modified Date

Edited

In Jira I can use filters like this "updated >= -6m" In Jira Align I want to use a similar filter in the REST API.

When I try something similar in Jira Align REST API

/rest/align/api/2/Themes?$filter=lastModifiedDate%20le%20-5m

I get a 400 "Bad Request".

We could programatically create a string where we are using exact times.

Example: >= 2020-06-22T12:00 and <=2020-06-22T12:05

And then create code to update the time and date values every 5 mins.

UPDATE: After some more discovery, it seems that there is not a dynamic time feature for the rest APIs.  If someone does know of a solution, please do respond.

Since, we are using an ETL tool to pull the data, a single string is preferred.

I am currently reviewing this documentation:

https://agilecrafthelp.zendesk.com/hc/en-us/articles/360048085774-10X-API-2-0-GET-Usage-and-Filters

Swagger:  /rest/align/api/docs/index.html

These REST calls are working, but I want something more dynamic:

Date between specific times
/rest/align/api/2/Themes?$filter=lastModifiedDate%20ge%202020-06-19T12:00:00Z%20and%20lastModifiedDate%20le%202020-06-19T12:05:00Z

Date Between specific dates
/rest/align/api/2/Themes?$filter=lastModifiedDate%20ge%202020-06-01T00:00:00Z%20and%20lastModifiedDate%20le%202020-06-22T00:00:00Z

Date greater than june 1
/rest/align/api/2/Themes?$filter=lastModifiedDate%20gt%202020-06-01T00:00:00Z

1 answer

1 accepted

0 votes
Answer accepted
Jon Fowler Atlassian Team Jun 24, 2020

Hi Kyle, 

We have not implemented now() or any date math in the service yet. For now you will have to do this in your code that puts the url together.

Thanks,

Jon

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Align

Rockin' the Roadmap - How to make most of the Roadmap with Jira Align

The roadmap challenge for large scale agile enterprises Regardless of the agile framework you use, the agile enterprise has a massive scale with the challenge to connect hundreds of teams and thous...

2,454 views 7 24
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you