Our developer is trying to update a local table for our custome Data Protection tabs, but he's getting an API error, saying heneeds to send U, A or D which is what he's doing.
\the error reads:
Failed soap:Receiver System.Web.Services.Protocols.SoapException: Serverwas unable to process request. ---> System.Exception: Invalid Action.Valid values are A(Add), U(Update) and D(Delete). at Tessitura.WebAPI.Tessitura.UpdateLocalData(String SessionKey, Int32LocalDataTableIndex, Int32 LocalDataTableKey, Char Action, Int32RetrievalKey, String LocalDataValues)
Has anyone experienced this before? Any suggestions gratefully received.
Thanks, Christopher
I got this error once. If I remember correctly, there is a column called Update Ind with a checkbox in TR_LOCAL_DATA. Make sure that is checked and see if that fixes it. Let me know if that works, if not we can try and troubleshoot further.
Hi Christopher,
The API error messages can sometimes point you in the wrong direction. If you're already doing what the error message is telling you to do, there's a good chance you've got a permissions problem. Double check your settings in TR_LOCAL_DATA. Also, try executing the same calls through the Tessitura.asmx web interface. If it works there, the problem is probably in your web code, not Tessitura.
-Morgan