REST API and Saved Searches

Greetings

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

TIA Simon

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

Kevin Hi

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

Best regards Simon-----Original Message-----
From: Kevin Falcone [mailto:falcone@bestpractical.com]
Sent: 20 August 2012 15:40
To: rt-users@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

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

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

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

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@bestpractical.com]
Sent: 20 August 2012 15:40
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] REST API and Saved Searches

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