Issue with FindAgent SOAP search for phone numbers in On-Prem 10.3

Hi all,

We have an application that still uses the SOAP interface for searching, but we’ve run into a small problem.

We have a new customer running On-Prem 10.3, and we need to search for phone numbers. We are using the following code:

string phoneFullNumber = "4723354000";

using (SuperOffice.CRM.Services.FindAgent find = new SuperOffice.CRM.Services.FindAgent())
{
    var archiveColumns = new string[] { "phone.SearchPhoneNumber", "phone.owner_id", "phone.ptype_idx", "phone.phone_id" };
    var restriction = new SuperOffice.CRM.ArchiveLists.ArchiveRestrictionInfo[]
    {
        new SuperOffice.CRM.ArchiveLists.ArchiveRestrictionInfo("phone.SearchPhoneNumber", "EQUALS", phoneFullNumber)
    };

    SuperOffice.CRM.Services.FindResults results = find.FindFromRestrictionsColumns(
        restriction,
        "Dynamic",
        archiveColumns,
        int.MaxValue,
        0
    );

    foreach (var row in results.ArchiveRows)
    {
        // Process results
    }
}



We believe this approach has worked in the past, but it no longer returns any results.

We also tried setting IsActive = true on the restriction, but it didn’t make a difference.

When logging the request, this is what is sent:

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"><s:Header><h:ApplicationToken xmlns:h="http://www.superoffice.net/ws/crm/NetServer/Services88">519a79b0aeaa3984c78da6a4abc50d49</h:ApplicationToken><h:Credentials xmlns:h="http://www.superoffice.net/ws/crm/NetServer/Services88" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><h:Ticket>7T:NwAwADcANgA5ADEAMgBiADMAMAAzAGQAMwBkADkAZABiADgANAA3AGEAMwAwADQANwBkADYANgBkAGIAZgAzADsAOQAwADEAOQA2ADMAMwA0ADMA</h:Ticket></h:Credentials><h:TimeZone xmlns:h="http://www.superoffice.net/ws/crm/NetServer/Services88" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><h:SoTimeZoneId>0</h:SoTimeZoneId><h:SoTimeZoneLocationCode/></h:TimeZone></s:Header><s:Body><FindFromRestrictionsColumns xmlns="http://www.superoffice.net/ws/crm/NetServer/Services88"><Restrictions xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><ArchiveRestrictionInfo><Name>phone.SearchPhoneNumber</Name><Operator>EQUALS</Operator><Values xmlns:a="http://schemas.microsoft.com/2003/10/Serialization/Arrays"><a:string>4723354000</a:string></Values><DisplayValues xmlns:a="http://schemas.microsoft.com/2003/10/Serialization/Arrays"/><ColumnInfo i:nil="true"/><IsActive>true</IsActive><SubRestrictions i:nil="true"/><InterParenthesis>0</InterParenthesis><InterOperator>And</InterOperator><UniqueHash>-1164823746</UniqueHash></ArchiveRestrictionInfo></Restrictions><ProviderName>Dynamic</ProviderName><DesiredColumns xmlns:a="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><a:string>phone.SearchPhoneNumber</a:string><a:string>phone.owner_id</a:string><a:string>phone.ptype_idx</a:string><a:string>phone.phone_id</a:string></DesiredColumns><PageSize>2147483647</PageSize><PageNumber>0</PageNumber></FindFromRestrictionsColumns></s:Body></s:Envelope>

And this is the response we get:

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"><s:Header><h:ExceptionInfo i:nil="true" xmlns:h="http://www.superoffice.net/ws/crm/NetServer/Services88" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"/><h:ExtraInfo i:nil="true" xmlns:h="http://www.superoffice.net/ws/crm/NetServer/Services88" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"/><h:Succeeded xmlns:h="http://www.superoffice.net/ws/crm/NetServer/Services88">true</h:Succeeded><h:TimeZone xmlns:h="http://www.superoffice.net/ws/crm/NetServer/Services88" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><h:SoTimeZoneId>0</h:SoTimeZoneId><h:SoTimeZoneLocationCode/></h:TimeZone></s:Header><s:Body><FindFromRestrictionsColumnsResponse xmlns="http://www.superoffice.net/ws/crm/NetServer/Services88"><Response xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><TableRight i:nil="true"/><FieldProperties/><ArchiveColumns/><ArchiveRows/><RowCount>0</RowCount></Response></FindFromRestrictionsColumnsResponse></s:Body></s:Envelope>



As you can see, no rows are returned (RowCount=0), and there are no errors.

Has anyone encountered this before or have suggestions on why this might be happening? Could this be related to provider availability, configuration, or permissions in On-Prem 10.3?

Thanks in advance for any advice!