• Replies 4 replies
  • Subscribers 245 subscribers
  • Views 35 views
  • Users 0 members are here
Related

Pull specific table from database with API

Former Member
Former Member $organization

Hi Guys,

Am trying pull the zone_legend values from the T_Zones table. Can't find anything in the API that will allow me do this and although I can do a direct call with SQL while it's in development, when it goes live the server hosting Tessitura won't have a public facing IP so will have to rely on the API.

Is there any way in the API that I can pull data from a specific table in the database?

Thanks

Parents
  • Former Member
    Former Member $organization

    Are you looking for zone maps? GetPerformanceDetailWithDiscountingEx method returns the zmap_no.  You could also use the GetZonesPerSection method.

     

    From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Huw Davies
    Sent: Thursday, July 25, 2013 7:09 AM
    To: Gloria Ormsby
    Subject: [Tessitura Web Forum] Pull specific table from database with API

     

    Hi Guys,

    Am trying pull the zone_legend values from the T_Zones table. Can't find anything in the API that will allow me do this and although I can do a direct call with SQL while it's in development, when it goes live the server hosting Tessitura won't have a public facing IP so will have to rely on the API.

    Is there any way in the API that I can pull data from a specific table in the database?

    Thanks




    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!

  • Former Member
    Former Member $organization in reply to Former Member

    Thanks for reply,

    Have tried both these already and they give me the zone_id and description but not the zone_legend, which is what I really need.

  • $organization in reply to Former Member

    Hi Huw,

    What you're interested in then is GetLocalData (assuming you're using the SOAP API).  I strongly recommend that you first create a SQL view on the data you are interested in (so that you can restrict the output to the minimum of information that you need, and also potentially apply security screening on what data is returned), then configure TR_LOCAL_DATA to allow GetLocalData access to that view.

    --Gawain

Reply
  • $organization in reply to Former Member

    Hi Huw,

    What you're interested in then is GetLocalData (assuming you're using the SOAP API).  I strongly recommend that you first create a SQL view on the data you are interested in (so that you can restrict the output to the minimum of information that you need, and also potentially apply security screening on what data is returned), then configure TR_LOCAL_DATA to allow GetLocalData access to that view.

    --Gawain

Children