时间戳

首页 > 解决方案 > 尝试通过 REST 获取默认客户/运输联系人数据时出现 BQL 委托错误

rest - 尝试通过 REST 获取默认客户/运输联系人数据时出现 BQL 委托错误

问题描述

我正在尝试使用 REST 从 Acumatica 的默认端点提取信息，当我尝试获取 Customer/ShippingContact 数据时，出现以下错误：

Optimization cannot be performed.The following fields cause the error:
ShippingContact.ContactID: View DefLocationContact has BQL delegate
ShippingContact.DisplayName: View DefLocationContact has BQL delegate
ShippingContact.Email: View DefLocationContact has BQL delegate
ShippingContact.Fax: View DefLocationContact has BQL delegate
ShippingContact.FirstName: View DefLocationContact has BQL delegate
ShippingContact.JobTitle: View DefLocationContact has BQL delegate
ShippingContact.LastName: View DefLocationContact has BQL delegate
ShippingContact.MiddleName: View DefLocationContact has BQL delegate
ShippingContact.Phone1: View DefLocationContact has BQL delegate
ShippingContact.Phone1Type: View DefLocationContact has BQL delegate
ShippingContact.Phone2: View DefLocationContact has BQL delegate
ShippingContact.Phone2Type: View DefLocationContact has BQL delegate
ShippingContact.Title: View DefLocationContact has BQL delegate
ShippingContact.WebSite: View DefLocationContact has BQL delegate

使用以下 URL 发出 GET 请求：

http://192.168.1.78/a000/entity/Default/17.200.001/Customer?$expand=ShippingContact

是否有任何特定的技巧可以通过 REST 让这样的东西工作？

标签： restacumatica

解决方案

这已在 Acumatica ERP 版本 2018r1 更新 11 中修复。作为临时解决方法，您可以构建通用查询来读取此数据。您可以使用的另一种方法是通过指定您想要此数据的客户来检索客户数据。像那样：

http://host/site/entity/Default/17.200.001/Customer/ABARTENDE?$expand=ShippingContact

推荐阅读