Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Add Cases Endpoint Support for Sprout Social Connector

Planned
Rose Chou User

Hi Fivetran team,

We're currently using the Sprout Social connector but need access to the Cases endpoint (bottom of the document: https://api.sproutsocial.com/docs/#cases-endpoints) which isn't supported in the native connector. This is critical for our social media support analytics.

Business Impact: We need to understand the demand (number of tickets) coming to our social team for capacity planning and performance tracking. Without access to the Cases endpoint, we cannot:

  • Track social support ticket volume
  • Measure response times
  • Analyze support demand trends
  • Report on social team performance

Technical Details:

  • Requires OAuth 2.0 authentication
  • Cases Endpoint API is available in Sprout Social's API documentation
  • Current Fivetran connector doesn't expose this endpoint

Thank you for considering this enhancement!

Please sign in to leave a comment.

Comments

7 comments

Date Votes
  • Official comment
    Vishal Ray User

    Hi Heidi and Rose,

    Just wanted to provide an update on this request.

    We have added Case data to Sprout connector and it is under early rollout.

    It has been enabled for your account - you can try the Sprout Connector to see this data.

    Let me know if you have any queries or feedback for this.

    Thank You,

    Vishal

  • Vishal Ray User

    Hi Rose,

     

    Thank you for providing all the relevant details about the CASE endpoint. This looks to be valuable data for Sprout Social. It seems that cases are created from messages - Do you think Message data is also valuable for your use case - https://api.sproutsocial.com/docs/#messages-endpoint

    Regarding Cases Endpoint - This looks to be something that we can do, but can you confirm regarding the OAuth usage for this endpoint access? I was not able to find any links that mention that - https://api.sproutsocial.com/docs/#cases-endpoints.

    Fivetran Sprout Social Connector uses an API Token for authentication, and I wanted to see if we can use that for accessing this endpoint.

     

    Thank You,

    Vishal

  • Rose Chou User

    Hi Vishal,

    Thanks for reviewing this!

    For our immediate use case, the Cases endpoint alone would be sufficient. The Cases endpoint provides the support ticket metrics our team needs (volume, status, priority, queue assignments, response times). While the Messages endpoint could provide additional context with full message content, it's not urgent. We can always revisit adding Messages support later if needed.

    I'm curious - which endpoints does the Sprout Social connector currently support?

    Based on what our internal stakeholder mentioned, we will need to connect to Sprout Social via OAuth 2.0 to extract the Cases Endpoint: https://api.sproutsocial.com/docs/#using-oauth-20

    Thanks,
    Rose

  • Heidi Smith User

    Hi Vishal,

     

    Any update here? We'd like to implement this one soon and are curious if there will be a native connector or if we should move forward with creating a custom one.

     

    Thanks,

    Heidi

  • Vishal Ray User

    Hi Heidi,

    We have prioritized this on our side and are hoping to deliver it tentatively by the end of November, as we are in the process of releasing THREADS data. Let me know if you'd like to get added for early review of these new tables 

    • threads_profile_analytics

    • threads_profile_post

    Thank You,

    Vishal

  • Heidi Smith User

    Thanks for the update, Vishal! Please keep me in the loop for any updates as you have them!

     

    Cheers,

    Heidi

  • Heidi Smith User

    Thanks so much, Vishal! Much appreciated!