I am having an issue with the Text3, Text4 fields that should be returned by the GetPromoCodeEx webapi method.
Here is the strange thing...If I execute the WP_GET_SOURCE_NO stored procedure directly it returns all values I need inlcuding text3 and text4 fields. However, the web api call to GetPromoCodeEx, which according the documentation is a call that uses the stored procedure WP_GET_SOURCE_NO, returns all fields I need EXCEPT for text3 and text4. No matter what I put in to these fields nothing is returned by the webapi.
Here is the code:
DataSet promoDataSet = _api.GetPromoCodeEx(sessionID, keyword, 0);
if (promoDataSet != null && promoDataSet.Tables["PromoCodeDetails"].Rows.Count > 0)
{
sourceCode = promoDataSet.Tables["PromoCodeDetails"].Rows[0]["source_no"].ToString();
sourceCodeText = promoDataSet.Tables["PromoCodeDetails"].Rows[0]["text1"].ToString();
singlePerformanceCheck = promoDataSet.Tables["PromoCodeDetails"].Rows[0]["text2"].ToString();
productionIDCheck = promoDataSet.Tables["PromoCodeDetails"].Rows[0]["text3"].ToString();
}
Everything is returned but text3 field above. No matter what it is always an empty string.
Right now in TR_WEB_SOURCE_NO table there is a promo code "lpas" and there are text1, text2, and text3 values for that promo code in the database. The webapi will not pull anything but text1, and text2.
Text3 and Text4 always return empty string.
Any insight is much appreciated! Thanks!