Skip to main content

Hello,

 

I am doing a few quick reports and what would help me is a full list of the available out the box functions within IFS.  At present i am using joins, but have noted that there are far easier ways of achieving the same results via functions. I have seen and made use of the following in some of my Quick reports.

 

ifsapp.Comm_Method_API.Get_Default_Value('PERSON',t.person_id,'PHONE') Personal_Contact_Phone,
ifsapp.Comm_Method_API.Get_Default_Value('PERSON',t.person_id,'MOBILE') Mobile_Number,
ifsapp.Comm_Method_API.Get_Default_Value('PERSON',t.person_id,'E_MAIL') Personal_Email,

 

Is there somewhere that I can find a comprehensive list of the available functions?

Thanks,

Noel

 

​@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

Hi ​@nrodney8,

All available Getter function details for an API are available in the Entity screen. 

Please refer to the screenshot below.

 

Regards

Abdul Rehman

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.
  1. 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. 😀

Reply


Terms & ConditionsCookie settings