Folks,
Maybe it's me not understanding the method correctly but I am having an issue using this API call via the Tessitura.asmx page. I get a session key and if I use the numeric value of the promo code in the PromotionCode field, I get a valid response with the data in the XML that I'm expecting. If I enter a zero in the PromotionCode field and enter the appropriate text in the PromotionCodeString field (examples of the codes are VOGUE, CDGIFT - so non alphanumeric) I get an "empty" response - which is detailed below.
I believe the promo code is set up correctly in the TR_WEB_SOURCE_NO table as the call returns the appropriate value when the source number is used (but happy to be proved wrong!) Does anyone have any hints as to what I'm doing wrong? Any feedback will be gratefully recieved!
Martin
<?xml version="1.0" encoding="utf-8" ?>
- <DataSet xmlns="http://tessiturasoftware.com/">
- <xs:schema id="GetPromoCodeExResults" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
- <xs:element name="GetPromoCodeExResults" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
- <xs:complexType>
- <xs:choice minOccurs="0" maxOccurs="unbounded">
- <xs:element name="PromoCodeDetails">
- <xs:sequence>
<xs:element name="source_no" type="xs:int" minOccurs="0" />
<xs:element name="promo_code" type="xs:string" minOccurs="0" />
<xs:element name="mos" type="xs:int" minOccurs="0" />
<xs:element name="override_rank_ind" type="xs:string" minOccurs="0" />
<xs:element name="source_name" type="xs:string" minOccurs="0" />
<xs:element name="appeal_no" type="xs:int" minOccurs="0" />
<xs:element name="appeal_desc" type="xs:string" minOccurs="0" />
<xs:element name="text1" type="xs:string" minOccurs="0" />
<xs:element name="text2" type="xs:string" minOccurs="0" />
<xs:element name="text3" type="xs:string" minOccurs="0" />
<xs:element name="text4" type="xs:string" minOccurs="0" />
<xs:element name="text5" type="xs:string" minOccurs="0" />
<xs:element name="text6" type="xs:string" minOccurs="0" />
<xs:element name="promote_dt" type="xs:dateTime" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:schema>
<diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1" />
</DataSet>
Hi Martin,
Ran into this problem recently and this was the first post that come up when I did a search.
I was able to resolve this by setting an 'Organization Name' session variable that matched the parent key column in TR_WEB_SOURCE_NO for the relevant promo code. I could then retrieve the promo code data with the offer's description.
Cheers,
Patrick.