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

Community

Connector Improvement: Totango Custom Query Support

Answered
Seth Parker User

The Totango API requires you to send a full query to it to get a response.  You cannot specify table names.  Currently Fivetran does not support custom fields in Totango as it sends a generic query to the Totango API.  We have a lot of custom fields in Totango, and the Totango data is useless to us without these custom fields.

Also, Totango can contain and return bad data without filters being used on the query.  Again, because this is a generic query for your Totango connector, we cannot use filters.

I would like to request the use of custom queries for tables in the Totango connector.  This would solve both issues as we could pass in a query containing the custom fields we need and the filters we want applied to the table.  Totango's API documentation discusses how to send the query in and provides instructions on how to easily generate the query from the Totango front-end.  Users should be able to easily generate the query they want and paste it into Fivetran if Fivetran could support the use of that query (instead of the default one) for that table.

Totango API documentation I mentioned:
Search API (accounts and users) – Totango

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Syead Mujtaba Imam Rizwi Fivetranner

    Hi Seth,

    Thank you for taking the time to share your feature request regarding custom queries for tables in the Totango connector. We appreciate your input and understand how important custom fields and filters are to your workflow.

    At this moment, this feature is not on our roadmap. However, we are committed to continuously improving our platform based on user feedback. Your suggestion is valuable, and we encourage other users who would benefit from this functionality to upvote the request. This helps us gauge interest and prioritize features that will have the most impact.

    Here are two alternatives to consider:

    1. Connector SDK: Our SDK allows you to build a connector for the source, giving you flexibility and control over the integration process.
    2. Professional Services: Our services team can also collaborate with you to identify and implement a tailored solution that meets your requirements.

    We are always open to reconsideration as we evaluate our development priorities, so please keep an eye on updates from us. Thank you once again for your engagement and support in helping us enhance Fivetran.

    Best regards,  
    Syead Mujtaba Imam Rizwi