Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Limiting the issues gotten by time

Topic Labels: API
1517 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Gabriel_Smith
4 - Data Explorer
4 - Data Explorer

Hi. I’m writing a python script to go into the database and retrieve data matching specified times that things have happened. So for example, event_a happened July 15, 16, 18, 21, 22 and 23 at 1500 each day. I was wondering if there was a way, using the python api, to have it only search as far back as, say, July 19th. One week ago. I know that the get_all, search, and get_iter functions all take a max_records argument, but that isn’t what I was looking for. I’m not saying only look for the first 100 matches. I’m saying only look back in time a week. Does anyone know how I could go about doing that? Thank you in advance.

3 Replies 3

Welcome to the Airtable community!

You could use filterByFormula in the REST API to get only records that are within the last 7 days. This formula should give you a starting place. You can learn more about the functions in a formula field in the formula field reference.

IF(DATETIME_DIFF(TODAY(),{dateTime field name},"days")<=7,1)

Thank you. I was going to try making a new table that was table_x but only from the past 7 days today and use that instead of the larger table. I’ll try playing around with the formula field a little bit more though using what you suggest.

You can also create a new view that filters for the records from the past 7 days. Then only get the records from that view.