Skip to Content
0
Former Member
Jun 13, 2016 at 06:12 AM

Error : SF to PI Integration for Employee central Adhoc API

24 Views

Hi All,

When I am trying to fetch the Compound employee details though an Adhoc_### API through SFSF(PI) channel, Getting error as No data returned.

Execting below query,

SELECT ectint_emp_job_info_t_business_unit_CODE,ectint_emp_job_info_t_division_OBJECT_NAME,ectint_emp_job_info_t_location_OBJECT_NAME,emp_employment_info_END_DATE,emp_employment_info_ORIGINAL_START_DATE,emp_employment_info_START_DATE,emp_job_info_t_DEPARTMENT,emp_job_info_t_EMPLOYMENT_STATUS,emp_job_info_t_JOB_TITLE,emp_job_info_t_MANAGER_ID,emp_pay_comp_recurring_target_LAST_MODIFIED_DATE,emp_personal_info_t_CUSTOM_VCHAR1,emp_personal_info_t_FIRST_NAME,emp_personal_info_t_LAST_MODIFIED_DATE,emp_personal_info_t_LAST_NAME,per_person_LAST_MODIFIED_DATE,users_sysinfo_USERS_ID,users_sysinfo_USERS_SYS_USERNAME FROM adhocreport_#### CONSTRAIN BY asOfDate='2016-06-13'

Where as if I execute the same query from SF tool it is a ble to fetch the data.

When I execute from channel facing below error. Find below screenshot for your reference.

Could you please check help me if you come across this error.

Attachments