1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Fetch List of States Company Wise from Tally through XML

Discussion in 'Tally Integration' started by Rajan Mourya, Jan 25, 2022.

    
Tags:
  1. Rajan Mourya

    Rajan Mourya Member


    I need to fetch the List of States from the tally.
     
    Rajan Mourya, Jan 25, 2022
    #1


  2. Sai Vineeth

    Sai Vineeth Active Member


    Code:
    <ENVELOPE>
    <HEADER>
        <VERSION>1</VERSION>
        <TALLYREQUEST>Export</TALLYREQUEST>
        <TYPE>Collection</TYPE>
        <ID>CustColl</ID>
    </HEADER>
    <BODY>
        <DESC>
   
            <TDL>
                <TDLMESSAGE>
                    <COLLECTION ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="CustColl">
                        <USE>EAT State</USE>
                        <!-- * will fetch all fields if you want specific fields you can specify -->
                        <NATIVEMETHOD>*</NATIVEMETHOD>
                    </COLLECTION>
                </TDLMESSAGE>
            </TDL>
        </DESC>
    </BODY>
</ENVELOPE>
     
    Last edited: Jan 25, 2022
    Sai Vineeth, Jan 25, 2022
    #2


  3. Rajan Mourya

    Rajan Mourya Member


    Thanks for sharing this XML but it is not giving any data I am receiving this response from the tally
    <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>
    <LBTCLASSIFICATION>0</LBTCLASSIFICATION>
    <TAXUNIT>0</TAXUNIT>
    <RETURNMASTER>0</RETURNMASTER>
    <VOUCHER>0</VOUCHER>
    </CMPINFO>
    </DESC>
    <DATA>
    <COLLECTION ISMSTDEPTYPE="Yes" MSTDEPTYPE="65536"> </COLLECTION>
    </DATA>
    </BODY>
    </ENVELOPE>
     
    Rajan Mourya, Jan 25, 2022
    #3


  4. Sai Vineeth

    Sai Vineeth Active Member


    Screenshot (71).png Did you opened any company in Tally?
    I made some changes to xml did you taken that to account?
    For me both xmls are working
     
    Sai Vineeth, Jan 25, 2022
    #4


  5. Rajan Mourya

    Rajan Mourya Member


    Yes I did apply your new changes and I have select the company in tally, still I am not getting the response.
    <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>
    <LBTCLASSIFICATION>0</LBTCLASSIFICATION>
    <TAXUNIT>0</TAXUNIT>
    <RETURNMASTER>0</RETURNMASTER>
    <VOUCHER>0</VOUCHER>
    </CMPINFO>
    </DESC>
    <DATA>
    <COLLECTION ISMSTDEPTYPE="Yes" MSTDEPTYPE="65536"> </COLLECTION>
    </DATA>
    </BODY>
    </ENVELOPE>
     
    Rajan Mourya, Jan 25, 2022
    #5


  6. Rajan Mourya

    Rajan Mourya Member


    Please share that postman collection if possible.
     
    Rajan Mourya, Jan 25, 2022
    #6


  7. Rajan Mourya

    Rajan Mourya Member


    I am using tally prime gold edition.
     
    Rajan Mourya, Jan 25, 2022
    #7


  8. Sai Vineeth

    Sai Vineeth Active Member


    Your sending xml through?
    Tally Version?
     
    Sai Vineeth, Jan 25, 2022
    #8


  9. Rajan Mourya

    Rajan Mourya Member


    I am sending xml through Postman.
    Version: Tally Prime Gold 2.0.1
     
    Rajan Mourya, Jan 25, 2022
    #9


  10. Sai Vineeth

    Sai Vineeth Active Member

    Sai Vineeth, Jan 25, 2022
    #10


  11. Rajan Mourya

    Rajan Mourya Member


    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <TALLYREQUEST>Export</TALLYREQUEST>
    <TYPE>Collection</TYPE>
    <ID>CustColl</ID>
    </HEADER>
    <BODY>
    <DESC>
    <TDL>
    <TDLMESSAGE>
    <COLLECTION ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="CustColl">
    <USE>EAT State</USE>
    <!-- * will fetch all fields if you want specific fields you can specify -->
    <NATIVEMETHOD>*</NATIVEMETHOD>
    </COLLECTION>
    </TDLMESSAGE>
    </TDL>
    </DESC>
    </BODY>
    </ENVELOPE>

    XML Which i am sending.
     
    Rajan Mourya, Jan 25, 2022
    #11


  12. Sai Vineeth

    Sai Vineeth Active Member


    I am also using same
    Do you have any tdls loaded?
     
    Sai Vineeth, Jan 25, 2022
    #12


  13. Rajan Mourya

    Rajan Mourya Member


    No
     
    Rajan Mourya, Jan 25, 2022
    #13


  14. Rajan Mourya

    Rajan Mourya Member


    Please add this request to the postman collection.
     
    Rajan Mourya, Jan 25, 2022
    #14


  15. Sai Vineeth

    Sai Vineeth Active Member


    What about other requests are they working correctly?
     
    Sai Vineeth, Jan 25, 2022
    #15


  16. Rajan Mourya

    Rajan Mourya Member


    Yes, others are working.
     
    Rajan Mourya, Jan 25, 2022
    #16
    Sai Vineeth likes this.


  17. Rajan Mourya

    Rajan Mourya Member


    Is it possible to connect with you through another mode of communication?
     
    Rajan Mourya, Jan 25, 2022
    #17


  18. Sai Vineeth

    Sai Vineeth Active Member

    Sai Vineeth, Jan 25, 2022
    #18


  19. Rajan Mourya

    Rajan Mourya Member

    Rajan Mourya, Jan 25, 2022
    #19


  20. Sai Vineeth

    Sai Vineeth Active Member


    If follow link it automatically opens that request only
    Name - List of States
    It will be in Collections folder
     
    Last edited: Jan 25, 2022
    Sai Vineeth, Jan 25, 2022
    #20


  21. Rajan Mourya

    Rajan Mourya Member


    I tried the XML but still getting the same response.
     
    Rajan Mourya, Jan 25, 2022
    #21


  22. Sai Vineeth

    Sai Vineeth Active Member


    I found ,If company is created in Tally prime that xml is not working
    use below xml
    Code:
    <ENVELOPE>
    <HEADER>
        <VERSION>1</VERSION>
        <TALLYREQUEST>Export</TALLYREQUEST>
        <TYPE>Collection</TYPE>
        <ID>CustColl</ID>
    </HEADER>
    <BODY>
        <DESC>
            <TDL>
                <TDLMESSAGE>
                    <COLLECTION ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="CustColl">
                        <!-- * Source TDL - src/bizcommon/statescoll.tdl -->
                        <USE>Listofstates</USE>
                        <!-- * will fetch all fields if you want specific fields you can specify -->
                        <NATIVEMETHOD>*</NATIVEMETHOD>
                    </COLLECTION>
                </TDLMESSAGE>
            </TDL>
        </DESC>
    </BODY>
</ENVELOPE>
     
    Sai Vineeth, Jan 25, 2022
    #22


  23. Rajan Mourya

    Rajan Mourya Member


    Thanks, this one is working
     
    Rajan Mourya, Jan 25, 2022
    #23
    Sai Vineeth likes this.


Share This Page