[rt-users] REST API and Saved Searches

[Kevin Falcone]

On Mon, Aug 20, 2012 at 04:02:27PM +0100, Simon Dray wrote:
> Thanks for taking the time to answer but the RSS feed doesn't give me
> the data and formatting I wanted, the result I was trying to get was
> the same as an output directly to the spreadsheet. My SQL is not good
> enough to stitch all the bits together. I am trying to make easy for
> management to just run the spreadsheet and then use excel to extract
> the data locally, I know the correct way is to do a MYSQL query and
> then do joins for the tables but my knowledge stops at getting one
> table let alone 7 or 8

I wasn't suggesting the RSS feed, I was suggesting the Spreadsheet
Feed.

-kevin

> 
> -----Original Message-----
> From: Kevin Falcone [mailto:falcone at bestpractical.com] 
> Sent: 20 August 2012 15:40
> To: rt-users at lists.bestpractical.com
> Subject: Re: [rt-users] REST API and Saved Searches
> 
> On Fri, Aug 17, 2012 at 12:40:52PM +0100, Simon Dray wrote:
> >    I am trying to use REAST API from excel and can do simple queries but want to use a saved
> >    search does anyone know of REST command line that can do this, I want to import the saved
> >    search out into a spreadsheet
> 
> You cannot access saved searches via the REST API.
> Save searches can be exported out to spreadsheets from the Feeds tab in the web UI.
> 
> -kevin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120820/0e30a9b5/attachment.sig>