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.
Zia Khan
shared this idea
-
man of hat commented
Very important, since the company will have many journals, our clients will be interested on journals of only a certain period, but this cannot be done because the filter by JournalDate is not working and also modify-since is not working properly
-
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.