Hi, I'm probably missing something really obvious, but so far I've had no luck with this method. We are attempting to craft a contact center where our customer does not need to login to subscribe to an email list. If they want to login, great, we can capture their customer # and even eaddress #, but if they don't want to login, we would populate 0s in these fields, and just snag their email address and the list # that they to which they want to subscribe. (And ideally run a job later to try to match them up with customer records, if possible.)
The problem is UpdateLocalData is requiring an integer for a RetrievalKey and LocalDataTableKey. TR_LOCAL_DATA columns for these fields are an identity field for the key_column and eaddress_no for the retrieval column. The update_ind is checked. Ideally, we'd prefer to have the email address be the retrieval column, since our user may not be logged in. However, the UpdateLocalProcedure method indicates that the RetrievalKey must be an integer, thus we're using eaddress_no. And passing a 0 here for the eaddress_no does not seem to work.
What am I missing? Do we need to do a workaround using ExecuteLocalProcedure instead? Thanks!!
I'm noting some parameters for UpdateLocalData and am confused with RetrievalKey. The documentation states that it is type integer and is the value of retrieval_column in TR_LOCAL_DATA - this field not type integer, though. Is this meant to be a string?
The RetrievalKey parameter for GetLocalData is, on the other hand, type string.
Cheers,
Kevin