GetPublishedViewColumns

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

Note: You can review documentation for available database views in Database Views > Views Provided.

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>