Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Include "modifiedTime" in API response

cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
pwa
5 - Automation Enthusiast
5 - Automation Enthusiast

So I donโ€™t need to add the Last Modified Time column to every table.

4 Comments
David_Torbett
5 - Automation Enthusiast
5 - Automation Enthusiast

If itโ€™s not held in the table, where would the API pull it from? Are you talking about the last time the api was modified (which I doubt).
I think last modified time addition to every table is perfect and the only way to capture the last time a record in a table was modified.

pwa
5 - Automation Enthusiast
5 - Automation Enthusiast

The modified time is already being collected, regardless of whether or not itโ€™s included as a field, just like the created time.

If you retrieve a record using the API, you will get something like this:

{
  "id": "xxxx",
  "fields": { ... },
  "createdTime": "xxxx"
}

Iโ€™d like โ€œmodifiedTimeโ€ to be included in the response JSON by default, so I get something like this:

{
  "id": "xxxx",
  "fields": { ... },
  "createdTime": "xxxx",
  "modifiedTime": "xxxx"
}.
David_Torbett
5 - Automation Enthusiast
5 - Automation Enthusiast

My understanding was that createdTime would only be included if it were a column on the table, i.e. its no different to any of the other fields.

pwa
5 - Automation Enthusiast
5 - Automation Enthusiast

createdTime is always included, regardless of whether or not a column exists for it on the table. If you look at the example JSON I provided, โ€œcreatedTimeโ€ is not inside the fields object, but at the same level as โ€œidโ€.