Integration with Social Media API

Posted by neetuagw on 15-Oct-2014 08:31

Hi,

Can I integrate my CRM application with Social Media APIs like Facebook , Linkedin, twitter, Google analytic, mail chimp???.

All Replies

Posted by Godfrey Sorita on 15-Oct-2014 09:42

You can use 'Send HTTP Post' or 'Send HTTP Get Request' trigger types to integrate with these APIs.

Send HTTP Post trigger sends request to a specified URL. It can be used to send any XML or other POST request to a third party containing information and instructions gathered from Rollbase record data.

Send HTTP Get trigger sends an HTTP GET request to a specified URL. It can be used to send a REST-style request to a third party.

After the HTTP response is retrieved by GET or POST Trigger, the system stores two values and makes them available for subsequent Triggers through the getSharedValue() API.

Posted by neetuagw on 15-Oct-2014 10:53

Thanks for your response.

Actually I am trying to create an application in Rollbase that run a marketing campaign in different social media sites like facebook twitter .and I want to track that campaign.

My actual question is can we achieve this , can we track our campaign using Rollbase.

Posted by Godfrey Sorita on 15-Oct-2014 12:03

Before I answer your question, I need to know how you plan to track your campaigns. Do you have a Facebook application which handles the tracking?

Rollbase can access the APIs of social media sites using Send HTTP POST or GET request but doing it the other way around is another story. These social media sites can only communicate to Rollbase using REST or SOAP APIs.

Posted by neetuagw on 16-Oct-2014 04:48

Hi Godfrey,

I am tracking my campaign in social media  using Google Analytic.

So can I show the google analytic statics or data in my CRM application??

Posted by pvorobie on 16-Oct-2014 07:50

You can extract Google Analytic data using Google API:

developers.google.com/.../gdataReferenceDataFeed

Posted by Godfrey Sorita on 16-Oct-2014 12:18

You can also use Google Analytics Embed API to display dashboards in Rollbase pages. For more information on this API, please check their documentation: https://developers.google.com/analytics/devguides/reporting/embed/v1/

So far the charts have worked in my page but it will require a user to login with their Google Account. Please paste the script below in a script component and update the value of CLIENT_ID:

<!-- Step 1: Create the containing elements. -->

<section id="auth-button"></section>
<section id="view-selector"></section>
<section id="timeline"></section>

<!-- Step 2: Load the library. -->

<script>
(function(w,d,s,g,js,fjs){
  g=w.gapi||(w.gapi={});g.analytics={q:[],ready:function(cb){this.q.push(cb)}};
  js=d.createElement(s);fjs=d.getElementsByTagName(s)[0];
  js.src='https://apis.google.com/js/platform.js';
  fjs.parentNode.insertBefore(js,fjs);js.onload=function(){g.load('analytics')};
}(window,document,'script'));
</script>

<script>
gapi.analytics.ready(function() {

  // Step 3: Authorize the user.

  var CLIENT_ID = 'Insert your client ID here';

  gapi.analytics.auth.authorize({
    container: 'auth-button',
    clientid: CLIENT_ID,
  });

  // Step 4: Create the view selector.

  var viewSelector = new gapi.analytics.ViewSelector({
    container: 'view-selector'
  });

  // Step 5: Create the timeline chart.

  var timeline = new gapi.analytics.googleCharts.DataChart({
    reportType: 'ga',
    query: {
      'dimensions': 'ga:date',
      'metrics': 'ga:sessions',
      'start-date': '30daysAgo',
      'end-date': 'yesterday',
    },
    chart: {
      type: 'LINE',
      container: 'timeline'
    }
  });

  // Step 6: Hook up the components to work together.

  gapi.analytics.auth.on('success', function(response) {
    viewSelector.execute();
  });

  viewSelector.on('change', function(ids) {
    var newIds = {
      query: {
        ids: ids
      }
    }
    timeline.set(newIds).execute();
  });
});
</script>

Posted by neetuagw on 17-Oct-2014 04:15

Hi Godfrey,

I tried this but I am getting error : see the picture below:

While creating the client id I have used "https://www.rollbase.co" URL in javascript origin and left empty the AUTHORIZED REDIRECT URI.

I am not getting the error.

 

Posted by neetuagw on 17-Oct-2014 04:21

Hi Godfrey

Its working now.I did changes in "APIs & auth" -> "Consent screen"  and it starts working.

Thank you so much for your response.

Posted by Godfrey Sorita on 17-Oct-2014 10:00

I had the same problem too. However, I was able to resolve it by enabling my account's Analytics API. Thank you for sharing your Google API and authentication settings.

This thread is closed