WebApi How do you get performances for a production for a data range?

Maybe I am missing something, but I am looking for a way with the webapi to return only the current performances for a specified production?  Is there a web method the provides this functionality? 

I know I can write a custom method to do this, or iterate through the returned dataset and filter out past dates.

Thanks!

Jon

 

  • I would double check the end date and time for your MOS that is set for online. It should only take the valid perfs and leave the past behind.

     

    JEFFREY CASS │Ticket Services Manager

    Chicago Shakespeare Theater

    800 E Grand Avenue

    Chicago, IL 60611

    312.595.5638

    chicagoshakes.com

     


    From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Jon Ballinger
    Sent: Tuesday, January 19, 2010 9:24 AM
    To: Jeff Cass
    Subject: [Tessitura Web Forum] WebApi How do you get performances for a production for a data range?

     

    Maybe I am missing something, but I am looking for a way with the webapi to return only the current performances for a specified production?  Is there a web method the provides this functionality? 

    I know I can write a custom method to do this, or iterate through the returned dataset and filter out past dates.

    Thanks!

    Jon

     




    You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

  • Which web method are you referring to?  I am looking to pass in a production number , and possibly a date range have returned only that dataset.  I don't think GetPerformances takes a production season number.  And GetProductionDetailEx does not take a date range.  It returns all the perfs.

  • Actually, none of the API methods filter out performances that are in the past, even if the mode of sale is not active.  Here’s an excerpt from the new Tessitura and the Web document that addresses this:

     

    As long as the mode of sale passed in a performance search exists on a performance it will be returned by a performance search.  The active dates on the mode of sale are also returned in the search results, as well as an on sale indicator that is set to Y if the current mode of sale is active or N if it is not.  Web code must be written to take action when the current date is outside the active dates on the mode of sale.

     

    Now, the GetPerformances methods do have date parameters which you could use to only search for stuff in the future, and GetPerformancesEx3, which was added in v9, has a season parameter.  It also has a keyword parameter, which I suppose you could use in place of production season (by adding a keyword for production seasons to performances).  It’s probably not the most standard way to do things, but depending on your ability to get coding added to your website it might be easier to just add keywords.

     

    Kevin Sheehan

    Documentation & Learning Resources Specialist

    Tessitura Network

    1 888 643 5778 ext 329 Office

    ksheehan@tessituranetwork.com

  • Thanks for the info! I was thinking this was the case.  I will either use LINQ to filter the dataset more, or just create a new stored proce to just get the data that is needed.