The Stock Card Summaries API goes through presents all line items in a single request. Currently, Nifi needs to query the entire stock card summary when it only needs to pull a handful of line items that have changed since the last time it checked (which is every 'n' seconds). We would like to streamline this process by adding an optional API parameter labeled "since" which would accept a date value. The since value would be used to filter based on the "lastUpdate" date and return all line items that are greater or equal to the date.
The lastUpdate field appears to be a date, not a datetime field. Nifi will query multiple times per day. If this were a datetime field, we would be able to be more accurate in the filtering. Can we make this field a datetime, or is there another field that could be returned that shows the date the transaction happened on the database?