- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 19, 2024 08:28 AM
I tried posting this question yesterday but now I can't find the post so it looks like it didn't actually get created so I'm trying again.
I've been tasked with creating an interface to our AirTable data using an API developed by Brightvine (Brightvine Data Link). I can get back all the data using the API interface but I need to be able to pass in the last date the process ran on our end and get only those rows created since the last run date/time. The BVDL gives me a place to enter URL parameters and I've tried using the "filterByFormula" option but I keep getting an invalid formula error. The BVDL gives me access to the last run date/time in a couple of different formats when creating a parameter.
Any suggestions will be greatly appreciated.
Thanks,
Ray Porter
Solved! Go to Solution.
Accepted Solutions
![kuovonne kuovonne](https://community.airtable.com/legacyfs/online/avatars/3X/b/c/bcecb2d58f8302e9d9f520621c02ff41be54488c.jpeg)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 19, 2024 10:33 AM
Try creating your formula in an Airtable formula field first to get the format of the formula right. You will also need a {Created time} field. Then after you have the formula right, move it to filterByFormula.
You will probably want a formula that looks something like this. In your code you will replace the date string with your last run date.
IS_AFTER({Created time}, DATETIME_PARSE("2024-01-01", "YYYY-MM-DD"))
A few notes:
- You can include a time in the formula in addition to the date if you need that precision. Lookup the DATETIME_PARSE() function in the formula field reference for more info.
- Airtable formulas process date/time fields as GMT, so submit your date/time as GMT not your local time.
- Make sure you url encode the parameters.
- The white space in the formula is not strictly necessary. I just like it to make it more human readable.
![kuovonne kuovonne](https://community.airtable.com/legacyfs/online/avatars/3X/b/c/bcecb2d58f8302e9d9f520621c02ff41be54488c.jpeg)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 19, 2024 10:33 AM
Try creating your formula in an Airtable formula field first to get the format of the formula right. You will also need a {Created time} field. Then after you have the formula right, move it to filterByFormula.
You will probably want a formula that looks something like this. In your code you will replace the date string with your last run date.
IS_AFTER({Created time}, DATETIME_PARSE("2024-01-01", "YYYY-MM-DD"))
A few notes:
- You can include a time in the formula in addition to the date if you need that precision. Lookup the DATETIME_PARSE() function in the formula field reference for more info.
- Airtable formulas process date/time fields as GMT, so submit your date/time as GMT not your local time.
- Make sure you url encode the parameters.
- The white space in the formula is not strictly necessary. I just like it to make it more human readable.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 20, 2024 03:34 AM - edited ‎Nov 27, 2024 10:26 AM
The author is developing an API for filtering database rows based on created_date or created_time, seeking best
10.0.0.0.1 – 10.0.0.1
practices for date formatting, time zone handling, and efficient query parameters.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 20, 2024 09:47 AM
Thanks. After some trial and error, this solution is what I needed. The Brightvine interface makes our lastrun date/time available to me in a couple of different formats. Here's the formula that worked:
IS_AFTER({Created Date/Time}, DATETIME_PARSE("[$UTC_LASTRUNTIME(u)]", "YYYY-MM-DD"))
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 10, 2025 03:29 AM
To select rows based on a created date/time from an API call, you can pass the date as a query parameter The API can then filter rows where the column matches or is greater than the specified date/time in the query. Make sure the date format is compatible with the database or service you're querying.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 19, 2025 10:16 PM
You can pass the date from the API call as a query parameter LMC 8.4 and filter rows based on the or column using a SQL clause or equivalent filtering logic in your backend code.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 27, 2025 03:46 AM
To download the CinemaHD APK, visit a trusted third-party website, ensure it's a secure source, and download the APK file. Enable "Install from Unknown Sources" in your device settings, then open the APK file to install the app. Be cautious of potential security risks from unverified sources.
![](/skins/images/FE00829FDD2AE889FAB731D8F02A8942/responsive_peak/images/icon_anonymous_message.png)