How to Integrate Retool with Agorapulse

Agorapulse uses OAuth 2.0 for API authentication. Before configuring Retool, you need a valid access token. Log into your Agorapulse account and navigate to your account settings to find the API/Developer section. Create an OAuth application to get a client_id and client_secret. To obtain an initial access token, use Agorapulse's token endpoint. Send a POST request to https://app.agorapulse.com/api/oauth/token with a JSON body containing your grant_type, client_id, client_secret, and (for the authorization code flow) the authorization code you obtain from the OAuth consent screen. For server-to-server internal tools, use the client credentials grant if your plan supports it. The response contains an access_token (valid for a configurable duration) and a refresh_token. Copy the access_token — you will use it in the Retool resource configuration. Store the refresh_token securely in Retool's configuration variables, as you will need it to obtain new access tokens when the current one expires. For production Retool integrations, consider building a Retool Workflow on a schedule that automatically refreshes the Agorapulse token before it expires and updates the configuration variable. This prevents 401 errors from appearing in your team's dashboards when tokens go stale.

Navigate to the Resources tab in your Retool instance and click Add Resource. Select REST API from the resource type list. Name the resource 'Agorapulse API'. In the Base URL field, enter https://app.agorapulse.com/api. This is Agorapulse's REST API base URL — all endpoint paths in your queries will append to this URL. Do not include a trailing slash. For authentication, select Bearer Token from the Authentication dropdown. In the Token field, reference your configuration variable using the expression {{ retoolContext.configVars.AGORAPULSE_ACCESS_TOKEN }}. This keeps the token out of the resource settings UI and allows you to rotate it without editing the resource configuration. Alternatively, for initial testing you can paste the access token value directly into the Token field. However, for any team-shared or production Retool instance, always use configuration variables for credentials. Add a default header for the API version if required by the Agorapulse API version you are targeting. Check Agorapulse's current API documentation for any required headers such as Accept: application/json. Click Save Changes to create the resource.

Create your first query to pull inbox items. In your Retool app, open the Code panel and click the + button to add a new query. Name it getInboxItems and select the Agorapulse API resource. Set Method to GET. In the Path field, enter /inbox. Agorapulse's inbox endpoint returns items from your social profiles' inboxes — comments, messages, mentions, and reviews. Add URL parameters to filter the results: - Add a parameter: key = status, value = {{ select_status.value || 'pending' }} — this lets a Dropdown component in your app control which status is shown (pending, assigned, reviewed) - Add a parameter: key = per_page, value = 50 - Add a parameter: key = page, value = {{ pagination.current || 1 }} Create a second query named getProfileList (GET, path /profiles) to retrieve all connected Agorapulse social profiles. Use this to populate a profile filter dropdown in your app. Bind the Dropdown component options to {{ getProfileList.data.map(p => ({ label: p.name + ' (' + p.provider + ')', value: p.id })) }}. Create a third query named getInboxByProfile with an additional URL parameter: key = profile_ids[], value = {{ dropdown_profile.value }} to filter inbox items to a specific profile. Add a JavaScript transformer to flatten the inbox response into table-friendly rows with the fields your team needs.

1// JavaScript transformer — flatten Agorapulse inbox items for the Table component
2const items = data || [];
3return items.map(item => {
4  return {
5    id: item.id,
6    platform: item.profile?.provider || 'unknown',
7    profile_name: item.profile?.name || 'N/A',
8    author: item.author?.name || item.author?.username || 'Anonymous',
9    message_preview: (item.text || item.content || '').substring(0, 120) + '...',
10    status: item.status || 'pending',
11    assigned_to: item.assigned_agent?.name || 'Unassigned',
12    tags: Array.isArray(item.tags) ? item.tags.join(', ') : '',
13    published_at: item.published_at
14      ? new Date(item.published_at).toLocaleString()
15      : 'N/A',
16    inbox_url: item.url || ''
17  };
18});

Create analytics queries to pull engagement metrics across your Agorapulse profiles. Create a query named getProfileAnalytics. Set Method to GET and Path to /analytics/profiles/{{ dropdown_profile.value }}/summary. Add URL parameters: - key = start_date, value = {{ dateRange.start }} (formatted as YYYY-MM-DD) - key = end_date, value = {{ dateRange.end }} This returns summary engagement metrics — total posts, likes, comments, shares, reach, and impressions for the selected profile and date range. For post-level performance data, create a second query named getTopPosts with Path /analytics/profiles/{{ dropdown_profile.value }}/posts, sorted by engagement. This returns individual post metrics that can populate a leaderboard Table. Add a Date Range Picker component named dateRange to your app to control the analytics window. Connect it to both analytics queries so changing the date range triggers new queries automatically using the onChange event handler. Add a Chart component (Retool supports Plotly.js-based charts) for visualizing engagement trends. Set the Chart data to {{ getProfileAnalytics.data?.daily_metrics || [] }} and configure the x-axis as date and y-axis as total_engagement. For cross-profile comparison, create a query named getAllProfilesAnalytics that iterates through profiles and aggregates metrics. Use a JavaScript query to merge the results: loop through getProfileList.data, trigger individual analytics queries with Promise.all(), and return a combined dataset for a comparison bar chart.

1// JavaScript transformer — format analytics summary for stat components
2const summary = data || {};
3return {
4  total_posts: summary.posts_count || 0,
5  total_likes: summary.likes_count || 0,
6  total_comments: summary.comments_count || 0,
7  total_shares: summary.shares_count || 0,
8  total_reach: summary.reach ? summary.reach.toLocaleString() : '0',
9  total_impressions: summary.impressions ? summary.impressions.toLocaleString() : '0',
10  avg_engagement_rate: summary.engagement_rate
11    ? `${(summary.engagement_rate * 100).toFixed(2)}%`
12    : '0.00%',
13  top_platform: summary.best_performing_network || 'N/A',
14  date_range: `${summary.start_date || ''} → ${summary.end_date || ''}`
15};

Extend your inbox panel with write operations — replying to messages and assigning inbox items to team members. These mutations use POST requests to Agorapulse's inbox action endpoints. Create a query named replyToInboxItem. Set Method to POST and Path to /inbox/{{ table_inbox.selectedRow.id }}/reply. In the Body section, select JSON type and enter: { "text": "{{ textInput_reply.value }}" }. This posts a reply directly to the social platform through Agorapulse. Create a query named assignInboxItem. Set Method to POST and Path to /inbox/{{ table_inbox.selectedRow.id }}/assign. Body: { "agent_id": "{{ dropdown_agent.value }}" }. You will need a query named getTeamMembers (GET, /teams/{{ teamId }}/members) to populate the agent dropdown options. Create a query named markAsReviewed. Set Method to POST, Path /inbox/{{ table_inbox.selectedRow.id }}/review, no body required. In your Retool app, add a TextArea component named textInput_reply for composing replies, a Dropdown named dropdown_agent populated from getTeamMembers, and action buttons for Reply, Assign, and Mark Reviewed. Configure event handlers on each button to trigger the appropriate query. Add an On success handler to each write query that calls getInboxItems.trigger() to refresh the inbox table after the action completes. For RapidDev-style social management tools that combine multi-platform inbox data, assignment workflows, and analytics in a single panel, Retool's multi-resource architecture makes it straightforward to layer in CRM data alongside Agorapulse for enriched customer context.

1// JSON body for the replyToInboxItem query
2{
3  "text": "{{ textInput_reply.value }}",
4  "platform": "{{ table_inbox.selectedRow.platform }}"
5}