Avoid attribute in xml response

Discussion in 'Tally Integration' started by Researcher1, May 17, 2023.

    
  1. Researcher1

    Researcher1 Member


    Code:
    <ENVELOPE>
        <HEADER>
            <VERSION>1</VERSION>
            <TALLYREQUEST>EXPORT</TALLYREQUEST>
            <TYPE>COLLECTION</TYPE>
            <ID>CUSTOMVoucherCOL</ID>
        </HEADER>
        <BODY>
            <DESC>
                <STATICVARIABLES>
                    <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT><SVFROMDATE TYPE='Date'>20220216</SVFROMDATE>
                     <SVTODATE TYPE='Date'>20220216</SVTODATE>
                </STATICVARIABLES>
                <TDL>
                    <TDLMESSAGE>
                        <COLLECTION ISMODIFY='No' ISFIXED='No' ISINITIALIZE='No' ISOPTION='No' ISINTERNAL='No' NAME='CUSTOMVoucherCOL'>
                            <TYPE>Voucher</TYPE>
                            <FETCH>ALLLEDGERENTRIES.LIST,BANKALLOCATIONS.LIST,LEDGERENTRIES.LIST</FETCH>                         
                        </COLLECTION>
                    </TDLMESSAGE>
                </TDL>
            </DESC>
        </BODY>
    </ENVELOPE>
    Using above XML request I am able to get below XML response.
    Response :-
    Code:
     <ALLLEDGERENTRIES.LIST>
        ...
          <LEDGERNAME TYPE="String">Ratankar Bank Saving A/c No.0900</LEDGERNAME>
          <TDSPARTYNAME TYPE="String"></TDSPARTYNAME>
          <GSTCLASS TYPE="String">&#4; Not Applicable</GSTCLASS>
          <ISDEEMEDPOSITIVE TYPE="Logical">Yes</ISDEEMEDPOSITIVE>
          <LEDGERFROMITEM TYPE="Logical">No</LEDGERFROMITEM>
          <ISPARTYLEDGER TYPE="Logical">Yes</ISPARTYLEDGER>
        ...
         </ALLLEDGERENTRIES.LIST>
    Is there any way to avoid TYPE attributes in the XML response
    (i.e. In response is it possible to get
    Code:
    <LEDGERNAME>Ratankar Bank Saving A/c No.0900</LEDGERNAME>
    instead of
    Code:
    <LEDGERNAME TYPE="String">Ratankar Bank Saving A/c No.0900</LEDGERNAME>
    ) and how to fetch only specified child tags inside the specific parent tag using XML request?
     


  2. Sai Vineeth

    Sai Vineeth Active Member


    you can ignore the attributes, if you don't want.

    fetch only specified child tags inside the specific parent tag using XML request?
    This depends on which language you are using to parse xml
     


  3. Researcher1

    Researcher1 Member


    I'm using VB.NET.
    I wanted to know that is it possible to fetch only specified child tags inside the specific parent tag using XML request.
     


  4. Sai Vineeth

    Sai Vineeth Active Member


    Where is the code you tried?
     


Share This Page