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
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
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!
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.
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
Worked like a charm.