Next Topic

Previous Topic

Book Contents

GetPublishedViewColumns

Returns an array of all columns for a published database view.

Multiple records of the following fields are returned.

name

string

Name of the database view column.

dataType

string

Datatype of the database view column.

A single record of the following fields is returned.

Method

string

The operation that requested this response.

TransactionID

decimal

The unique message ID for this message.

ErrorMessage

string

If blank, no error was returned.

ErrorLocation

string

If blank, no error was returned.

Example

Note: The following example was executed using the test page published with every installation, located at http://localhost/vsaWS/testClient/testClient.asp.

Request

<req>
  <viewName>vScriptLog</viewName>
  <SessionID>42131527423841487151422001</SessionID>
</req>

Response

<GetPublishedViewColumnsResponse>
  <GetPublishedViewColumnsResult>
    <PublishedViewColumns>
      <PublishedViewColumn>
        <name>AdminName</name>
        <dataType>varchar(100)</dataType>
      </PublishedViewColumn>
      <PublishedViewColumn>
        <name>agentGuid</name>
        <dataType>numeric(26,0)</dataType>
      </PublishedViewColumn>
      <PublishedViewColumn>
        <name>EventTime</name>
        <dataType>datetime</dataType>
      </PublishedViewColumn>
      <PublishedViewColumn>
        <name>groupName</name>
        <dataType>varchar(100)</dataType>
      </PublishedViewColumn>
      <PublishedViewColumn>
        <name>Machine_GroupID</name>
        <dataType>varchar(201)</dataType>
      </PublishedViewColumn>
      <PublishedViewColumn>
        <name>machName</name>
        <dataType>varchar(100)</dataType>
      </PublishedViewColumn>
      <PublishedViewColumn>
        <name>ScriptDesc</name>
        <dataType>varchar(1000)</dataType>
      </PublishedViewColumn>
      <PublishedViewColumn>
        <name>ScriptName</name>
        <dataType>varchar(260)</dataType>
      </PublishedViewColumn>
    </PublishedViewColumns>
    <Method>GetPublishedViewColumns</Method>
    <TransactionID>3</TransactionID>
    <ErrorMessage/>
    <ErrorLocation/>
  </GetPublishedViewColumnsResult>
</GetPublishedViewColumnsResponse>