Update Journal API to support filtering based on the Date field OR a general where clause
Currently, you can' t get Journals based on posting date (the Date field in Journal). It should be supported as it is more relevant than the if-modified-since filter. In general, the Journal API should support the where clause.
Laura Dimock commented
I really need this to work for Power BI reporting purposes.
Jeff Stephenson commented
This is one of the main end points that people use when extracting raw data for reporting. Reporting systems don't aways have the ability to archive records and so not having a date filter makes it challenging to make adhock queries to this end point
James A Tidd commented
vitally important, directly prohibits all work on transactions ... which are at the heart of everything
Chris Counsell commented
Agree with the comments, it would be far easier to just filter the journal entries (with a where clause) rather than having to pull ALL the entries and then filter them, this is especially true with companies with a large amount of journal entries, which, because of the rate limits, are timing out due to the volumes :(
Nicolas Emmerich commented
This is particularly important as it's nigh-on impossible to pull relevant journals without pulling all of them.