Method Name : updIntegrationTable

  • Purpose of usage :

Service method used to update Allowed Integration Tables in Axata WMS System

  • Table Update request Fields :


Field Name

Description

Mandatory

TableName

Table Name to be updated

None

UpdateField

Field Name to Update

None

UpdateValue

Value to Update

None

IDField

Unique Key key field name to be used to query the rows to be updated

None

IDValues (Array)

Unique Key key field value list to be used to query the rows to be updated

None


  • Update Permission data Table and fields :

Update Table Name

Query Field

Update Field

ENT024

S24SIRA

S24STAT

ENT006

S06SIRA

S06STAT

ENT016_MST

S16ID

S16STAT

ENT016_IRS

S16SIRA

S16STAT

ENT044

S44ID

S44STAT

ENT0077

S77ID

S77STAT

 Usage :

    • Multiple ID values can be sent simultaneously .
    • Not all fields have to be submitted.
    • If generating XML for submission, the fields should be submitted in the order in the table above..
    • Maximum number of return lines is limited (Parametric).
    • Attempts outside of allowed tables or fields return an error


  • Sample XML
    • Request :

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:tem="http://tempuri.org/" xmlns:axat="http://axatawms">

  <soapenv:Header/>

  <soapenv:Body>

    <tem:username>axataservice</tem:username>

    <tem:password></tem:password>

    <axat:Table>

      <TableName>ENT016_MST</TableName>

      <UpdateField>S16STAT</UpdateField>

      <UpdateValue>1</UpdateValue>

      <IDField>S16ID</IDField>

      <IDValues>

        <!--Zero or more repetitions:-->

        <IDValue>1</IDValue>

        <IDValue>2</IDValue>

        <IDValue>3</IDValue>

      </IDValues>

    </axat:Table>

  </soapenv:Body>

</soapenv:Envelope>

    • Response :

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">

  <s:Body>

    <state>0</state>

    <message>Success</message>

    <processResult xmlns:i="http://www.w3.org/2001/XMLSchema-instance">

      <ProcessResult>

        <LogState>0</LogState>

        <LogMessage>Success</LogMessage>

        <EntityID>0</EntityID>

        <EntityCompany i:nil="true"/>

        <EntityCode>1</EntityCode>

        <EntitySubCode i:nil="true"/>

        <HeaderExt1 i:nil="true"/>

        <HeaderExt2 i:nil="true"/>

        <HeaderExt3 i:nil="true"/>

        <ResultItems/>

      </ProcessResult>

      <ProcessResult>

        <LogState>0</LogState>

        <LogMessage>Success</LogMessage>

        <EntityID>0</EntityID>

        <EntityCompany i:nil="true"/>

        <EntityCode>2</EntityCode>

        <EntitySubCode i:nil="true"/>

        <HeaderExt1 i:nil="true"/>

        <HeaderExt2 i:nil="true"/>

        <HeaderExt3 i:nil="true"/>

        <ResultItems/>

      </ProcessResult>

      <ProcessResult>

        <LogState>0</LogState>

        <LogMessage>Success</LogMessage>

        <EntityID>0</EntityID>

        <EntityCompany i:nil="true"/>

        <EntityCode>3</EntityCode>

        <EntitySubCode i:nil="true"/>

        <HeaderExt1 i:nil="true"/>

        <HeaderExt2 i:nil="true"/>

        <HeaderExt3 i:nil="true"/>

        <ResultItems/>

      </ProcessResult>

    </processResult>

  </s:Body>

</s:Envelope>