Skip to main content

Pushback submission data to Salesforce using Integrations Hub

Use the Integrations Hub module to sync OpenWater submissions and applications to custom objects in Fonteva, Nimble, and Salesforce.

Cheryn avatar
Written by Cheryn
Updated this week

An Integrations Hub pushback only writes data to custom objects that have the prefix OW_. This safety ensures robust integrations can be built without worry of impacting other parts of your Salesforce Setup. Using Salesforce Flow you can take data pushed back to the OW_ object and place it anywhere your organization's requirements dictate.

You will be bouncing back and forth between Integrations Hub and your Salesforce environment, so we recommend opening them in separate tabs.

This article will cover:

  • Initial Setup

  • Testing

  • Adding Additional Fields

  • Starting Your Pushback

This article covers a lot of steps that have to be taken in a Salesforce environment.

Every Salesforce instance is different. Please contact your Salesforce administrator, share this article, and make them aware of your project needs before undertaking any work within Salesforce.


INITIAL SETUP

Starting off in Integrations Hub:

1. Head to the Integrations Hub and choose Connectors > Pushback > +Add > Salesforce (Applications).

A screenshot of a computer

AI-generated content may be incorrect.

2. Give your pushback a name. Then select the Program, Round, and status of the applications you want to push into Salesforce.

A screenshot of a computer

AI-generated content may be incorrect.

3. Hit Save.

4. Next, copy the Package URL provided at the top of your pushback connector using the “copy” icon.

A screenshot of a computer

AI-generated content may be incorrect.

In Salesforce:

5. In a separate tab, paste the package link into your browser. This should take you to a Salesforce login screen.

(Some organizations may need to add 'test.' in front of 'salesforce.com' in the URL in order to make sure you log into your staging site and not production.)

6. Login with a Salesforce administrative account that has API permissions.

Once logged in, you should see the following screen to prompting you to Install OpenWater Pushback.

A screenshot of a computer

AI-generated content may be incorrect.

7. Click Install.

NOTE: Salesforce may ask you to login again, and it may also prompt you to upgrade the OpenWater pushback. Log in again and click Upgrade if required.

A screenshot of a computer

AI-generated content may be incorrect.

A screenshot of a computer

AI-generated content may be incorrect.

8. You should see an installation/upgrade complete screen. Click Done.

You should then be able to view your installed package in Salesforce.

A screenshot of a computer

AI-generated content may be incorrect.

Back to Integrations Hub:

9. In the credentials field, click to Add New Credentials (or select existing credentials if you have already authenticated with this same user).

You can set up new credentials via an admin token link or via an SF administrator username and password, for which you will also need to add a Security Token, Client ID, and Client Secret from within your Salesforce environment’s OpenWater application.

A screenshot of a login form

AI-generated content may be incorrect.

10. If you are creating new credentials using an admin token link, copy the admin token link via the blue “copy” icon, then hit Add.

A screenshot of a computer

AI-generated content may be incorrect.

11. Once your credentials are created, hit ‘Save’ in the top left of your pushback connector.

Back to Salesforce:

If you chose to set up credentials via admin token link:

12. In a new tab, paste the credentials that you copied via the credentials copy icon into a new tab.

13. It should take you to another Salesforce login page. Login again using your same administrator account.

A screenshot of a computer

AI-generated content may be incorrect.

14. Click ‘Allow’. It should then take you to a blank screen with the word ‘Done’.

A white background with black dots

AI-generated content may be incorrect.

In Integrations Hub:

15. Navigate back over to your pushback connector page in IH and Refresh the whole page (the whole tab/page, not the refresh button).

16. Click ‘Show Credentials Details’ to confirm your verification went through.

A screenshot of a computer

AI-generated content may be incorrect.

A close-up of a computer screen

AI-generated content may be incorrect.

17. The green checkmark with “Verified” means you successfully authenticated the admin token. This will appear as a red “Not Verified” before authentication.

18. Hit Save at the top right of your connector page.

19. Click to go into the Field Mapping tab.

20. Click the ‘Initialize Mapping Fields’ button and then click ‘Create’ in the pop up window.

A screenshot of a computer

AI-generated content may be incorrect.

A screenshot of a computer

AI-generated content may be incorrect.

Basic fields connected back to the Salesforce object installed by your package should then pre-populate in the Field Mapping tab.

(This set of fields alone should be enough to test your connection by pushing an application into Salesforce, but you may also want to include additional fields in your pushback, which we will cover below.)

A screenshot of a computer

AI-generated content may be incorrect.

21. Hit Save.


TESTING

Now let’s test your connection before we add any additional fields.

22. To test, find the application number of a completed application you want to push from your OpenWater program and hit ‘Test’.

A screenshot of a computer

AI-generated content may be incorrect.

23. Hit ‘OK’ to test.

A screenshot of a computer

AI-generated content may be incorrect.

24. Enter the application number for the application you want to push and hit the blue ‘OK’ button.

A screenshot of a computer

AI-generated content may be incorrect.

There will be a quick pop-up green checkmark notification if your test application pushed successfully. (If there is an error, it will show an error message on the right side of the screen with more information to use for troubleshooting.)

A screenshot of a computer

AI-generated content may be incorrect.

Now let’s confirm in Salesforce by using a report.

Back in Salesforce:

Note: If you are already familiar with Salesforce Objects and workflows, you can either:

  • Skip straight to the step 28 to set up a report to confirm your test pushed successfully

    OR

  • Skip to step 39 to start customizing your pushback with additional fields.

25. Go to ‘Quick Find’. Search for and click on ‘Object Manager’.

While we won't be doing anything in the Object itself at this time, it is good to take a look at this if you are less familiar with Salesforce.

A screenshot of a computer

AI-generated content may be incorrect.

26. Scroll through the list of Salesforce Objects to find the object that was installed with the package in our earlier steps. Your Object should begin with “OW” or “OW_Application”.

A screenshot of a computer

AI-generated content may be incorrect.

27. Click the name of the Object to open and explore.

There are a variety of options on the left-hand menu within Salesforce to set up workflows. Every Salesforce environment is set up differently, and a pushback to a Salesforce Object can be used in any number of workflows.

However, there is no way to see the data you’ve pushed into the Salesforce Object from the Object itself. To do this, you would need to set up a report or other workflow.

A screenshot of a computer

AI-generated content may be incorrect.

Steps 28-38 are included here to show how to set up a brief report through which you can view the information pushing from OpenWater into your Salesforce Object.

It is likely that you will want to set up your own workflows according to your program needs.

Now that we're feeling comfortable with finding and understanding how our Salesforce Object is set up, we will set up a Report to view what records are being pushed into the Object.

28. In Setup, go to ‘Quick Find’. Search for and select ‘Report Types’.

A screenshot of a computer

AI-generated content may be incorrect.

29. Hit ‘Continue’.

A screenshot of a computer

AI-generated content may be incorrect.

30. Click ‘New Custom Report Type’.

A screenshot of a computer

AI-generated content may be incorrect.

31. Select the OW_Application Object that you created as the ‘Primary Object’ for your report.

A screenshot of a computer

AI-generated content may be incorrect.

32. Fill out the required details.

A screenshot of a computer

AI-generated content may be incorrect.

33. Hit ‘Next’ to define your report records set. In this example, we only want to view the records and we are not relating our Object to any other Salesforce Objects.

34. Hit ‘Save’.

A screenshot of a computer

AI-generated content may be incorrect.

35. You’ve now created a new Salesforce report type and can hit ‘Close’.

A screenshot of a computer

AI-generated content may be incorrect.

36. To now 'run' this type of report, find the Report Type you just created and hit the carrot at the end of the row. Select ‘Start Report’.

A screenshot of a computer

AI-generated content may be incorrect.

From there, the report will open to show the records available to run in the report. If your test worked successfully, you should see the number of the test application you pushed listed.

37. Hit the blue ‘Run’ button in the top right corner to run the report.

A screenshot of a computer

AI-generated content may be incorrect.

38. Once you’ve run the report, you can click the number of the test application to open and view the information that was pushed from OpenWater.

A screenshot of a computer

AI-generated content may be incorrect.

Take a look at the information pushed for this OpenWater application into its new Salesforce record and confirm everything is populating as expected.

A screenshot of a computer

AI-generated content may be incorrect.

Hurrah! Our test was successful and our pushback connection works.


ADDING ADDITIONAL FIELDS

This next set of steps covers adding specific fields from your OpenWater program into your pushback.

39. Navigate back to ‘Object Manager’ and select your Object like we did in steps 25-27.

40. In the left-hand details menu, select ‘Fields & Relationships’, then click the button ‘New’.

A screenshot of a computer

AI-generated content may be incorrect.

41. Select the type of field correct for the data you want to push.

A screenshot of a computer

AI-generated content may be incorrect.

We recommend text fields. You may want to experiment with testing how data comes over from OpenWater into your fields if you want to use different field types.

A close-up of a white background

AI-generated content may be incorrect.

42. Once selected, hit ‘Next’.

43. Enter the details needed for your new field and hit ‘Next’.

A screenshot of a computer

AI-generated content may be incorrect.

44. Set Field-level security according to your workflow needs and hit ‘Next’.

A screenshot of a computer

AI-generated content may be incorrect.

45. Add to page layouts and hit ‘Save’, or hit ‘Save & New’ if you want to repeat these steps to add more new fields.

A screenshot of a computer

AI-generated content may be incorrect.

Back in Integrations Hub:

46. After you’ve finished adding the fields you want to bring over from OpenWater into your Salesforce Object, return to your pushback in Integrations Hub and refresh the tab/page.

47. Then hit ‘Refresh’ on your connector, and then hit ‘Save’.

A screenshot of a computer

AI-generated content may be incorrect.

48. Open the ‘Field Mapping’ tab.

49. Then click ‘Add Field’ to add more fields to the pushback.

The field mapping will automatically map to your OW Salesforce Object under ‘Salesforce Object’. The ‘Salesforce Field’ you select should be the field name(s) for the field(s) you just created in Salesforce.

A screenshot of a computer

AI-generated content may be incorrect.

50. Begin field mapping with your new fields.

A screenshot of a computer

AI-generated content may be incorrect.

51. Hit Save.

52. Test your pushback again in Integrations Hub by selecting ‘Test’, entering the same number of the test application you pushed previously, and hitting 'Test'.

Confirming Your Test Updates in Salesforce:

If your test application in Integrations Hub pushes successfully, you may want to double check how it looks in Salesforce.

53. Just like in step 28, find and reopen your report type in Salesforce.

54. Hit ‘Edit’ to open the report type.

A screenshot of a computer

AI-generated content may be incorrect.

55. Hit ‘Save’ to update the report type.

A screenshot of a computer

AI-generated content may be incorrect.

56. Then hit ‘Start Report’ to open the report again.

57. Hit the blue ‘Run’ button to run the report and populate the new fields with the new data being pushed.

A screenshot of a computer

AI-generated content may be incorrect.

58. Click on the number of the test application you pushed to see all the new info.

A screenshot of a computer

AI-generated content may be incorrect.

If necessary, update your field types in Salesforce and/or field mapping in Integrations Hub and retest as needed.


STARTING YOUR PUSHBACK

Once you are you are satisfied with the way your data is pushing into your Salesforce Object, you can now set the pushback to run fully.

In Integrations Hub:

59. Hit “Run Once” to have all applications that fit the criteria for your pushback push into your Salesforce Object.

A screenshot of a computer

AI-generated content may be incorrect.

60. You can view all of the records that you pushed via the ‘Logs’ tab for your pushback connector. You will see a status of “Success” for those that push successfully. (“Failed” will show if there is an issue with the application that is trying to push.)

A screenshot of a computer

AI-generated content may be incorrect.

You can also check by re-running your report or other workflow in Salesforce:

A screenshot of a computer

AI-generated content may be incorrect.

If you want to set your pushback to run automatically on a recurring basis, you can do this in the Job Configuration settings.

61. Once you’ve set your ‘Job Configuration’ hit ‘Save’.

A screenshot of a computer

AI-generated content may be incorrect.

62. Then, hit ‘Start’ to begin the pushback running automatically.

A screenshot of a computer

AI-generated content may be incorrect.

63. Once you have hit “Start”, the Status in the top right corner of your pushback will turn from “Inactive” to “Active”.

A screenshot of a computer

AI-generated content may be incorrect.

You did it!

Did this answer your question?