Fetch list of items updated after a specific date

[kranthi_thoughtflow (Kranthi Kiran)]

Hi there,

Is there a way to fetch items that we are updated after a certain timestamp?

Thank you.

[rachelatmonday (Rachel)]

Hey @kranthi_thoughtflow,

Any chance you could filter the last updated column using one of the predefined compare values? It wouldn’t do exactly what you’re looking for though, so this could also be a great feature request

Best,
Rachel

[kranthi_thoughtflow (Kranthi Kiran)]

Thank you @rachelatmonday . A few questions based on this documentation

• There is an option to query based on PAST_DATETIME. Would this solve my problem? Also, what is the format of date time that this query expects?
  

  

• I was also looking at this api Items page by column value

This seems to have a provision of taking board_id as input. But from the documentation, it is not clear if it can accept multiple board ids. Can you please confirm if this accepts multiple board ids?

Thank you.

[rachelatmonday (Rachel)]

Hey @kranthi_thoughtflow,

That wouldn’t be of much help. The “PAST_DATETIME” is actually a specific compare value that you pass in a query. It doesn’t accept specific timestamps and only returns items updated in the past (which is all of them).

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

Could you use another compare value, like “TODAY” or “LAST_WEEK”?

Regarding items_page_by_column_values, it is not an array/only takes one ID!

Best,
Rachel

[kranthi_thoughtflow (Kranthi Kiran)]

Thank you @rachelatmonday