Filter Saved Report with API
I have a saved report that I need to manipulate externally. However I need to filter by month, and this month is not consistent (Not always this month, or last month). How do I either: 1)Add a ...
Forum Discussion
which api, then restful api?
------------------------------
Johnny
------------------------------
------------------------------
Johnny
------------------------------
- Hi Johnny,
I was initially trying to use the Do_Query, I haven't looked much into the Restful APIs at this point.
Though since I've hit a wall, I'm open to other suggestions.
Thanks,
------------------------------
Kevin Haigler
------------------------------- you can do it by building the query
example of query in url
https://[realm].quickbase.com/db/?a=API_DoQuery&query={'14'.BF.'today'}&apptoken=[appToken]
{'14'.BF.'today'} - field 14 (end date) , occurs before today
{'6'.OAF.'today'} - field 6 (start date), occurs either today or after today
there is documentation, but its not simple.
------------------------------
Johnny
------------------------------
Is there a way that you know of to view the existing query string? Or how do I build a query string for a summary report?
Original question has now been updated to show that the original report is a summary report.
------------------------------
Kevin Haigler
------------------------------- yes, there is a feature when you are viewing a report
in the top right there is a "more" link, it will list options, one of them shows the the current link
It does not show up on every view of the report for some reason.
------------------------------
Johnny
------------------------------- Hi Johnny,
Summary reports must be one of the views that it's not available.
I'm only showing "Print" and "Save as Spreadsheet" as options.
------------------------------
Kevin Haigler
------------------------------
