Tally Prime Integration Using JSON - Report-based export in JSON format

Question

This is regarding an issue I'm facing in Report-based Export in JSON Format from Tally Prime for Integration Using JSON.

We need to have the HTTP POST Request as per the below format/example: [ { "customerCode":"Asc871", "customerName":"asxcshwha", "currencyCode": "IDR", "longestDay": 13, "month": 7, "noteInfo": "222222", "overduePayment": 20, "paymentTerm": 5, "receivableBalance": 35, "sameMonthAmount": 10, "sameMonthPayment": 10, "sameYearIncome": 10, "thanNinetyOverdueAmount": 10, "thanSixtyOverdueAmount": 10, "thanThirtyOverdueAmount": 10, "year": 2022, "yearYtdPayment": 10 } ] HTTP POST Request format

However on generating the JSON data from Tally Prime it is being exported as below: { "": [ { "batchId": "00000", "customerCode": "Customer A", "customerName": "Customer A", "currencyCode": "QAR", "year": "2024", "month": "7", "receivableBalance": "355.00", "overduePayment": "0", "paymentTerm": "30 Days", "thanNinetyOverdueAmount": "355.00", "yearYtdPayment": "0", "sameYearIncome": "0" }, { "batchId": "00000", "customerCode": "Customer B", "customerName": "Customer B", "currencyCode": "QAR", "year": "2024", "month": "7", "receivableBalance": "320.00", "overduePayment": "0", "paymentTerm": "0", "thanNinetyOverdueAmount": "320.00", "yearYtdPayment": "0", "sameYearIncome": "0" }, { "batchId": "00000", "customerCode": "Customer C", "customerName": "Customer C", "currencyCode": "QAR", "year": "2024", "month": "7", "receivableBalance": "60.00", "overduePayment": "0", "paymentTerm": "0", "thanNinetyOverdueAmount": "60.00", "yearYtdPayment": "0", "sameYearIncome": "0" } ] }

You can notice the extra tags(with flower brackets) ({ "":) in the beginning of the JSON data in the above example comparing it with the format required. I.e., The JSON data format needs to start with the square brackets whereas it is starting with the flower brackets(curly braces). Could someone please guide me on how to remove those extra tags in the JSON data generated from Tally.

The below is the TDL code to understand the way the JSON Report is being constructed in Tally:

`[Report    : ReportBasedExportInJSONFormatTestRep] 
    
    Form    : UDDahuaIntegUpldAcctRcvbleJSONRep
    
    [Form   : UDDahuaIntegUpldAcctRcvbleJSONRep]
        
        Part    : UDDahuaIntegUpldAcctRcvbleJSONRepBody
        
        JSONTag : ""
        
        [Part   : UDDahuaIntegUpldAcctRcvbleJSONRepBody]
            
            Line    : UDDahuaIntegUpldAcctRcvbleJSONRepBody
            Repeat  : UDDahuaIntegUpldAcctRcvbleJSONRepBody : UDDahuaIntegAcctRcvbleRepUpldColl
            
            Scroll  : Vertical
            
            [Line   : UDDahuaIntegUpldAcctRcvbleJSONRepBody]
                
                Line    : UDDahuaIntegUpldRcvbleOSJSONRepBatchId    
                
                JSONTag : ""

                                 [Line  : UDDahuaIntegUpldRcvbleOSJSONRepBatchId]   
                    
                    Field   : Simple Field
                    Local   : Field : Simple Field  : JSONTag   : "batchId"
                    Local   : Field : Simple Field  : Set as    : "0000"`

TDL code for the JSON Report being constructed`

as of now tally TDL doesn't support list as root tag either change your format in server or use other language instead of TDL — sai vineeth
– sai vineeth, Commented Jul 17, 2024 at 12:31
Dear Mr.Sai Vineeth thank you for your response. Actually we are unable to change the format in server as it is a standard format used by a company for all it's customers. Would you be able to provide me with more inputs to use different language other than TDL ? I'm basically a TDL Programmer and so struggling a bit googling to understand how the job can be done using a different language. Basically in the HTTP POST Request from Tally the output to be JSON data which is directly as an array format without an enclosing object. — Abhilash S
– Abhilash S, Commented Jul 17, 2024 at 14:04

sai vineeth · Accepted Answer · 2024-07-18 06:01:43Z

1

As I mentioned in comment tally TDL does not support list tag as root Tag you can refer this means you cannot read or write list Json using TDL

Since you cannot change the server API structure you can use any other language as intermediary between tally and your server

Say C#: using XML API, you can get data from tally and transform using C# according to server format and post data to server

answered Jul 18, 2024 at 6:01

sai vineeth

1,0452 gold badges7 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

gurkan · Accepted Answer · 2024-07-31 16:06:38Z

0

First of all, you can't export data in JSON array without root Tag from Tally. As your HTTP Request you can't export that format data from the tally.

Solutions for this At the Part Level Define the JSON tag then only you will export the data. So new HTTP Body Will be like this

{
  "entries": [
    {
      "customerCode": "Asc871",
      "customerName": "asxcshwha",
      "currencyCode": "IDR",
      "longestDay": 13,
      "month": 7,
      "noteInfo": "222222",
      "overduePayment": 20,
      "paymentTerm": 5,
      "receivableBalance": 35,
      "sameMonthAmount": 10,
      "sameMonthPayment": 10,
      "sameYearIncome": 10,
      "thanNinetyOverdueAmount": 10,
      "thanSixtyOverdueAmount": 10,
      "thanThirtyOverdueAmount": 10,
      "year": 2022,
      "yearYtdPayment": 10
    }
  ]
}

If you don't want to define the Root Tag then there is another simple solution you can Create one DLL File and connect it with the TDL Using COM Interface.

edited Jul 31, 2024 at 16:06

gurkan

1,4707 gold badges20 silver badges29 bronze badges

answered Jul 29, 2024 at 6:07

Aakash Jain

477 bronze badges

1 Comment

Abhilash S Over a year ago

Thank you both for your valuable advise & support. Actually since it was not possible in Tally directly through TDL, finally the vendor company has agreed to modify their API to accomodate the JSON structure supported by Tally.

Collectives™ on Stack Overflow

Tally Prime Integration Using JSON - Report-based export in JSON format

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related