添加到odata查询时,成功因素EC EmpWorkPermit引发OsciException:错误的请求:400

2020-09-22 10:12发布

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)


专家,

我有一个odata调用,它具有很多select,expand和filter语句。 我正在从EmpJob实体导航到很多实体,其中之一是EmpWorkPermit。 当我尝试从该实体中选择几个字段(例如documentNumber或issuingAuthority)时,它工作得很好。 但是,当我导航到documentTypeNav或issuingAuthorityNav时,odata调用失败。

注意点:

1。 仅当我在&$ Select语句中选择导航时,才会发生这种情况。

2。 当我没有从EmpWorkPermit中选择任何导航并且仅展开它们(无论如何都不要使用!)时,它不会出错。

3。 导航到子实体或父实体的其他任何选择都不会发生这种情况

4。 如果我在Postman中执行完全相同的代码,它将起作用。

数据调用:

https:///odata/v2/EmpJob?

$ select = startDate,lastModifiedDateTime,contractEndDate,payGrade,公司,standardHours,位置,workscheduleCode,contractType,customString18,contractTypeNav/externalCode,jobCodeNav/localNavITA/inailCode,employmentNav/lastModifiedDateTime,employmentNav/customDate2,employmentNav/personNav/lastModifiedDateTime,employmentNav/personNav/customString2,employmentNav/personNav/dateOfbirth,employmentNav/personNav/countryOfBirth,employmentNav/personNav/customString2,employmentNav/personNav/nationalIdNav/nationalId,employmentNav/personNav/personalInfoNav/lastInfoifiedDateTime 国籍,employmentNav/personNav/personalInfoNav/lastName,employmentNav/personNav/personalInfoNav/firstname,employmentNav/personNav/personalInfoNav/gender,employmentNav/personNav/personalInfoNav/localNavITA/genericString1,employmentNav/personNav/personalInfoNav/localNavITA/customStringLabel/labelList EmploymentNav/personNav/personalInfoNav/localNavI TA/customString6Nav/picklist标签/语言环境,employmentNav/personNav/phoneNav/lastModifiedDateTime,employmentNav/personNav/phoneNav/phoneNumber,employmentNav/personNav/phoneNav/phoneTypeNav/externalCode,employmentNav/personNav/phoneNav/phoneTypeNav/picklistLabel/label,employmentNav/person emailNav/lastModifiedDateTime,employmentNav/personNav/emailNav/emailAddress,employmentNav/personNav/emailNav/emailTypeNav/externalCode,employmentNav/personNav/homeAddressNavDEFLT/zipCode,employmentNav/personNav/homeAddressNavDEFLT/city,employmentNav/personNav/personNav/AddressAddressNavDEFLT homeAddressNavDEFLT/address2,employmentNav/personNav/homeAddressNavDEFLT/country,employmentNav/personNav/homeAddressNavDEFLT/addressType,employmentNav/compInfoNav/empPayCompRecurringNav/paycompvalue,employmentNav/paymentInformationNav/toPaymentInformationDetailV3/paybanInformmentment/employment

&$ expand = contractTypeNav,workscheduleCodeNav,jobCodeNav,jobCodeNav/localNavITA,employmentNav,employmentNav/personNav,employmentNav/personNav/phoneNav,employmentNav/personNav/phoneNav/phoneTypeNav,employmentNav/personNav/emailNav,employmentNav/personNav/emailNav/emailType ,employmentNav/personNav/homeAddressNavDEFLT,employmentNav/personNav/nationalIdNav,employmentNav/personNav/personalInfoNav,employmentNav/personNav/personalInfoNav/localNavITA,employmentNav/empWorkPermitNav,employmentNav/empWorkPermitNav/customString1Nav,employmentNav/empWorkmentloy/EmploymentNav/empWorkPerloyNav//compInfoNav,employmentNav/compInfoNav/empPayCompRecurringNav,employmentNav/paymentInformationNav,employmentNav/paymentInformationNav/toPaymentInformationDetailV3,employmentNav/personNav/personalInfoNav/localNavITA/customString6Nav/picklistLabels&$ filter =(event eq'和event eq'和公司 lastModifiedDateTime gt datetimeoffset'2018-03-21 T13:37:49Z'

select语句最后一行中的' employmentNav/empWorkPermitNav'是问题所在。 我也尝试了以下所有/之一-

employmentNav/empWorkPermitNav/documentTypeNav

employmentNav/empWorkPermitNav/issuingAuthorityNav

但是,如果我删除与EmpWorkPermitNav相关的任何内容,它将起作用。

数据字典屏幕截图

EmpEmployment导航到EmpWorkPermit实体

从上述情况来看,我认为问题不在于拼写错误或导航不正确。

可能是什么?

提前谢谢

Kriba

(44.0 kB)

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)


专家,

我有一个odata调用,它具有很多select,expand和filter语句。 我正在从EmpJob实体导航到很多实体,其中之一是EmpWorkPermit。 当我尝试从该实体中选择几个字段(例如documentNumber或issuingAuthority)时,它工作得很好。 但是,当我导航到documentTypeNav或issuingAuthorityNav时,odata调用失败。

注意点:

1。 仅当我在&$ Select语句中选择导航时,才会发生这种情况。

2。 当我没有从EmpWorkPermit中选择任何导航并且仅展开它们(无论如何都不要使用!)时,它不会出错。

3。 导航到子实体或父实体的其他任何选择都不会发生这种情况

4。 如果我在Postman中执行完全相同的代码,它将起作用。

数据调用:

https:///odata/v2/EmpJob?

$ select = startDate,lastModifiedDateTime,contractEndDate,payGrade,公司,standardHours,位置,workscheduleCode,contractType,customString18,contractTypeNav/externalCode,jobCodeNav/localNavITA/inailCode,employmentNav/lastModifiedDateTime,employmentNav/customDate2,employmentNav/personNav/lastModifiedDateTime,employmentNav/personNav/customString2,employmentNav/personNav/dateOfbirth,employmentNav/personNav/countryOfBirth,employmentNav/personNav/customString2,employmentNav/personNav/nationalIdNav/nationalId,employmentNav/personNav/personalInfoNav/lastInfoifiedDateTime 国籍,employmentNav/personNav/personalInfoNav/lastName,employmentNav/personNav/personalInfoNav/firstname,employmentNav/personNav/personalInfoNav/gender,employmentNav/personNav/personalInfoNav/localNavITA/genericString1,employmentNav/personNav/personalInfoNav/localNavITA/customStringLabel/labelList EmploymentNav/personNav/personalInfoNav/localNavI TA/customString6Nav/picklist标签/语言环境,employmentNav/personNav/phoneNav/lastModifiedDateTime,employmentNav/personNav/phoneNav/phoneNumber,employmentNav/personNav/phoneNav/phoneTypeNav/externalCode,employmentNav/personNav/phoneNav/phoneTypeNav/picklistLabel/label,employmentNav/person emailNav/lastModifiedDateTime,employmentNav/personNav/emailNav/emailAddress,employmentNav/personNav/emailNav/emailTypeNav/externalCode,employmentNav/personNav/homeAddressNavDEFLT/zipCode,employmentNav/personNav/homeAddressNavDEFLT/city,employmentNav/personNav/personNav/AddressAddressNavDEFLT homeAddressNavDEFLT/address2,employmentNav/personNav/homeAddressNavDEFLT/country,employmentNav/personNav/homeAddressNavDEFLT/addressType,employmentNav/compInfoNav/empPayCompRecurringNav/paycompvalue,employmentNav/paymentInformationNav/toPaymentInformationDetailV3/paybanInformmentment/employment

&$ expand = contractTypeNav,workscheduleCodeNav,jobCodeNav,jobCodeNav/localNavITA,employmentNav,employmentNav/personNav,employmentNav/personNav/phoneNav,employmentNav/personNav/phoneNav/phoneTypeNav,employmentNav/personNav/emailNav,employmentNav/personNav/emailNav/emailType ,employmentNav/personNav/homeAddressNavDEFLT,employmentNav/personNav/nationalIdNav,employmentNav/personNav/personalInfoNav,employmentNav/personNav/personalInfoNav/localNavITA,employmentNav/empWorkPermitNav,employmentNav/empWorkPermitNav/customString1Nav,employmentNav/empWorkmentloy/EmploymentNav/empWorkPerloyNav//compInfoNav,employmentNav/compInfoNav/empPayCompRecurringNav,employmentNav/paymentInformationNav,employmentNav/paymentInformationNav/toPaymentInformationDetailV3,employmentNav/personNav/personalInfoNav/localNavITA/customString6Nav/picklistLabels&$ filter =(event eq'和event eq'和公司 lastModifiedDateTime gt datetimeoffset'2018-03-21 T13:37:49Z'

select语句最后一行中的' employmentNav/empWorkPermitNav'是问题所在。 我也尝试了以下所有/之一-

employmentNav/empWorkPermitNav/documentTypeNav

employmentNav/empWorkPermitNav/issuingAuthorityNav

但是,如果我删除与EmpWorkPermitNav相关的任何内容,它将起作用。

数据字典屏幕截图

EmpEmployment导航到EmpWorkPermit实体

从上述情况来看,我认为问题不在于拼写错误或导航不正确。

可能是什么?

提前谢谢

Kriba

(44.0 kB)
付费偷看设置
发送
1条回答
渐行渐远_HoldOn
1楼-- · 2020-09-22 10:59

更新:

我们为此问题举了一张SAP票。 事实证明,如果通过扩展选择属性,则存在一个odata v2适配器错误,该错误会影响odata调用。

例如:&$ select = employmentNav/empWorkPermitNav/documentTypeNav


一周热门 更多>