我正在尝试在批量请求中一起发送几个 Quickbooks 查询。我遵循了 Intuit 在这里提供的格式https://developer.intuit.com/docs/0025_quickbooksapi/0050_data_services/020_key_concepts/00700_batch_operation https://developer.intuit.com/docs/0025_quickbooksapi/0050_data_services/020_key_concepts/00700_batch_operation但我不断收到 ValidationFault。我不确定导致错误的原因,因此我们将不胜感激。谢谢!
XML:
<IntuitBatchRequest xmlns="http://schema.intuit.com/finance/v3">
<BatchItemRequest bId="1" >
<Query query="Select * from Payment WHERE CustomerRef = '1933' ORDERBY TxnDate DESC MAXRESULTS 1"/>
</BatchItemRequest>
<BatchItemRequest bId="2" >
<Query query="Select * from Payment WHERE CustomerRef = '290' ORDERBY TxnDate DESC MAXRESULTS 1"/>
</BatchItemRequest>
</IntuitBatchRequest>
我得到的回应:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<IntuitResponse xmlns="http://schema.intuit.com/finance/v3" time="2014-02-07T12:47:32.442-08:00">
<BatchItemResponse bId="1">
<Fault type="ValidationFault">
<Error code="4000">
<Message>Error parsing query</Message>
<Detail>QueryParserError: Encountered "<EOF>" at line 0, column 0. Was expecting: "select" ...
</Detail>
</Error>
</Fault>
</BatchItemResponse>
<BatchItemResponse bId="2">
<Fault type="ValidationFault">
<Error code="4000">
<Message>Error parsing query</Message>
<Detail>QueryParserError: Encountered "<EOF>" at line 0, column 0. Was expecting: "select" ...
</Detail>
</Error>
</Fault>
</BatchItemResponse>
</IntuitResponse>
事实证明,Intuit 的文档是不正确的(至少对于其 QBOv3 REST API 而言)。
At https://developer.intuit.com/docs/0025_quickbooksapi/0050_data_services/020_key_concepts/00700_batch_operation https://developer.intuit.com/docs/0025_quickbooksapi/0050_data_services/020_key_concepts/00700_batch_operationIntuit 说 XML 应该按照我在第一篇文章中展示的方式进行格式化,但实际上应该像这样格式化:
<IntuitBatchRequest xmlns="http://schema.intuit.com/finance/v3">
<BatchItemRequest bId="1">
<Query>
Select * from Payment WHERE CustomerRef = '1933' ORDERBY TxnDate DESC MAXRESULTS 1
</Query>
</BatchItemRequest>
<BatchItemRequest bId="2">
<Query>
Select * from Payment WHERE CustomerRef = '290' ORDERBY TxnDate DESC MAXRESULTS 1
</Query>
</BatchItemRequest>
</IntuitBatchRequest>
我希望这对未来的其他人有帮助!感谢所有回复,他们帮助缩小了问题范围。
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)