Hi experts,
I am doing a Lookup query using SF SF adapter oData, to select some fields of differents tables on SF.
The problem is, I want to select ONE field for example, and the result is ALL fields.
Because of that I am having a serious problem on PO:
com.sap.aii.adapter.lib.component.odata.exception.OsciException: The response size (30242644) is greater than the maximum message size (26214400).
Basically I am doing this select:
..link.../odata/v2/EmpJob?$select=seqNumber,startDate,userId,employmentNav/personIdExternal,position,positionNav/employeeClass,positionNav/employeeClassNav/label_defaultValue,positionNav/parentPosition/code,employeeClass,employeeClassNav/picklistLabels/locale,employeeClassNav/picklistLabels/label,managerId,event,eventReason,businessUnit,businessUnitNav/cust_ItOrgCode,businessUnitNav/name_defaultValue,company,companyNav/name_defaultValue,department,departmentNav/cust_ItDeptCode,departmentNav/name_defaultValue,division,divisionNav/cust_ItBuCode,divisionNav/name_defaultValue,positionNav/effectiveStatusNav/value,positionNav/effectiveStatusNav/key,positionNav/effectiveStatusNav/en_US&$expand=emplStatusNav,companyNav,businessUnitNav,departmentNav,divisionNav,employmentNav,positionNav/employeeClassNav,positionNav/parentPosition,positionNav/effectiveStatusNav,employeeClassNav/picklistLabels&$orderby=employmentNav/personIdExternal&$filter=userId in '901234','901235'
When I do the same select directly, (using Java for example), I get only the fields I wanted. But doing that using lookup in my Java Mapping, ALL fields came in the result...
There is something missing in my query?
ps.: the scenario works for a little amount of ids, but since I am processing all base, I got this error.