UserVoice

UserVoice is a product feedback management solution that collects and organizes feedback from multiple sources to provide a clear, actionable view of user feedback for product teams.

Data integration: Skyvia supports importing data to and from UserVoice, exporting UserVoice data to CSV files, replicating UserVoice data to relational databases and synchronizing UserVoice data with other cloud apps and relational databases.

Backup: Skyvia Backup does not support UserVoice backup.

Query: Skyvia Query supports UserVoice.

UserVoice Specific Features and Limitations

Comments — When you perform a DELETE operation on the Comments table, the records are not being removed from the table, the value in the State field is changed to “deleted” instead. The native filtering is supported for the State field.

CurrentSubdomains — You receive only the current subdomain when selecting data from the CurrentSubdomains object. You can update any domain by its id when executing an UPDATE.

Views — Views object can be accessed only via its parent Users object. To query Views records, UserVoice API requires ids of the corresponding User records.

Skyvia does not require the ID of the parent object from user. If you don’t specify the IDs of the parent objects (for example, in a filter), Skyvia queries all the parent object records first, takes their IDs and then queries child object records for each parent object record. This allows querying child objects without knowing their parents, but this method takes much time and consumes many API calls. It uses at least one API call for every parent object record. Thus, working with child records can be slow.

Because of this, it is recommended to use filters on the parent object fields when querying data from such child objects. This reduces the number of parent object records, for which child object data must be queried.

StatusUpdates — When an UPDATE operation is performed, the record is updated, but the UpdatedDate value does not change automatically. Thus, records updated in such way will not be taken into account during Replication with Incremental Updates and Synchronization.

Delete operation does not delete the record from the table. It clears the values in Body and HtmlBody fields and updates the UpdatedDate field. Records updated in such way will be taken into account during Replication with Incremental Updates and Synchronization.

Stored Procedures

  • call RejectSuggestedMerge(:id, :reason)

Use RejectSuggestedMerge procedure to reject the suggested merge in the SuggestedMerges object. Pass id from the SuggestedMerges table and reason as parameters. After the procedure execution, the record receives “rejected” status and is not displayed in the SuggestedMerges table.

  • call ClearInternalFlag(:id, :cleared_message)

Use ClearInternalFlag procedure to clear the internal flag in the InternalFlags object . Pass id from the InternalFlags table and set cleared_message as parameters. After the procedure execution, the specified record receives a date value in ClearedAt field, and data appears in the ClearedMessage and Links_ClearedBy columns.

DML Operations

Skyvia supports the following DML operations for UserVoice objects:

INSERT, UPDATE, DELETE - Categories, Comments, CustomFields, Features, FeedbackRecords, FeedbackRecordsWithLinks, FeedbackRecordsWithoutLinks, Labels, Notes, Permissions, StatusUpdates, Suggestions, Teams, Views

INSERT, DELETE - ForumInvitations, NPSRatings

INSERT, UPDATE - InternalStatusUpdates

UPDATE - CurrentSubdomains

INSERT - ExternalAccounts, ExternalUsers, InternalFlags, SupporterMessages

Synchronization and Replication with Incremental Updates

The following objects do not support Replication with Incremental Updates:

  • CurrentSubdomains
  • ImportanceResponses
  • Permissions
  • Teams

The following objects support Synchronization:

  • Categories
  • Comments
  • CustomFields
  • Features
  • FeedbackRecordsWithLinks
  • FeedbackRecordsWithoutLinks
  • FeedbackRecords
  • Labels
  • Notes
  • StatusUpdates
  • Suggestions
  • Views

UserVoice Connections

To establish a connection, you need to use your subdomain values, a Key, and a Secret. You may find them in your UserVoice account settings.

To locate your authentication credentials, do the following:

Getting Credentials

  1. Login to your UserVoice account.
  2. You can find your Subdomain value in the web adress line before uservoice.com.
  3. To get Key and Secret, navigate to Settings->Integrations->UserVoice API keys.
  4. Click Create API Keys.
  5. Set a name that will describe your connection the best, hit Trusted checkbox and click Add API Key.
  6. Key and Secret pair will appear under the UserVoice API Keys section.

To create connection between Skyvia and UserVoice, do the following:

Creating Connection

  1. Select new UserVoice connection.
  2. Enter subdomain of your UserVoice account.
  3. Enter your Key and Secret.
  4. Click Create Connection.

Supported Actions and Actions Specifics

UserVoice connector supports the following actions:

  • [Execute Command]((../actions/execute-command-action.html) in Source, Lookup, and Target Data Flow components and in Import and Export tasks in the Advanced mode.
  • Execute Query in Source Data Flow components and in Import and Export tasks in the Advanced mode.
  • Lookup in Lookup Data Flow components.
  • Insert in Target Data Flow components.
  • Update in Target Data Flow components.
  • Delete in Target Data Flow components.