GetUserTables

POST

/SOAP

Returns a list of accessible database tables and their associated fields.

Request

Query Params

Header Params

Body Params application/xml

Examples

Responses

🟢200GetUserTables response

application/xml

Bodyapplication/xml

Request Example

Shell

JavaScript

Java

Swift

curl --location '/SOAP?service=EasyIPCore' \
--header 'SOAPAction: urn:EasyIPLibrary-EasyIPCore#GetUserTables' \
--header 'Content-Type: text/xml; charset=utf-8' \
--data '<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Body>
    <tns:EasyIPCore___GetUserTables xmlns="http://tempuri.org/">
      <tns:IncludeChildTables>true</tns:IncludeChildTables>
      <tns:IncludeLookups>true</tns:IncludeLookups>
    </tns:EasyIPCore___GetUserTables>
  </soap:Body>
</soap:Envelope>'

Response Example

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Body>
    <tns:EasyIPCore___GetUserTablesResponse xmlns="http://tempuri.org/">
      <tns:Result>
        <tns:TUserTable>
          <tns:TableId>100</tns:TableId>
          <tns:ParentTableId>100</tns:ParentTableId>
          <tns:TableName>string</tns:TableName>
          <tns:LogicalTableName>string</tns:LogicalTableName>
          <tns:PrimaryKeyName>string</tns:PrimaryKeyName>
          <tns:HiddenFromUser>true</tns:HiddenFromUser>
          <tns:ExtendedAttributes>
            <tns:Scripts>
              <tns:TableName>string</tns:TableName>
              <tns:InsertScript>string</tns:InsertScript>
              <tns:UpdateScript>string</tns:UpdateScript>
              <tns:DeleteScript>string</tns:DeleteScript>
              <tns:InsertScriptEnabled>true</tns:InsertScriptEnabled>
              <tns:UpdateScriptEnabled>true</tns:UpdateScriptEnabled>
              <tns:DeleteScriptEnabled>true</tns:DeleteScriptEnabled>
            </tns:Scripts>
            <tns:DefaultValues>
              <tns:TDefaultValue>
                <tns:FieldName>string</tns:FieldName>
                <tns:DefaultValue>string</tns:DefaultValue>
              </tns:TDefaultValue>
            </tns:DefaultValues>
            <tns:MandatoryFields/>
            <tns:UserFields>
              <tns:TUserField>
                <tns:TableId>100</tns:TableId>
                <tns:FieldId>100</tns:FieldId>
                <tns:TableName>string</tns:TableName>
                <tns:FieldName>string</tns:FieldName>
                <tns:DisplayName>string</tns:DisplayName>
                <tns:LookupType>ltNone</tns:LookupType>
                <tns:LookupList>
                  <tns:TUserFieldLookup>
                    <tns:Index>100</tns:Index>
                    <tns:Caption>string</tns:Caption>
                    <tns:Description>string</tns:Description>
                    <tns:BackgroundColour>string</tns:BackgroundColour>
                    <tns:FontColour>string</tns:FontColour>
                    <tns:FontBold>true</tns:FontBold>
                    <tns:FontItalic>true</tns:FontItalic>
                    <tns:FontUnderline>true</tns:FontUnderline>
                  </tns:TUserFieldLookup>
                </tns:LookupList>
                <tns:SystemField>true</tns:SystemField>
                <tns:ReadOnly>true</tns:ReadOnly>
                <tns:Selectable>true</tns:Selectable>
                <tns:ReadOnlyProperties>true</tns:ReadOnlyProperties>
                <tns:StoreRevisions>true</tns:StoreRevisions>
                <tns:HiddenInAdmin>true</tns:HiddenInAdmin>
                <tns:HiddenColumn>true</tns:HiddenColumn>
                <tns:FixedColumn>true</tns:FixedColumn>
                <tns:DoNotExport>true</tns:DoNotExport>
                <tns:DisplayAsURL>true</tns:DisplayAsURL>
                <tns:UnavailableForDiscoveries>true</tns:UnavailableForDiscoveries>
                <tns:Mandatory>true</tns:Mandatory>
                <tns:BackgroundColour>string</tns:BackgroundColour>
                <tns:FontColour>string</tns:FontColour>
                <tns:FontBold>true</tns:FontBold>
                <tns:FontItalic>true</tns:FontItalic>
                <tns:FontUnderline>true</tns:FontUnderline>
                <tns:ColumnIndex>100</tns:ColumnIndex>
                <tns:DefaultColumnWidth>100</tns:DefaultColumnWidth>
                <tns:DefaultValue>string</tns:DefaultValue>
                <tns:EditMask>string</tns:EditMask>
                <tns:FieldSize>100</tns:FieldSize>
                <tns:FieldType>edatUnknown</tns:FieldType>
                <tns:FieldTypeDescription>string</tns:FieldTypeDescription>
                <tns:Indexed>fitNone</tns:Indexed>
                <tns:FieldDelimiters>string</tns:FieldDelimiters>
                <tns:Weight>100</tns:Weight>
              </tns:TUserField>
            </tns:UserFields>
            <tns:Tag>100</tns:Tag>
          </tns:ExtendedAttributes>
        </tns:TUserTable>
      </tns:Result>
    </tns:EasyIPCore___GetUserTablesResponse>
  </soap:Body>
</soap:Envelope>

Modified at 2024-08-16 15:09:27

GetUserPrivileges

GetVirtualDirectories