POST api/W2Scan/encryptData

Request Information

URI Parameters

None.

Body Parameters

GenericParameter
NameDescriptionTypeAdditional information
TableName

string

None.

ProcedureName

string

None.

SelectColumn

Collection of string

None.

WhereColumn

Collection of Pair of string [key] and string [value]

None.

InsertUpdateColumn

Collection of Pair of string [key] and string [value]

None.

WhereAndOr

string

None.

Returns

Collection of Collection of Pair of string [key] and string [value]

None.

ReturnParameterColumn

string

None.

ReturnParameterValue

string

None.

DecryptColumnNames

Collection of string

None.

EncryptColumnNames

Collection of string

None.

EncryptIpColumnNames

Collection of Pair of string [key] and string [value]

None.

DecryptIpColumnNames

Collection of Pair of string [key] and string [value]

None.

DecryptCommonIpList

Collection of Pair of string [key] and string [value]

None.

Success

boolean

None.

ErrorMessage

string

None.

SuccessMessage

string

None.

Input

Collection of Pair of string [key] and string [value]

None.

InputInsertList

Collection of Collection of Pair of string [key] and string [value]

None.

ExceptionColumn

Collection of Pair of string [key] and Exception [value]

None.

EncryptColList

Collection of Pair of string [key] and string [value]

None.

DecryptColList

Collection of Pair of string [key] and string [value]

None.

Request Formats

application/json, text/json

Sample:
{
  "TableName": "sample string 1",
  "ProcedureName": "sample string 2",
  "SelectColumn": [
    "sample string 1",
    "sample string 2"
  ],
  "WhereColumn": [
    {
      "Key": "sample string 1",
      "Value": "sample string 2"
    },
    {
      "Key": "sample string 1",
      "Value": "sample string 2"
    }
  ],
  "InsertUpdateColumn": [
    {
      "Key": "sample string 1",
      "Value": "sample string 2"
    },
    {
      "Key": "sample string 1",
      "Value": "sample string 2"
    }
  ],
  "WhereAndOr": "sample string 3",
  "Returns": [
    [
      {
        "Key": "sample string 1",
        "Value": "sample string 2"
      },
      {
        "Key": "sample string 1",
        "Value": "sample string 2"
      }
    ],
    [
      {
        "Key": "sample string 1",
        "Value": "sample string 2"
      },
      {
        "Key": "sample string 1",
        "Value": "sample string 2"
      }
    ]
  ],
  "ReturnParameterColumn": "sample string 4",
  "ReturnParameterValue": "sample string 5",
  "DecryptColumnNames": [
    "sample string 1",
    "sample string 2"
  ],
  "EncryptColumnNames": [
    "sample string 1",
    "sample string 2"
  ],
  "EncryptIpColumnNames": [
    {
      "Key": "sample string 1",
      "Value": "sample string 2"
    },
    {
      "Key": "sample string 1",
      "Value": "sample string 2"
    }
  ],
  "DecryptIpColumnNames": [
    {
      "Key": "sample string 1",
      "Value": "sample string 2"
    },
    {
      "Key": "sample string 1",
      "Value": "sample string 2"
    }
  ],
  "DecryptCommonIpList": [
    {
      "Key": "sample string 1",
      "Value": "sample string 2"
    },
    {
      "Key": "sample string 1",
      "Value": "sample string 2"
    }
  ],
  "Success": true,
  "ErrorMessage": "sample string 7",
  "SuccessMessage": "sample string 8",
  "Input": [
    {
      "Key": "sample string 1",
      "Value": "sample string 2"
    },
    {
      "Key": "sample string 1",
      "Value": "sample string 2"
    }
  ],
  "InputInsertList": [
    [
      {
        "Key": "sample string 1",
        "Value": "sample string 2"
      },
      {
        "Key": "sample string 1",
        "Value": "sample string 2"
      }
    ],
    [
      {
        "Key": "sample string 1",
        "Value": "sample string 2"
      },
      {
        "Key": "sample string 1",
        "Value": "sample string 2"
      }
    ]
  ],
  "ExceptionColumn": [
    {
      "Key": "sample string 1",
      "Value": {
        "ClassName": "System.Exception",
        "Message": null,
        "Data": null,
        "InnerException": null,
        "HelpURL": "sample string 1",
        "StackTraceString": null,
        "RemoteStackTraceString": null,
        "RemoteStackIndex": 0,
        "ExceptionMethod": null,
        "HResult": 3,
        "Source": "sample string 2",
        "WatsonBuckets": null
      }
    },
    {
      "Key": "sample string 1",
      "Value": {
        "ClassName": "System.Exception",
        "Message": null,
        "Data": null,
        "InnerException": null,
        "HelpURL": "sample string 1",
        "StackTraceString": null,
        "RemoteStackTraceString": null,
        "RemoteStackIndex": 0,
        "ExceptionMethod": null,
        "HResult": 3,
        "Source": "sample string 2",
        "WatsonBuckets": null
      }
    }
  ],
  "EncryptColList": [
    {
      "Key": "sample string 1",
      "Value": "sample string 2"
    },
    {
      "Key": "sample string 1",
      "Value": "sample string 2"
    }
  ],
  "DecryptColList": [
    {
      "Key": "sample string 1",
      "Value": "sample string 2"
    },
    {
      "Key": "sample string 1",
      "Value": "sample string 2"
    }
  ]
}

application/xml, text/xml

Sample:
<GenericParameter xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/EtaxService.Model">
  <DecryptColList xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic">
    <d2p1:KeyValuePairOfstringstring>
      <d2p1:key>sample string 1</d2p1:key>
      <d2p1:value>sample string 2</d2p1:value>
    </d2p1:KeyValuePairOfstringstring>
    <d2p1:KeyValuePairOfstringstring>
      <d2p1:key>sample string 1</d2p1:key>
      <d2p1:value>sample string 2</d2p1:value>
    </d2p1:KeyValuePairOfstringstring>
  </DecryptColList>
  <DecryptColumnNames xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>sample string 1</d2p1:string>
    <d2p1:string>sample string 2</d2p1:string>
  </DecryptColumnNames>
  <DecryptCommonIpList xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic">
    <d2p1:KeyValuePairOfstringstring>
      <d2p1:key>sample string 1</d2p1:key>
      <d2p1:value>sample string 2</d2p1:value>
    </d2p1:KeyValuePairOfstringstring>
    <d2p1:KeyValuePairOfstringstring>
      <d2p1:key>sample string 1</d2p1:key>
      <d2p1:value>sample string 2</d2p1:value>
    </d2p1:KeyValuePairOfstringstring>
  </DecryptCommonIpList>
  <DecryptIpColumnNames xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic">
    <d2p1:KeyValuePairOfstringstring>
      <d2p1:key>sample string 1</d2p1:key>
      <d2p1:value>sample string 2</d2p1:value>
    </d2p1:KeyValuePairOfstringstring>
    <d2p1:KeyValuePairOfstringstring>
      <d2p1:key>sample string 1</d2p1:key>
      <d2p1:value>sample string 2</d2p1:value>
    </d2p1:KeyValuePairOfstringstring>
  </DecryptIpColumnNames>
  <EncryptColList xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic">
    <d2p1:KeyValuePairOfstringstring>
      <d2p1:key>sample string 1</d2p1:key>
      <d2p1:value>sample string 2</d2p1:value>
    </d2p1:KeyValuePairOfstringstring>
    <d2p1:KeyValuePairOfstringstring>
      <d2p1:key>sample string 1</d2p1:key>
      <d2p1:value>sample string 2</d2p1:value>
    </d2p1:KeyValuePairOfstringstring>
  </EncryptColList>
  <EncryptColumnNames xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>sample string 1</d2p1:string>
    <d2p1:string>sample string 2</d2p1:string>
  </EncryptColumnNames>
  <EncryptIpColumnNames xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic">
    <d2p1:KeyValuePairOfstringstring>
      <d2p1:key>sample string 1</d2p1:key>
      <d2p1:value>sample string 2</d2p1:value>
    </d2p1:KeyValuePairOfstringstring>
    <d2p1:KeyValuePairOfstringstring>
      <d2p1:key>sample string 1</d2p1:key>
      <d2p1:value>sample string 2</d2p1:value>
    </d2p1:KeyValuePairOfstringstring>
  </EncryptIpColumnNames>
  <ErrorMessage>sample string 7</ErrorMessage>
  <ExceptionColumn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic">
    <d2p1:KeyValuePairOfstringExceptionU6ho3Bhd>
      <d2p1:key>sample string 1</d2p1:key>
      <d2p1:value xmlns:d4p1="http://schemas.datacontract.org/2004/07/System">
        <ClassName xmlns:d5p1="http://www.w3.org/2001/XMLSchema" i:type="d5p1:string" xmlns="">System.Exception</ClassName>
        <Message i:nil="true" xmlns="" />
        <Data i:nil="true" xmlns="" />
        <InnerException i:nil="true" xmlns="" />
        <HelpURL xmlns:d5p1="http://www.w3.org/2001/XMLSchema" i:type="d5p1:string" xmlns="">sample string 1</HelpURL>
        <StackTraceString i:nil="true" xmlns="" />
        <RemoteStackTraceString i:nil="true" xmlns="" />
        <RemoteStackIndex xmlns:d5p1="http://www.w3.org/2001/XMLSchema" i:type="d5p1:int" xmlns="">0</RemoteStackIndex>
        <ExceptionMethod i:nil="true" xmlns="" />
        <HResult xmlns:d5p1="http://www.w3.org/2001/XMLSchema" i:type="d5p1:int" xmlns="">3</HResult>
        <Source xmlns:d5p1="http://www.w3.org/2001/XMLSchema" i:type="d5p1:string" xmlns="">sample string 2</Source>
        <WatsonBuckets i:nil="true" xmlns="" />
      </d2p1:value>
    </d2p1:KeyValuePairOfstringExceptionU6ho3Bhd>
    <d2p1:KeyValuePairOfstringExceptionU6ho3Bhd>
      <d2p1:key>sample string 1</d2p1:key>
      <d2p1:value xmlns:d4p1="http://schemas.datacontract.org/2004/07/System">
        <ClassName xmlns:d5p1="http://www.w3.org/2001/XMLSchema" i:type="d5p1:string" xmlns="">System.Exception</ClassName>
        <Message i:nil="true" xmlns="" />
        <Data i:nil="true" xmlns="" />
        <InnerException i:nil="true" xmlns="" />
        <HelpURL xmlns:d5p1="http://www.w3.org/2001/XMLSchema" i:type="d5p1:string" xmlns="">sample string 1</HelpURL>
        <StackTraceString i:nil="true" xmlns="" />
        <RemoteStackTraceString i:nil="true" xmlns="" />
        <RemoteStackIndex xmlns:d5p1="http://www.w3.org/2001/XMLSchema" i:type="d5p1:int" xmlns="">0</RemoteStackIndex>
        <ExceptionMethod i:nil="true" xmlns="" />
        <HResult xmlns:d5p1="http://www.w3.org/2001/XMLSchema" i:type="d5p1:int" xmlns="">3</HResult>
        <Source xmlns:d5p1="http://www.w3.org/2001/XMLSchema" i:type="d5p1:string" xmlns="">sample string 2</Source>
        <WatsonBuckets i:nil="true" xmlns="" />
      </d2p1:value>
    </d2p1:KeyValuePairOfstringExceptionU6ho3Bhd>
  </ExceptionColumn>
  <Input xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic">
    <d2p1:KeyValuePairOfstringstring>
      <d2p1:key>sample string 1</d2p1:key>
      <d2p1:value>sample string 2</d2p1:value>
    </d2p1:KeyValuePairOfstringstring>
    <d2p1:KeyValuePairOfstringstring>
      <d2p1:key>sample string 1</d2p1:key>
      <d2p1:value>sample string 2</d2p1:value>
    </d2p1:KeyValuePairOfstringstring>
  </Input>
  <InputInsertList xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic">
    <d2p1:ArrayOfKeyValuePairOfstringstring>
      <d2p1:KeyValuePairOfstringstring>
        <d2p1:key>sample string 1</d2p1:key>
        <d2p1:value>sample string 2</d2p1:value>
      </d2p1:KeyValuePairOfstringstring>
      <d2p1:KeyValuePairOfstringstring>
        <d2p1:key>sample string 1</d2p1:key>
        <d2p1:value>sample string 2</d2p1:value>
      </d2p1:KeyValuePairOfstringstring>
    </d2p1:ArrayOfKeyValuePairOfstringstring>
    <d2p1:ArrayOfKeyValuePairOfstringstring>
      <d2p1:KeyValuePairOfstringstring>
        <d2p1:key>sample string 1</d2p1:key>
        <d2p1:value>sample string 2</d2p1:value>
      </d2p1:KeyValuePairOfstringstring>
      <d2p1:KeyValuePairOfstringstring>
        <d2p1:key>sample string 1</d2p1:key>
        <d2p1:value>sample string 2</d2p1:value>
      </d2p1:KeyValuePairOfstringstring>
    </d2p1:ArrayOfKeyValuePairOfstringstring>
  </InputInsertList>
  <InsertUpdateColumn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic">
    <d2p1:KeyValuePairOfstringstring>
      <d2p1:key>sample string 1</d2p1:key>
      <d2p1:value>sample string 2</d2p1:value>
    </d2p1:KeyValuePairOfstringstring>
    <d2p1:KeyValuePairOfstringstring>
      <d2p1:key>sample string 1</d2p1:key>
      <d2p1:value>sample string 2</d2p1:value>
    </d2p1:KeyValuePairOfstringstring>
  </InsertUpdateColumn>
  <ProcedureName>sample string 2</ProcedureName>
  <ReturnParameterColumn>sample string 4</ReturnParameterColumn>
  <ReturnParameterValue>sample string 5</ReturnParameterValue>
  <Returns xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic">
    <d2p1:ArrayOfKeyValuePairOfstringstring>
      <d2p1:KeyValuePairOfstringstring>
        <d2p1:key>sample string 1</d2p1:key>
        <d2p1:value>sample string 2</d2p1:value>
      </d2p1:KeyValuePairOfstringstring>
      <d2p1:KeyValuePairOfstringstring>
        <d2p1:key>sample string 1</d2p1:key>
        <d2p1:value>sample string 2</d2p1:value>
      </d2p1:KeyValuePairOfstringstring>
    </d2p1:ArrayOfKeyValuePairOfstringstring>
    <d2p1:ArrayOfKeyValuePairOfstringstring>
      <d2p1:KeyValuePairOfstringstring>
        <d2p1:key>sample string 1</d2p1:key>
        <d2p1:value>sample string 2</d2p1:value>
      </d2p1:KeyValuePairOfstringstring>
      <d2p1:KeyValuePairOfstringstring>
        <d2p1:key>sample string 1</d2p1:key>
        <d2p1:value>sample string 2</d2p1:value>
      </d2p1:KeyValuePairOfstringstring>
    </d2p1:ArrayOfKeyValuePairOfstringstring>
  </Returns>
  <SelectColumn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>sample string 1</d2p1:string>
    <d2p1:string>sample string 2</d2p1:string>
  </SelectColumn>
  <Success>true</Success>
  <SuccessMessage>sample string 8</SuccessMessage>
  <TableName>sample string 1</TableName>
  <WhereAndOr>sample string 3</WhereAndOr>
  <WhereColumn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic">
    <d2p1:KeyValuePairOfstringstring>
      <d2p1:key>sample string 1</d2p1:key>
      <d2p1:value>sample string 2</d2p1:value>
    </d2p1:KeyValuePairOfstringstring>
    <d2p1:KeyValuePairOfstringstring>
      <d2p1:key>sample string 1</d2p1:key>
      <d2p1:value>sample string 2</d2p1:value>
    </d2p1:KeyValuePairOfstringstring>
  </WhereColumn>
</GenericParameter>

application/x-www-form-urlencoded

Sample:

Sample not available.

Response Information

Resource Description

Collection of Collection of byte

Response Formats

application/json, text/json

Sample:
[
  "QEA=",
  "QEA="
]

application/xml, text/xml

Sample:
<ArrayOfbase64Binary xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
  <base64Binary>QEA=</base64Binary>
  <base64Binary>QEA=</base64Binary>
</ArrayOfbase64Binary>