Content Comparison

...

...

Collect App Client ID and App Client Secret for connection on Feedier

...

...

...

Steps to establish the integration

Add a Segment

First we need to setup a segment on Feedier. Segments are saved searches that allow you to create automisations based on your selected feedback.

• Create a segment that will identify all feedback that needs to be enriched by Salesforce data. If you need all of feedback, just set a filter with time period is greater than beginning of the year.
  

  

Connect the Segment to an Automation

• Select the segment you just created.
  

  

• Select Salesforce Fields Sync from the dropdown.
  

  Image Added

To effectively query data in Salesforce using SOQL (Salesforce Object Query Language), you can follow the steps below. SOQL allows you to retrieve data from Salesforce objects like Contact and Account. In this section, we will walk you through how to access the Salesforce Developer Console and create your own SOQL queries. You can also refer to Salesforce documentation for the structure: https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql.htm

Important notes

1. Feedier will attach as attributes all the selected fields to the Feedback. 

2. Feedier will only read the first record from the query. So you can order if several records might be matched.

3. The query must contain "{attribute_value}" as this attribute value will always change and be replaced automatically. It can be an ID or a value for a LIKE query/matching.

Here are 2 examples:

Query 1: SELECT Contact_P__r.Id, Ticket_Type_Number__c, St__c, Produit__c, SourceSystem__c, Type__c, EffectiveDate__c, Category__c FROM TransactionDetail__c WHERE Contact_P__r.Id = '{attribute_value}'  ORDER BY EffectiveDate__c DESC
Explanation: Find a Contact record in Salesforce by its ID, join several custom objects, and order by date descending. All the selected fields will be attached to Salesforce.

Query 2: SELECT Name FROM Account WHERE http://Account.Id = '{attribute_value}'
Explanation: Find an Account record in Salesforce by its ID and attach the Name field value to Feedier as attributes.

...

Attribute Name

...

This is the Feedier attribute name (not label) that contains the Salesforce object ID used for the matching. It can be an Account ID, a Custom ID, a Contact ID, etc.

For example, feedback.feedier.com/survey-url?sf_id=123 will create an attribute sf_id with the value 123. In this option set sf_id.

Please don't hesitate to contact your Feedier Account manager for help.

...

To start writing SOQL queries, you need to access the Salesforce Developer Console. Once open, navigate to the Query Editor to begin writing SOQL queries.

Example 1: Retrieving Contact Data

Once in the Query Editor, you can run the following query to retrieve data related to a specific contact:

SELECT Id, FirstName, LastName, Email, Phone, AccountId FROM Contact WHERE Id = 'contact_id'

This query retrieves the contact’s ID, first name, last name, email, phone number, and associated account ID. Below is an example of the query and its results in the Developer Console:

Image Added

Example 2: Retrieving Account Data

To retrieve details related to a specific account, use the following query:

SELECT Id, Name, Industry, BillingCity, BillingState, BillingCountry FROM Account WHERE Id = 'Account_id'

This query fetches the account's ID, name, industry, and billing address details (city, state, and country). Below is an example of this query and its output:

...

Example 3: Retrieving Contact and Account Data Based on Contact ID

Finally, you can query both Contact and its associated Account data using the following SOQL:

SELECT Id, FirstName, LastName, Email, Phone, Account.Name, Account.Website FROM Contact WHERE Id = 'contact_id'

This query retrieves the contact’s details along with the associated account’s name and website. Below is an example of how this query looks and its result:

Image Added

Final Step: Dynamic Configuration of SOQL Queries

In the final step of integrating your SOQL queries into the dynamic environment, you will replace the hardcoded ID values used for testing in the Query Editor with a dynamic configuration. This allows the SOQL query to take a parameter from the attribute name you set in the integration field, ensuring it matches the correct Salesforce object ID.

For example, the static query tested in the editor:

SELECT Id, FirstName, LastName, Email, Phone, AccountId 
FROM Contact 
WHERE Id = '001J7000007VpctIAC'

should be replaced in the SOQL field by :

SELECT Id, FirstName, LastName, Email, Phone, AccountId 
FROM Contact 
WHERE Id = '{attribute_value}'

In this dynamic query, the placeholder {attribute_value} will automatically be replaced by the value of the attribute name you define in the integration.

If you set sf_id in the Attribute Name field, the query executed will become:

SELECT Id, FirstName, LastName, Email, Phone, AccountId 
FROM Contact 
WHERE Id = 'sf_id'

This should be your final configuration :

...

How to test the integration ?

In order to test the integration, you need to go to the surveys, choose a survey that matches the segment you created, and simulate the reception of feedback with a Salesforce ID.

...

Take the link and then manually add the attribute (the name of the attribute you pass in the URL should match the one you put in the attribute name field in your integration). So, if the URL is: https://feedback.feedier.pre-prod.alkalab.com/DXoT9Z, you need to enter in your browser: https://feedback.feedier.pre-prod.alkalab.com/DXoT9Z?sf_id=001J7000007VpctIAC.

Complete the survey, and you should receive feedback with one attribute, which is sf_id.

Wait 5 minutes, and the integration should be triggered, and you should see all the attributes you included in your SOQL.

1. Feedier will only read the first record from the query. So you can order if several records might be matched.

2. The query must contain "{attribute_value}" as this attribute value will always change and be replaced automatically. It can be an ID or a value for a LIKE query/matching.

Workflow 2: Connect to Salesforce to update a ‘Salesforce Object’ post-feedback

...

...

Setup an email campaign on Feedier as a template for sending emails

...

Setup the form as follows: 

...

...

• Name / Unique Name: Choose what you like, this has no impact with the connector

• Endpoint URL for Sandbox : https://connector-preprod.feedier.com/salesforce/push?push_campaign_id={Feedier Campaign ID}&api_key={Private API Key Feedier}

• Endpoint URL for PROD: https://connector.feedier.com/salesforce/push?push_campaign_id={Feedier Campaign ID}&api_key={Private API Key Feedier}

...

• User to send as: Choose what you like, this has no impact with the connector

• Case fields to send: Choose all data you want to attach to the feedback in Feedier. ContactEmail is required.

• Click Save

...

Create the

...

Workflow Rule

• Now, you You now need to trigger the Outbound outgoing message.

• Create a trigger with your own rules (file status = closed, for example).

• Attach the outgoing message you have created

...

• Create a trigger with your own rules (Case status = Closed Escalated for example)

Note
You can create the rule also in the Flow builder Image Added

Attach the outbound message to the workflow rule

• Now, you need to attach the Outbound message to the workflow rule so when the rule is validated an outbound message will be sent to the Endpoint URL that we set up earlier.

• Attach the outbound message you created in and you're all set. 
  

Workflow 4: If you want to pick up push status within salesforce, take a look at this guide

...

• Image AddedImage Added

Test the outbound message

Trigger the workflow rule created and you should see a push created on the Pushes page on Feedier.