You need to sign in to do that
Don't have an account?
MBarnard
Can I access a 3rd party SSRS API through an APEX Class
Well,
What I really want to do is this:
Create a SF Button.
That button fires an APEX Class/Trigger that pulls the most recent data from an external DB, through SSRS API.
That data then returns into the account AND then I also create a VF page that displays as a PDF for email purposes.
I have access to the SSRS API.
I just need to know if I can create the necessary class to call the SSRS API to return me the values I need.
The third part is only possible if I get what I want above done, so let's start there.
I can't find documentation outside of the SF Canvas for what I am looking to do... Any fingers pointing in the correct direction would be amazing.
What I really want to do is this:
Create a SF Button.
That button fires an APEX Class/Trigger that pulls the most recent data from an external DB, through SSRS API.
That data then returns into the account AND then I also create a VF page that displays as a PDF for email purposes.
I have access to the SSRS API.
I just need to know if I can create the necessary class to call the SSRS API to return me the values I need.
The third part is only possible if I get what I want above done, so let's start there.
I can't find documentation outside of the SF Canvas for what I am looking to do... Any fingers pointing in the correct direction would be amazing.
1.) SOAP API :- You need to make Apex callout from button/Trigger which would call the external DB and return you response.Go through the below link to learn more with sample examples :-
https://developer.salesforce.com/page/Apex_Web_Services_and_Callouts
https://developer.salesforce.com/page/Apex_Callouts
2.) REST API :- You can use REST API to call your external DB which would return you the response.You can construct your request using HTTP Request class.Go through the below link to learn more :-
https://www.salesforce.com/us/developer/docs/api_rest/
https://developer.salesforce.com/page/REST_API
Hope this helps !!
If this helps,please mark it as best answer to help others :)
Thanks