[rt-users] REST API and Saved Searches

[Simon Dray]

Kevin Hi 

The spreadsheet feed is how we extract the data currently, what I am trying to end up with is a fully automated spreadsheet, where the manager opens the spreadsheet the data is collected using data import inside the spreadsheet and the data is then presented in various ways. I have tried various ways either with the REST API and also by using the URL used by RT to generate the spreadsheet but excel complains that the URL is too long. I am beginning to think that this is not possible without using SQL and joining all the tables together.

Again thank you for your help and patience 


Simon

-----Original Message-----
From: Kevin Falcone [mailto:falcone at bestpractical.com] 
Sent: 20 August 2012 17:42
To: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] REST API and Saved Searches

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