Method Community

I am trying to use the API to make a copy of an activity. For some recurring records, the RecurrenceInfo field contains more than 8000 characters and I get an error when trying to insert the copy that there are too many characters to be inserted.

How can the field have more characters than are allowed in the first place?

What can I do to be able to insert the new record? Is there information that can be taken out of the RecurrenceInfo with ruining the integrity?

Hi Matt,

I would not recommend editing it.

Did you use MethodAPISelect_XML or MethodAPISelect_XMLV2 to retrieve the RecurrenceInfo field your are trying to copy? RecurrenceInfo is xml that is saved in a varchar field. But the api is also returning xml. So in order to transmit the data in the field, it gets encoded.

Before sending the data back as part of the insert first try to decode it with a simple .NET HttpUtility.HtmlDecode

Dave

Hi Dave,

I am using the MethodAPSelectXML_V2.

The HttpUtility.HtmlDecode does shorten it up a bit, but not enough in all cases. One example I just tried was 9099 characters before decoding and 8739 after decoding. I customized the FieldService Work Order screen to display the RecurrenceInfo field and it is over 8000 characters there as well.

If you would like the Account and Activity RecordID info, I can send that to you in an email.

Hi Matt,

This issue should now be fixed

Dave

It worked correctly when I just tried it. Thanks Dave.