Fetching collection object fields data

Discussion in 'Tally Integration' started by Noor Hussain Ladkhan, Oct 15, 2012.

    

  1. Dear Experts,

    Please let me know how to fetch specific column values from collection object. I am trying to fetch the Name and Guid fields from Company collection object using the below xml. But it is fetching only company name. Please let me know where I am going wrong. The xml is
    Code:
    <ENVELOPE>
        <HEADER>
                <VERSION>1</VERSION>
                <TALLYREQUEST>Export</TALLYREQUEST>
                <TYPE>Collection</TYPE>
                <ID>Company</ID>
        </HEADER>
    <BODY>
    <DESC>
    <STATICVARIABLES>
                              <EXPLODEFLAG>Yes</EXPLODEFLAG>
                              <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
                    </STATICVARIABLES>
    <FETCHLIST>
    <FETCH>Name</FETCH>
    <FETCH>Guid</FETCH>
    </FETCHLIST>
    </DESC>
     
    </BODY>
    </ENVELOPE>
    And the corresponding response is

    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <STATUS>1</STATUS>
    </HEADER>
    <BODY>
    <DESC>
    <CMPINFO>
    <COMPANY>0</COMPANY>
    <GROUP>0</GROUP>
    <LEDGER>0</LEDGER>
    <COSTCATEGORY>0</COSTCATEGORY>
    <COSTCENTRE>0</COSTCENTRE>
    <GODOWN>0</GODOWN>
    <STOCKGROUP>0</STOCKGROUP>
    <STOCKCATEGORY>0</STOCKCATEGORY>
    <STOCKITEM>0</STOCKITEM>
    <VOUCHERTYPE>0</VOUCHERTYPE>
    <CURRENCY>0</CURRENCY>
    <UNIT>0</UNIT>
    <BUDGET>0</BUDGET>
    <CLIENTRULE>0</CLIENTRULE>
    <SERVERRULE>0</SERVERRULE>
    <STATE>0</STATE>
    <TDSRATE>0</TDSRATE>
    <TAXCLASSIFICATION>0</TAXCLASSIFICATION>
    <STCATEGORY>0</STCATEGORY>
    <DEDUCTEETYPE>0</DEDUCTEETYPE>
    <ATTENDANCETYPE>0</ATTENDANCETYPE>
    <FBTCATEGORY>0</FBTCATEGORY>
    <FBTASSESSEETYPE>0</FBTASSESSEETYPE>
    <TARIFFCLASSIFICATION>0</TARIFFCLASSIFICATION>
    <EXCISEDUTYCLASSIFICATION>0</EXCISEDUTYCLASSIFICATION>
    <SERIALNUMBER>0</SERIALNUMBER>
    <ADJUSTMENTCLASSIFICATION>0</ADJUSTMENTCLASSIFICATION>
    <INCOMETAXSLAB>0</INCOMETAXSLAB>
    <INCOMETAXCLASSIFICATION>0</INCOMETAXCLASSIFICATION>
    <VOUCHER>0</VOUCHER>
    </CMPINFO>
    </DESC>
    <DATA>
    <COLLECTION>
    <COMPANY NAME="BNB Software Solutions Ltd" RESERVEDNAME="">
    <NAME TYPE="String">BNB Software Solutions Ltd</NAME>
    </COMPANY>
    </COLLECTION>
    </DATA>
    </BODY>
    </ENVELOPE>

    Please let me know where I am going wrong

    Thanks and regards,
    Noor Hussain
     
    Ajay singh likes this.


Share This Page