Quick Report funtions

​@nrodney8 : I don’t think there is any comprehensive list available. Every API is having Get Functions which can be used to fetch the values based on required parameters. You can always check xxxx_API.Get….. to know the available functions and their parameters.

Thanks

Thanks ​@Abdul, this as really helped.

I have managed to get this to work for getting someones email address via using the parameter value “Person_id”:  FND_USER_API.Get_Web_User(A.person_id) Email

However, I am proving it difficult or a hit and miss for some others

For example: company_pers_api.Get_Name(????????) Name

How do you know what parameter value is expected for the “GET” statements:

Hi ​@nrodney8,

There are several ways to obtain the required parameters for an API method, and the easiest approach is to create a test migration job.

Please follow the screenshots below.

1. Create a Migration job and add your API Getter function in Method list.

2. The system automatically creates the required parameter list in the Source Mapping tab.

Parameters required for Company_Pers_Api.Get_Name is Company_Id and Emp_No.

For future cases, delete all records for Method List and Source Mapping tab before adding new getter function.

Hope this helps.

Regards

Abdul Rehman

Thank you ​@Abdul. 

I am now able to get what I want from your assistance. 😀