Few Questions regarding Query API

Hi @TechOpsHub!

There is indeed a field for items called updated_at which would return the date of when the item was last updated. Here is the section in our API guide that outlines this. Is this what you had in mind?

While there’s no argument for items that would allow you to “filter” the items returned, you can query all of the relevant items and their fields (i.e. updated_at, creator, created_at) and then filter them yourself.

For your third question, are you referring to Updates posted/activity logs? If so, changes to an item’s Updates section will not show up in the activity logs section. Is this what you were inquiring about?

Finally, for point 4, while you’re unable to “filter” Updates posted after a specific time, you can utilize the argument “from:” to query activity logs after a specific time. It would look something like this:

I hope this helps!

Hi Helen,

Thanks a lot for your quick reply, below are some followup questions

1. We are seeing updated_by(which can tell who updated the Item Last) field in addition to updated_at

2. Is there any plan to have filters on these fields in near future ? It seems Filter on Columns is there but not for these standard fields

3. If an Item is updated, all the details of all Update operation will be available within “Updates” API Response ? If not, which ones would be missing ?

4. Thanks, we couldn’t see this option in the GraphQL API doc [https://monday.com/developers/v2#queries-section-activity-logs]. Hope we are referring correct doc, if not please correct us.

Ignore, point #4 from above reply. I found the attribute. Sorry, my bad.

Hi @TechOpsHub,

I’m afraid at this time, we don’t have plans in the near future to add more arguments to the columns() component, however I’m more than happy to forward your feedback to our developers.

Do you mind expanding on your second point? What details did you have in mind?

Thanks

Hi Helen,

For 2nd point, i was thinking if we have filter possibility on fields like [created_at, creator/creator_id, updated_at ], it can be useful to retrieve the items list created/updated after a specific time or by a specific user. Such things can be very useful for the update based actions for tools integrating with monday.com to perform actions for Items created/updated after a given time.

Additionally, for the Query on Activity log

Is there any way to retrieve the actions by event ? example, retrieve only the activities performed on Item create or column value update [Exclude the other events like Column add or other board activities] ?

Our observation is, Activity log will be returned in descending order of their time. Please confirm.
And let us know if its possible to provide ordering for Activity logs retrieval

Hi @TechOpsHub,

While we don’t have an “events” argument for activity_logs, you can “filter” using groups, items, or boards.

Yes-- the most recent event will be returned first (just as you see it in the UI).

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.