userMaintenance Web Service

userMaintenance

Click here for a complete list of operations.

editSLSQLWindowsAccount

Add/Edit/Delete WindowsUserAcct access to sql and databases. Calls: xct_spDSLeditSLSQLWindowsAccount

Test

The test form is only available for requests from the local machine.

SOAP 1.1

The following is a sample SOAP 1.1 request and response. The placeholders shown need to be replaced with actual values.

POST /ctapi/services/ctDynamicsSL/userMaintenance.asmx HTTP/1.1
Host: www.catalinatechnology.com
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://www.catalinatechnology.com/services/ctDynamicsSL/editSLSQLWindowsAccount"

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Header>
    <ctDynamicsSLHeader xmlns="http://www.catalinatechnology.com/services/ctDynamicsSL">
      <licenseKey>string</licenseKey>
      <licenseName>string</licenseName>
      <licenseExpiration>string</licenseExpiration>
      <softwareName>string</softwareName>
      <siteID>string</siteID>
      <siteKey>string</siteKey>
      <userName>string</userName>
      <cpnyID>string</cpnyID>
      <apiUsername>string</apiUsername>
      <apiPassword>string</apiPassword>
      <flags>
        <nameValuePairs>
          <name>string</name>
          <value>string</value>
        </nameValuePairs>
        <nameValuePairs>
          <name>string</name>
          <value>string</value>
        </nameValuePairs>
      </flags>
    </ctDynamicsSLHeader>
  </soap:Header>
  <soap:Body>
    <editSLSQLWindowsAccount xmlns="http://www.catalinatechnology.com/services/ctDynamicsSL">
      <actionType>string</actionType>
      <inItem>
        <errorMessage>string</errorMessage>
        <notes>string</notes>
        <resultCode>int</resultCode>
        <AlignFormGrid>short</AlignFormGrid>
        <AppServerUser>short</AppServerUser>
        <AutoDecimal>short</AutoDecimal>
        <AutoTab>short</AutoTab>
        <BrowserOnTop>short</BrowserOnTop>
        <CacheFavorite>short</CacheFavorite>
        <CacheMenu>short</CacheMenu>
        <CodeOnTop>short</CodeOnTop>
        <CodeFont>string</CodeFont>
        <CodeFontSize>short</CodeFontSize>
        <CodeTabWidth>short</CodeTabWidth>
        <ColorPref>int</ColorPref>
        <ColorPrefPV>int</ColorPrefPV>
        <CustomGroup>string</CustomGroup>
        <DefaultUser>short</DefaultUser>
        <EMailAddress>string</EMailAddress>
        <EnterForTab>short</EnterForTab>
        <FormGridHeigth>short</FormGridHeigth>
        <FormGridWidth>short</FormGridWidth>
        <HomePage>string</HomePage>
        <IntLogon>short</IntLogon>
        <LastDatabase>string</LastDatabase>
        <Location>string</Location>
        <MenuGroup>string</MenuGroup>
        <OutputFileName>string</OutputFileName>
        <OutputPath>string</OutputPath>
        <OutputRouting>string</OutputRouting>
        <Password>string</Password>
        <Phone>string</Phone>
        <PropertiesOnTop>short</PropertiesOnTop>
        <PVOptLookup>string</PVOptLookup>
        <RecType>string</RecType>
        <Role>short</Role>
        <S4Future01>string</S4Future01>
        <S4Future02>string</S4Future02>
        <S4Future03>double</S4Future03>
        <S4Future04>double</S4Future04>
        <S4Future05>double</S4Future05>
        <S4Future06>double</S4Future06>
        <S4Future07>dateTime</S4Future07>
        <S4Future08>dateTime</S4Future08>
        <S4Future09>int</S4Future09>
        <S4Future10>int</S4Future10>
        <SaveSettingsOnExit>short</SaveSettingsOnExit>
        <ShowFormGrid>short</ShowFormGrid>
        <ShowGridLines>short</ShowGridLines>
        <ShowGridRowNbrs>short</ShowGridRowNbrs>
        <SQMOptIn>string</SQMOptIn>
        <User1>string</User1>
        <User2>string</User2>
        <User3>double</User3>
        <User4>double</User4>
        <UserAcctAzure>string</UserAcctAzure>
        <UserId>string</UserId>
        <UserName>string</UserName>
        <WindowsUserAcct>string</WindowsUserAcct>
      </inItem>
    </editSLSQLWindowsAccount>
  </soap:Body>
</soap:Envelope>

HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Body>
    <editSLSQLWindowsAccountResponse xmlns="http://www.catalinatechnology.com/services/ctDynamicsSL">
      <editSLSQLWindowsAccountResult>
        <errorCode>int</errorCode>
        <errorMessage>string</errorMessage>
      </editSLSQLWindowsAccountResult>
    </editSLSQLWindowsAccountResponse>
  </soap:Body>
</soap:Envelope>

SOAP 1.2

The following is a sample SOAP 1.2 request and response. The placeholders shown need to be replaced with actual values.

POST /ctapi/services/ctDynamicsSL/userMaintenance.asmx HTTP/1.1
Host: www.catalinatechnology.com
Content-Type: application/soap+xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
  <soap12:Header>
    <ctDynamicsSLHeader xmlns="http://www.catalinatechnology.com/services/ctDynamicsSL">
      <licenseKey>string</licenseKey>
      <licenseName>string</licenseName>
      <licenseExpiration>string</licenseExpiration>
      <softwareName>string</softwareName>
      <siteID>string</siteID>
      <siteKey>string</siteKey>
      <userName>string</userName>
      <cpnyID>string</cpnyID>
      <apiUsername>string</apiUsername>
      <apiPassword>string</apiPassword>
      <flags>
        <nameValuePairs>
          <name>string</name>
          <value>string</value>
        </nameValuePairs>
        <nameValuePairs>
          <name>string</name>
          <value>string</value>
        </nameValuePairs>
      </flags>
    </ctDynamicsSLHeader>
  </soap12:Header>
  <soap12:Body>
    <editSLSQLWindowsAccount xmlns="http://www.catalinatechnology.com/services/ctDynamicsSL">
      <actionType>string</actionType>
      <inItem>
        <errorMessage>string</errorMessage>
        <notes>string</notes>
        <resultCode>int</resultCode>
        <AlignFormGrid>short</AlignFormGrid>
        <AppServerUser>short</AppServerUser>
        <AutoDecimal>short</AutoDecimal>
        <AutoTab>short</AutoTab>
        <BrowserOnTop>short</BrowserOnTop>
        <CacheFavorite>short</CacheFavorite>
        <CacheMenu>short</CacheMenu>
        <CodeOnTop>short</CodeOnTop>
        <CodeFont>string</CodeFont>
        <CodeFontSize>short</CodeFontSize>
        <CodeTabWidth>short</CodeTabWidth>
        <ColorPref>int</ColorPref>
        <ColorPrefPV>int</ColorPrefPV>
        <CustomGroup>string</CustomGroup>
        <DefaultUser>short</DefaultUser>
        <EMailAddress>string</EMailAddress>
        <EnterForTab>short</EnterForTab>
        <FormGridHeigth>short</FormGridHeigth>
        <FormGridWidth>short</FormGridWidth>
        <HomePage>string</HomePage>
        <IntLogon>short</IntLogon>
        <LastDatabase>string</LastDatabase>
        <Location>string</Location>
        <MenuGroup>string</MenuGroup>
        <OutputFileName>string</OutputFileName>
        <OutputPath>string</OutputPath>
        <OutputRouting>string</OutputRouting>
        <Password>string</Password>
        <Phone>string</Phone>
        <PropertiesOnTop>short</PropertiesOnTop>
        <PVOptLookup>string</PVOptLookup>
        <RecType>string</RecType>
        <Role>short</Role>
        <S4Future01>string</S4Future01>
        <S4Future02>string</S4Future02>
        <S4Future03>double</S4Future03>
        <S4Future04>double</S4Future04>
        <S4Future05>double</S4Future05>
        <S4Future06>double</S4Future06>
        <S4Future07>dateTime</S4Future07>
        <S4Future08>dateTime</S4Future08>
        <S4Future09>int</S4Future09>
        <S4Future10>int</S4Future10>
        <SaveSettingsOnExit>short</SaveSettingsOnExit>
        <ShowFormGrid>short</ShowFormGrid>
        <ShowGridLines>short</ShowGridLines>
        <ShowGridRowNbrs>short</ShowGridRowNbrs>
        <SQMOptIn>string</SQMOptIn>
        <User1>string</User1>
        <User2>string</User2>
        <User3>double</User3>
        <User4>double</User4>
        <UserAcctAzure>string</UserAcctAzure>
        <UserId>string</UserId>
        <UserName>string</UserName>
        <WindowsUserAcct>string</WindowsUserAcct>
      </inItem>
    </editSLSQLWindowsAccount>
  </soap12:Body>
</soap12:Envelope>

HTTP/1.1 200 OK
Content-Type: application/soap+xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
  <soap12:Body>
    <editSLSQLWindowsAccountResponse xmlns="http://www.catalinatechnology.com/services/ctDynamicsSL">
      <editSLSQLWindowsAccountResult>
        <errorCode>int</errorCode>
        <errorMessage>string</errorMessage>
      </editSLSQLWindowsAccountResult>
    </editSLSQLWindowsAccountResponse>
  </soap12:Body>
</soap12:Envelope>