Quickbooks api v3 过滤器报价 [英] Quickbooks api v3 filters quotation

问题描述

我在在线快速手册中有一个名称为9"Plate - Champagne' 的项目.但是如果我使用我使用的方法，它不会返回任何内容，并且只有带引号的项目名称才会发生这种情况.

I have an item with name='9" Plate - Champagne' in quickbooks online. but if I use method that I use its doesn't return anything and that's happens only with item name with quotation mark.

Dim ItemQueryService As New Intuit.Ipp.QueryFilter.QueryService(Of Intuit.Ipp.Data.Item)(context)
Dim q As String = "Select * from Item where Name = '9" Plate - Champagne'"
Dim Itemlist = ItemQueryService.ExecuteIdsQuery(q)

如何处理本声明中的特殊引用?

How to handle special quotation in this statement?

推荐答案

双引号的转义是另一个双引号，所以尝试:

The escape for the double quote is another double quote, so try:

Dim q As String = "Select * from Item where Name = '9"" Plate - Champagne'"

嗯..

你有没有尝试过:

Dim q As String = "Select * from Item where Name = '9\" Plate - Champagne'"

或

Dim q As String = "Select * from Item where Name = '9\"" Plate - Champagne'"

或

Dim q As String = "Select * from Item where Name = '9"""" Plate - Champagne'"

或

Dim q As String = "Select * from Item where Name = '9" Plate - Champagne'"

或

Dim q As String = "Select * from Item where Name = '9%22 Plate - Champagne'"

实际上..您是否尝试过对整个字符串进行 url 编码?

Actually.. have you tried url-encoding the whole string?

Dim q As String = "Select%20*%20from%20Item%20where%20Name%20%3D%20%279%22%20Plate%20-%20Champagne%27"

这篇关于Quickbooks api v3 过滤器报价的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！