it's the same for listDeviceProfiles by the way.. just had to rewrite that using sql as well since I need this information for the task I currently have.
I'd argue it makes sense for it to be supported for all objects that have a lines element.. after all, database wise, they all work the same (with device, devicenumplanmap and numplan tables).
@edit: hmm.. and the same for listPhone. But there with a twist.. there the searchCriteria is actually checked against the allowed values.
I'm sending
<searchCriteria><name>%</name></searchCriteria><returnedTags><name/><product/><locationName/><lines><line><index/><label/><display/><dirn/><associatedEndusers><enduser><userid/></enduser></associatedEndusers></line></lines><callingSearchSpaceName/><userLocale/><devicePoolName/><ownerUserName/></returnedTags>
and the response error is
Unmarshalling Error: unexpected element (uri:"", local:"lines"). Expected elements are <{}loginTime>,<{}dialRulesName>,<{}keySize>,<{}cgpnTransformationCssName>,<{}requireDtmfReception>,<{}numberOfButtons>,<{}locationName>,<{}deviceTrustMode>,<{}traceFlag>,<{}rerouteCallingSearchSpaceName>,<{}hlogStatus>,<{}authenticationMode>,<{}remoteDevice>,<{}certificateStatus>,<{}digestUser>,<{}sendGeoLocation>,<{}callingSearchSpaceName>,<{}proxyServerUrl>,<{}allowiXApplicableMedia>,<{}alwaysUsePrimeLine>,<{}confidentialAccess>,<{}userHoldMohAudioSourceId>,<{}phoneSuite>,<{}isActive>,<{}mlppIndicationStatus>,<{}networkHoldMohAudioSourceId>,<{}loginDuration>,<{}devicePoolName>,<{}idleTimeout>,<{}mtpPreferedCodec>,<{}subscribeCallingSearchSpaceName>,<{}mediaResourceListName>,<{}homeNetworkId>,<{}packetCaptureMode>,<{}automatedAlternateRoutingCssName>,<{}defaultProfileName>,<{}secureMessageUrl>,<{}callInfoPrivacyStatus>,<{}softkeyTemplateName>,<{}isDualMode>,<{}protocolSide>,<{}rfc2833Disabled>,<{}packetCaptureDuration>,<{}ringSettingBusyBlfAudibleAlert>,<{}commonPhoneConfigName>,<{}blockIncomingCallsWhenRoaming>,<{}geoLocationFilterName>,<{}unattendedPort>,<{}presenceGroupName>,<{}alwaysUsePrimeLineForVoiceMessage>,<{}idleUrl>,<{}primaryPhoneName>,<{}certificateOperation>,<{}preemption>,<{}product>,<{}retryVideoCallAsAudio>,<{}commonDeviceConfigName>,<{}dndRingSetting>,<{}servicesUrl>,<{}currentConfig>,<{}singleButtonBarge>,<{}allowCtiControlFlag>,<{}hotlineDevice>,<{}builtInBridgeStatus>,<{}mtpRequired>,<{}userLocale>,<{}loadInformation>,<{}dndStatus>,<{}enableCallRoutingToRdWhenNoneIsActive>,<{}mobilityUserIdName>,<{}roamingDevicePoolName>,<{}description>,<{}useTrustedRelayPoint>,<{}upgradeFinishTime>,<{}dndOption>,<{}useDevicePoolCgpnTransformCss>,<{}ownerUserName>,<{}keyOrder>,<{}class>,<{}isProtected>,<{}phoneServiceDisplay>,<{}authenticationString>,<{}informationUrl>,<{}ignorePresentationIndicators>,<{}networkLocale>,<{}deviceMobilityMode>,<{}secureDirectoryUrl>,<{}enableExtensionMobility>,<{}secureInformationUrl>,<{}sipProfileName>,<{}secureIdleUrl>,<{}model>,<{}outboundCallRollover>,<{}loginUserId>,<{}AllowPresentationSharingUsingBfcp>,<{}featureControlPolicy>,<{}geoLocationName>,<{}name>,<{}ecKeySize>,<{}joinAcrossLines>,<{}secureAuthenticationUrl>,<{}earlyOfferSupportForVoiceCall>,<{}messagesUrl>,<{}currentProfileName>,<{}protocol>,<{}authenticationUrl>,<{}secureServicesUrl>,<{}securityProfileName>,<{}aarNeighborhoodName>,<{}requireOffPremiseLocation>,<{}sshUserId>,<{}requireThirdPartyRegistration>,<{}networkLocation>,<{}ringSettingIdleBlfAudibleAlert>,<{}directoryUrl>,<{}phoneTemplateName>
I'd argue behavior should be consistent across operations. And now I'm off to rewrite yet another operation to sql. Well.. this time around I have to combine listPhone with axl as it would take too much time to get all the properties I need from sql.
