问题

For the given XML request, you want to limit the response to only include the "LedgerName" field under "ALLLEDGERENTRIES.LIST" and the "StockItemName" field under "INVENTORYALLOCATIONS.LIST." To achieve this, you can specify the desired fields in your request like this:

&lt;ENVELOPE&gt;
&lt;HEADER&gt;
&lt;VERSION&gt;1&lt;/VERSION&gt;
&lt;TALLYREQUEST&gt;Export&lt;/TALLYREQUEST&gt;
&lt;TYPE&gt;Collection&lt;/TYPE&gt;
&lt;ID&gt;Vouchers&lt;/ID&gt;
&lt;/HEADER&gt;
&lt;BODY&gt;
&lt;DESC&gt;
&lt;STATICVARIABLES&gt;
&lt;SVEXPORTFORMAT&gt;$$SysName:XML&lt;/SVEXPORTFORMAT&gt;
&lt;SVCURRENTCOMPANY&gt;CompanyName&lt;/SVCURRENTCOMPANY&gt;
&lt;SVFROMDATE TYPE=&quot;Date&quot;&gt;01-01-2023&lt;/SVFROMDATE&gt;
&lt;SVTODATE TYPE=&quot;Date&quot;&gt;01-01-2023&lt;/SVTODATE&gt;
&lt;/STATICVARIABLES&gt;
&lt;TDL&gt;
&lt;TDLMESSAGE&gt;
&lt;COLLECTION ISMODIFY=&quot;No&quot; ISFIXED=&quot;No&quot; ISINITIALIZE=&quot;No&quot; ISOPTION=&quot;No&quot;
ISINTERNAL=&quot;No&quot; NAME=&quot;Vouchers&quot;&gt;
&lt;TYPE&gt; Vouchers : VoucherType&lt;/TYPE&gt;
&lt;CHILDOF&gt;$$VchTypeSales&lt;/CHILDOF&gt;
&lt;BELONGSTO&gt;Yes&lt;/BELONGSTO&gt;
&lt;NATIVEMETHOD&gt;DATE&lt;/NATIVEMETHOD&gt;
&lt;NATIVEMETHOD&gt;VOUCHERTYPENAME&lt;/NATIVEMETHOD&gt;
&lt;NATIVEMETHOD&gt;ENTEREDBY&lt;/NATIVEMETHOD&gt;
&lt;NATIVEMETHOD&gt;PARTYLEDGERNAME&lt;/NATIVEMETHOD&gt;
&lt;NATIVEMETHOD&gt;VOUCHERNUMBER&lt;/NATIVEMETHOD&gt;
&lt;NATIVEMETHOD&gt;ALLLEDGERENTRIES.LIST:LEDGERNAME&lt;/NATIVEMETHOD&gt;
&lt;NATIVEMETHOD&gt;ALLLEDGERENTRIES.LIST:INVENTORYALLOCATIONS.LIST:STOCKITEMNAME&lt;/NATIVEMETHOD&gt;
&lt;/COLLECTION&gt;
&lt;/TDLMESSAGE&gt;
&lt;/TDL&gt;
&lt;/DESC&gt;
&lt;/BODY&gt;
&lt;/ENVELOPE&gt;

In this modified request, I have specified only the "LEDGERNAME" field under "ALLLEDGERENTRIES.LIST" and the "STOCKITEMNAME" field under "INVENTORYALLOCATIONS.LIST" to be included in the response.

英文:

&lt;ENVELOPE&gt;
&lt;HEADER&gt;
&lt;VERSION&gt;1&lt;/VERSION&gt;
&lt;TALLYREQUEST&gt;Export&lt;/TALLYREQUEST&gt;
&lt;TYPE&gt;Collection&lt;/TYPE&gt;
&lt;ID&gt;Vouchers&lt;/ID&gt;
&lt;/HEADER&gt;
&lt;BODY&gt;
&lt;DESC&gt;
&lt;STATICVARIABLES&gt;
&lt;SVEXPORTFORMAT&gt;$$SysName:XML&lt;/SVEXPORTFORMAT&gt;
&lt;SVCURRENTCOMPANY&gt;CompanyName&lt;/SVCURRENTCOMPANY&gt;
&lt;SVFROMDATE TYPE=&quot;Date&quot;&gt;01-01-2023&lt;/SVFROMDATE&gt;
&lt;SVTODATE TYPE=&quot;Date&quot;&gt;01-01-2023&lt;/SVTODATE&gt;
&lt;/STATICVARIABLES&gt;
&lt;TDL&gt;
&lt;TDLMESSAGE&gt;
&lt;COLLECTION ISMODIFY=&quot;No&quot; ISFIXED=&quot;No&quot; ISINITIALIZE=&quot;No&quot; ISOPTION=&quot;No&quot;
ISINTERNAL=&quot;No&quot; NAME=&quot;Vouchers&quot;&gt;
&lt;TYPE&gt; Vouchers : VoucherType&lt;/TYPE&gt;
&lt;CHILDOF&gt;$$VchTypeSales&lt;/CHILDOF&gt;
&lt;BELONGSTO&gt;Yes&lt;/BELONGSTO&gt;
&lt;NATIVEMETHOD&gt;DATE&lt;/NATIVEMETHOD&gt;
&lt;NATIVEMETHOD&gt;VOUCHERTYPENAME&lt;/NATIVEMETHOD&gt;
&lt;NATIVEMETHOD&gt;ENTEREDBY&lt;/NATIVEMETHOD&gt;
&lt;NATIVEMETHOD&gt;PARTYLEDGERNAME&lt;/NATIVEMETHOD&gt;
&lt;NATIVEMETHOD&gt;VOUCHERNUMBER&lt;/NATIVEMETHOD&gt;
&lt;NATIVEMETHOD&gt;ALLLEDGERENTRIES.LIST:LEDGERNAME&lt;/NATIVEMETHOD&gt;
&lt;NATIVEMETHOD&gt;ALLLEDGERENTRIES.LIST:INVENTORYALLOCATIONS.LIST:STOCKITEMNAME&lt;/NATIVEMETHOD&gt;
&lt;/COLLECTION&gt;
&lt;/TDLMESSAGE&gt;
&lt;/TDL&gt;
&lt;/DESC&gt;
&lt;/BODY&gt;
&lt;/ENVELOPE&gt;

I want to limit the fields in the response against above mentioned XML request, I am successfully able to do it for direct voucher fields but unable to get only "LedgerName" field under the ALLLEDGERENTRIES.LIST and "StockItemName" field under the INVENTORYALLOCATIONS.LIST.

When I send request to tally with the mentioned body it returns all the fields under ALLLEDGERENTRIES.LIST as well as INVENTORYALLOCATIONS.LIST.

答案1

得分: 0

这是一个XML报告生成的示例，其中包括了一些关于凭证和相关信息的字段。请注意，此XML通过TallyConnector生成，使用了对象导向的方式（凭证扩展了BaseTallyObject），这也在TDL中得到了支持。同时，从C#类生成TDL的功能并未向公众发布。

英文:

Its little complicated,

we need to create a new Report to achieve this.

I tried to restrict child fields but didn't find a way without creating custom report.

I will provide sample custom voucher report. with minimal fields, if you want more fields, you can customize it.

Input XML

&lt;ENVELOPE&gt;
&lt;HEADER&gt;
&lt;VERSION&gt;1&lt;/VERSION&gt;
&lt;TALLYREQUEST&gt;EXPORT&lt;/TALLYREQUEST&gt;
&lt;TYPE&gt;DATA&lt;/TYPE&gt;
&lt;ID&gt;TC_VOUCHER&lt;/ID&gt;
&lt;/HEADER&gt;
&lt;BODY&gt;
&lt;DESC&gt;
&lt;STATICVARIABLES&gt;
&lt;SVEXPORTFORMAT&gt;$$SysName:xml&lt;/SVEXPORTFORMAT&gt;
&lt;/STATICVARIABLES&gt;
&lt;TDL&gt;
&lt;TDLMESSAGE&gt;
&lt;REPORT ISMODIFY=&quot;NO&quot; ISFIXED=&quot;NO&quot; ISINITIALIZE=&quot;NO&quot; ISOPTION=&quot;NO&quot; ISINTERNAL=&quot;NO&quot; NAME=&quot;TC_VOUCHER&quot;&gt;
&lt;FORM&gt;TC_VOUCHER&lt;/FORM&gt;
&lt;/REPORT&gt;
&lt;FORM ISMODIFY=&quot;NO&quot; ISFIXED=&quot;NO&quot; ISINITIALIZE=&quot;NO&quot; ISOPTION=&quot;NO&quot; ISINTERNAL=&quot;NO&quot; NAME=&quot;TC_VOUCHER&quot;&gt;
&lt;PART&gt;TC_VOUCHER&lt;/PART&gt;
&lt;XMLTAG&gt;Voucher.LIST&lt;/XMLTAG&gt;
&lt;/FORM&gt;
&lt;PART ISMODIFY=&quot;NO&quot; ISFIXED=&quot;NO&quot; ISINITIALIZE=&quot;NO&quot; ISOPTION=&quot;NO&quot; ISINTERNAL=&quot;NO&quot; NAME=&quot;TC_BASETALLYOBJECT&quot;&gt;
&lt;LINE&gt;TC_BASETALLYOBJECT&lt;/LINE&gt;
&lt;REPEAT&gt;TC_BASETALLYOBJECT:TC_BASETALLYOBJECTCOLLECTION&lt;/REPEAT&gt;
&lt;SCROLLED&gt;Vertical&lt;/SCROLLED&gt;
&lt;/PART&gt;
&lt;PART ISMODIFY=&quot;NO&quot; ISFIXED=&quot;NO&quot; ISINITIALIZE=&quot;NO&quot; ISOPTION=&quot;NO&quot; ISINTERNAL=&quot;NO&quot; NAME=&quot;TC_TALLYOBJECT&quot;&gt;
&lt;LINE&gt;TC_TALLYOBJECT&lt;/LINE&gt;
&lt;REPEAT&gt;TC_TALLYOBJECT:TC_TALLYOBJECTCOLLECTION&lt;/REPEAT&gt;
&lt;SCROLLED&gt;Vertical&lt;/SCROLLED&gt;
&lt;/PART&gt;
&lt;PART ISMODIFY=&quot;NO&quot; ISFIXED=&quot;NO&quot; ISINITIALIZE=&quot;NO&quot; ISOPTION=&quot;NO&quot; ISINTERNAL=&quot;NO&quot; NAME=&quot;TC_VOUCHER&quot;&gt;
&lt;LINE&gt;TC_VOUCHER&lt;/LINE&gt;
&lt;REPEAT&gt;TC_VOUCHER:TC_VOUCHERCOLLECTION&lt;/REPEAT&gt;
&lt;SCROLLED&gt;Vertical&lt;/SCROLLED&gt;
&lt;/PART&gt;
&lt;PART ISMODIFY=&quot;NO&quot; ISFIXED=&quot;NO&quot; ISINITIALIZE=&quot;NO&quot; ISOPTION=&quot;NO&quot; ISINTERNAL=&quot;NO&quot; NAME=&quot;TC_VOUCHERLEDGER&quot;&gt;
&lt;LINE&gt;TC_VOUCHERLEDGER&lt;/LINE&gt;
&lt;REPEAT&gt;TC_VOUCHERLEDGER:ALLLEDGERENTRIES&lt;/REPEAT&gt;
&lt;SCROLLED&gt;Vertical&lt;/SCROLLED&gt;
&lt;/PART&gt;
&lt;LINE ISMODIFY=&quot;NO&quot; ISFIXED=&quot;NO&quot; ISINITIALIZE=&quot;NO&quot; ISOPTION=&quot;NO&quot; ISINTERNAL=&quot;NO&quot; NAME=&quot;TC_BASETALLYOBJECT&quot;&gt;
&lt;FIELDS&gt;TC_GUID&lt;/FIELDS&gt;
&lt;XMLTAG&gt;BASETALLYOBJECT&lt;/XMLTAG&gt;
&lt;/LINE&gt;
&lt;LINE ISMODIFY=&quot;NO&quot; ISFIXED=&quot;NO&quot; ISINITIALIZE=&quot;NO&quot; ISOPTION=&quot;NO&quot; ISINTERNAL=&quot;NO&quot; NAME=&quot;TC_TALLYOBJECT&quot;&gt;
&lt;FIELDS&gt;TC_ALTERID,TC_MASTERID&lt;/FIELDS&gt;
&lt;XMLTAG&gt;TALLYOBJECT&lt;/XMLTAG&gt;
&lt;USE&gt;TC_BASETALLYOBJECT&lt;/USE&gt;
&lt;/LINE&gt;
&lt;LINE ISMODIFY=&quot;NO&quot; ISFIXED=&quot;NO&quot; ISINITIALIZE=&quot;NO&quot; ISOPTION=&quot;NO&quot; ISINTERNAL=&quot;NO&quot; NAME=&quot;TC_VOUCHER&quot;&gt;
&lt;FIELDS&gt;TC_DATE,TC_VOUCHERTYPE,TC_VOUCHERNUMBER&lt;/FIELDS&gt;
&lt;XMLTAG&gt;VOUCHER&lt;/XMLTAG&gt;
&lt;EXPLODE&gt;TC_VOUCHERLEDGER:Yes&lt;/EXPLODE&gt;
&lt;USE&gt;TC_TALLYOBJECT&lt;/USE&gt;
&lt;/LINE&gt;
&lt;LINE ISMODIFY=&quot;NO&quot; ISFIXED=&quot;NO&quot; ISINITIALIZE=&quot;NO&quot; ISOPTION=&quot;NO&quot; ISINTERNAL=&quot;NO&quot; NAME=&quot;TC_VOUCHERLEDGER&quot;&gt;
&lt;FIELDS&gt;TC_LEDGERNAME,TC_AMOUNT&lt;/FIELDS&gt;
&lt;XMLTAG&gt;ALLLEDGERENTRIES.LIST&lt;/XMLTAG&gt;
&lt;/LINE&gt;
&lt;FIELD ISMODIFY=&quot;NO&quot; ISFIXED=&quot;NO&quot; ISINITIALIZE=&quot;NO&quot; ISOPTION=&quot;NO&quot; ISINTERNAL=&quot;NO&quot; NAME=&quot;TC_GUID&quot;&gt;
&lt;SET&gt;$GUID&lt;/SET&gt;
&lt;XMLTAG&gt;GUID&lt;/XMLTAG&gt;
&lt;/FIELD&gt;
&lt;FIELD ISMODIFY=&quot;NO&quot; ISFIXED=&quot;NO&quot; ISINITIALIZE=&quot;NO&quot; ISOPTION=&quot;NO&quot; ISINTERNAL=&quot;NO&quot; NAME=&quot;TC_ALTERID&quot;&gt;
&lt;SET&gt;$AlterId&lt;/SET&gt;
&lt;XMLTAG&gt;ALTERID&lt;/XMLTAG&gt;
&lt;/FIELD&gt;
&lt;FIELD ISMODIFY=&quot;NO&quot; ISFIXED=&quot;NO&quot; ISINITIALIZE=&quot;NO&quot; ISOPTION=&quot;NO&quot; ISINTERNAL=&quot;NO&quot; NAME=&quot;TC_MASTERID&quot;&gt;
&lt;SET&gt;$MasterId&lt;/SET&gt;
&lt;XMLTAG&gt;MASTERID&lt;/XMLTAG&gt;
&lt;/FIELD&gt;
&lt;FIELD ISMODIFY=&quot;NO&quot; ISFIXED=&quot;NO&quot; ISINITIALIZE=&quot;NO&quot; ISOPTION=&quot;NO&quot; ISINTERNAL=&quot;NO&quot; NAME=&quot;TC_DATE&quot;&gt;
&lt;SET&gt;$Date&lt;/SET&gt;
&lt;XMLTAG&gt;DATE&lt;/XMLTAG&gt;
&lt;/FIELD&gt;
&lt;FIELD ISMODIFY=&quot;NO&quot; ISFIXED=&quot;NO&quot; ISINITIALIZE=&quot;NO&quot; ISOPTION=&quot;NO&quot; ISINTERNAL=&quot;NO&quot; NAME=&quot;TC_VOUCHERTYPE&quot;&gt;
&lt;SET&gt;$VOUCHERTYPENAME&lt;/SET&gt;
&lt;XMLTAG&gt;VOUCHERTYPENAME&lt;/XMLTAG&gt;
&lt;/FIELD&gt;
&lt;FIELD ISMODIFY=&quot;NO&quot; ISFIXED=&quot;NO&quot; ISINITIALIZE=&quot;NO&quot; ISOPTION=&quot;NO&quot; ISINTERNAL=&quot;NO&quot; NAME=&quot;TC_VOUCHERNUMBER&quot;&gt;
&lt;SET&gt;$VoucherNumber&lt;/SET&gt;
&lt;XMLTAG&gt;VOUCHERNUMBER&lt;/XMLTAG&gt;
&lt;/FIELD&gt;
&lt;FIELD ISMODIFY=&quot;NO&quot; ISFIXED=&quot;NO&quot; ISINITIALIZE=&quot;NO&quot; ISOPTION=&quot;NO&quot; ISINTERNAL=&quot;NO&quot; NAME=&quot;TC_LEDGERNAME&quot;&gt;
&lt;SET&gt;$LEDGERNAME&lt;/SET&gt;
&lt;XMLTAG&gt;LEDGERNAME&lt;/XMLTAG&gt;
&lt;/FIELD&gt;
&lt;FIELD ISMODIFY=&quot;NO&quot; ISFIXED=&quot;NO&quot; ISINITIALIZE=&quot;NO&quot; ISOPTION=&quot;NO&quot; ISINTERNAL=&quot;NO&quot; NAME=&quot;TC_AMOUNT&quot;&gt;
&lt;SET&gt;$AMOUNT&lt;/SET&gt;
&lt;XMLTAG&gt;AMOUNT&lt;/XMLTAG&gt;
&lt;/FIELD&gt;
&lt;COLLECTION ISMODIFY=&quot;NO&quot; ISFIXED=&quot;NO&quot; ISINITIALIZE=&quot;NO&quot; ISOPTION=&quot;NO&quot; ISINTERNAL=&quot;NO&quot; NAME=&quot;TC_VOUCHERCOLLECTION&quot;&gt;
&lt;TYPE&gt;VOUCHERS&lt;/TYPE&gt;
&lt;NATIVEMETHOD&gt;ALTERID&lt;/NATIVEMETHOD&gt;
&lt;NATIVEMETHOD&gt;ALLLEDGERENTRIES.LEDGERNAME&lt;/NATIVEMETHOD&gt;
&lt;/COLLECTION&gt;
&lt;/TDLMESSAGE&gt;
&lt;/TDL&gt;
&lt;/DESC&gt;
&lt;/BODY&gt;

</ENVELOPE>

OuputXML

&lt;VOUCHER.LIST&gt;
&lt;VOUCHER&gt;
&lt;GUID&gt;52889497-5b6b-403d-8f83-224e3c7759b4-00001484&lt;/GUID&gt;
&lt;ALTERID&gt;8816&lt;/ALTERID&gt;
&lt;MASTERID&gt;5252&lt;/MASTERID&gt;
&lt;DATE&gt;1-Apr-23&lt;/DATE&gt;
&lt;VOUCHERTYPENAME&gt;Sales&lt;/VOUCHERTYPENAME&gt;
&lt;VOUCHERNUMBER&gt;1&lt;/VOUCHERNUMBER&gt;
&lt;ALLLEDGERENTRIES.LIST&gt;
&lt;LEDGERNAME&gt;ABCD India Pvt Ltd&lt;/LEDGERNAME&gt;
&lt;AMOUNT&gt;35,070.00&lt;/AMOUNT&gt;
&lt;/ALLLEDGERENTRIES.LIST&gt;
&lt;ALLLEDGERENTRIES.LIST&gt;
&lt;LEDGERNAME&gt;Sales&lt;/LEDGERNAME&gt;
&lt;AMOUNT&gt;35,070.00&lt;/AMOUNT&gt;
&lt;/ALLLEDGERENTRIES.LIST&gt;
&lt;/VOUCHER&gt;
&lt;/VOUCHER.LIST&gt;

Note: This XML is generated through TallyConnector and uses object orientation(Voucher Extends BaseTallyObject) which is also supported in TDL
and AutoTDL generation from C# class feature is not released to public.

通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。

如何限制Tally XML导出响应中的嵌套字段

问题

答案1

How to get list of ledgers from tally using XML request filtered by name that contains a specified sub-text?

Is there a way to extract all the stock items from Tally Group/Category including the items inside sub-group with Tally XML request?

What's the correct way to type hint an empty list as a literal in python?

如何在Highcharts Gantt中更改本地化的星期名称

如何在同一个流中使用多个过滤器和映射函数？

如何使用Map/Set来将代码优化到O(n)？

.NET MAUI Android在GitHub Actions上构建失败，错误代码为1。

如何在Playwright视觉比较中屏蔽多个定位器？

在C++中，可以使用可变模板参数来检索类型的内部类型。

selenium.common.exceptions.StaleElementReferenceException: Message: stale element reference: stale element not found

Creating and opening a URL to log in to Website via Basic Auth with Robot Framework/Selenium (Python)

AG Grid 在上下文菜单中以大文本形式打开

发表评论