Updated since filter

Hello,

I believe the referenced answer is still the case.

One suggestion would be to add the ‘newest_first: true’ attribute. While not exactly what you were looking for you should be able to achieve your goal. You’d have to update the limit and possibly paginate until you come across a data point that is before your last request.

query {
      items (newest_first: true) {
        id name updated_at
        
      }
    }

Yeah, but I guess it would not work. Let’s say I have an item that was created one year ago and has just been updated. It would not be considered by this filter newest_first. I would still need to get all items from board and test for the updated_at anyway.

Hello @Samuel and welcome to the community!

I hope you like it here 💪

Indeed that is the case. You can not use a parameter to filter using the update date as a criteria.

Having said that, I have added your case as a vote into a request for this feature.

Let us know if you have any other questions!

Cheers,
Matias

Hi @Samuel, I also shared your question and found that there is an indirect workaround available, if you query Activity Logs, which does have a timestamp argument, and then parse the item IDs from the response, as described here, see also the example below.

@Matias.Monday please also add my vote for Monday to provide this feature directly. It encourages inefficient use of computational resources on both sides, and it is unusual for an API not to offer this feature. It presents an obstacle to the timely and frequent synchronisation of data in Monday with other systems, an objective which is becoming increasingly important to modern businesses.

Here’s an example in Python, of how to obtain the IDs for items which have been updated since a given time.

import json
import requests

def flatten_list(input_list):
    return [item for sublist in input_list for item in sublist]

# Prepare GraphQL query to list activity logs for all boards
query = (
    "query activity_logs($from: ISO8601DateTime $page: Int)"
    "{boards{activity_logs(from: $from page: $page){id data entity}}}"
)
variables = {"from": "2023-01-01T00:00:00", "page": 1}
response = requests.get(
    url="https://api.monday.com/v2",
    json={"query": query, "variables": variables},
    headers={"Authorization": "Bearer ***"},
)

# Prepare response data
response_data = response.json()
activity_logs = flatten_list(
    [board["activity_logs"] for board in response_data["data"]["boards"]]
)

if activity_logs:  # if list is not empty

    # Filter for board and pulse (AKA item) objects
    boards = [
        json.loads(al["data"])
        for al in activity_logs
        if al["entity"] == "board"
    ]
    pulses = [
        json.loads(al["data"])
        for al in activity_logs
        if al["entity"] == "pulse"
    ]

    # Extract and deduplicate IDs for boards and items
    board_ids: set[int] = set([b["board_id"] for b in boards])    
    # Note there seem to be two possible schemas for the
    # pulse object, but both contain the item ID
    pulse_ids: set[int] = set(
        [
            *[p["pulse_id"] for p in pulses if "pulse_id" in p],
            *[p["pulse"]["id"] for p in pulses if "pulse" in p],
        ]
    )

    # Further requests can now be made using those IDs...

Hello @TomUK and thank you for sharing that!

I have added your vote towards this request 🙂

Cheers,
Matias

Here’s a slight correction to the code above, as you’ll need to paginate through each page of activity logs, for each page of boards, until the responses return no data 👍

query = """
query activity_logs($from: ISO8601DateTime, $board_page: Int, $log_page: Int) {
  boards(page: $board_page, limit: 100) {
    activity_logs(from: $from, page: $log_page, limit: 100) {
      id
      data
      entity
    }
  }
}
"""
variables = {"from": "2023-01-01T00:00:00", "board_page": 1, "log_page": 1}

Thank you for the correction @TomUK !

@Matias.Monday Where can we vote for this request?

Hi @GCavin,

Right here!

I have added your vote 🙂

Hi Everyone

I am excited to share that you can now filter based on the last updated date in the API, regardless of wether it is a board column or not!

The key to doing so is using the "UPDATED_AT" compare attribute!

Here is an example of how to get all items that were updated in the current date

query {
  boards(ids: 1234567890) {
    items_page (query_params: {rules: [{column_id: "__last_updated__", compare_value: ["TODAY"], operator:any_of, compare_attribute:"UPDATED_AT"}]}) {
      items {
        id
        name
      }
    }
  }
}

Happy Coding!

Hi @DanielHai is there something similar for filtering by created_at field? I want to do a query like created_at >= '2024-03-12 11:15'

Hello there @anant_m and welcome to the community!

There is no parameter for filtering according to the creation of the item.

But as a workaround, you can create an automation in your board that sets a date column to TODAY when an item is created, and then you can use a query like this one:

query {
  boards(ids: 1234567890) {
    items_page(
      query_params: {rules: [ {
        column_id: "date__1", 
        compare_value: ["EXACT", "2023-05-05"], 
        operator: greater_than_or_equals}]}
    ) {
      items {
        id
        name
      }
    }
  }
}

Of course you would need to get the creation date of all existing items as well to put that in the date column.

Let me know if you have any other questions!

Cheers,
Matias

@DanielHai Can we have a timestamp as compare_value for last_updated instead of ‘TODAY’, ‘YESTERDAY’ etc?

Hello there @aditya.mandavi,

Are you referring to something like this:

query {
  boards(ids: [1234567890]) {
    items_page(
      query_params: {rules: [ { 
        column_id: "date", 
        compare_value: ["EXACT", "2023-07-01"], 
        operator: any_of}]}
    ) {
      items {
        id
        name
      }
    }
  }
}

?

Looking forward to hearing from you 😀

Cheers,
Matias

Hi @Matias.Monday,

I believe what he meant is this:
Query items with last_updated >= timestamp (datetime/epoch timestamp)

Would that be possible?

Oh, wait,

Or is it something like:

query {
  boards(ids: [1234567890]) {
    items_page(
      query_params: {rules: [ { 
        column_id: "date", 
        compare_value: ["LAST_UPDATED"], 
        operator: any_of}]}
    ) {
      items {
        id
        name
      }
    }
  }
}

?

If so, it is not possible at the moment.