push_pin
lock
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!
26. nov. 2025 | 05:17 p.m.
Siste svar
Phone numbers are stored without the country prefix in the searchphonenumber field. Country Table Logic: If the country prefix matches the country linked to the entity (e.g., contact or person), the prefix is removed when saving and added when displaying. For example, if a contact is registered with Norway, +47 will be stripped before saving and added back when viewed. If the phone number has a different country prefix than the entity’s country, the prefix is kept in the phone field. For more details, see: https://docs.superoffice.com/en/database/tables/phone.html
1 t, 46 m siden | 09:26 a.m.