Available Routes

• GET usacsflat: list survey requests, responses, testimonials
• GET usacsflat-locations: list locations with stats
• GET usacsflat-users: list users with stats
• GET usacsflat-surveymeta: returns survey questions and mean answers across matching responses
• GET usacsflat-surveyanswers: returns survey questions and counts of distinct answers across matching responses
• GET survey-structure-generate/{surveyID}: generates json structure of the given survey id from legacy db structure
• GET survey-structure-generate-random: generates json structure of a random survey from legacy db structure
• GET testimonials: list/query the Testimonial model; includes user and surveyTaken relations
• GET testimonials/{id}: show the Testimonial model with the given id; includes user and surveyTaken relations
• GET survey: list/query the SurveyStructure model by survey_id
• GET survey/{surveyID}: show the SurveyStructure where survey_id=surveyID
• PATCH survey/{surveyID}: update the SurveyStructure model of the given survey
• DELETE survey/{surveyID}: soft-deletes the SurveyStructure model of the given survey
• GET survey/{surveyID}/questions: gets a list of questions
• GET survey/{surveyID}/question-names: get a list of question names
• GET survey/{surveyID}/submissions: get a list of submissions for the survey
• GET survey-submissions: list/query the SurveySubmission model
• GET survey-submissions/{taken_id}: show the msot recent SurveySubmission with the given taken_id
• PATCH survey-submissions/{id}: update the SurveySubmission with the given id
• DELETE survey-submissions/{id}: delete the SurveySubmission with the given id
• GET locations: list of locations imported
• GET locations/{id}: show the imported location with the given id
• DELETE locations/{id}: delete the imported location with the given id
• GET statistics/submissions-requests: calculates total requests and responses
• GET statistics/average-rating: calculates average testimonial rating
• GET statistics/average-score: calculates average survey submission score
• GET statistics/nps: calculates NPS
• GET statistics/counts: counts negative and positive reviews
• GET statistics/combined: combines all three other statistics routes
• GET statistics/userlist: list of users (and stats) ranked by quality_score metric
• GET statistics/locations: list of locations (and stats) ranked by quality_score metric
• GET statistics/question/{surveyID}/{questionName}: get statistics for the answers of the given question for the given survey
• GET statistics/question-all/{surveyID}: get statistics for the answers of all questions in a given survey
• GET statistics/time-series: time series data; special params: completed=boolean&groupBy=[day,week,month,year]&averages[{column}]={as}&counts[{column}]={as}
• GET gamification-settings: lists all GamificiationSettings for the account with showOnDashboard=1 (unless &includeAll=1 included)
• GET gamification-settings/{id}: shows the GamificiationSettings with the given id
• GET gamification-calculate/{id}: calculates the score for the gamification with the given id, account, and filters
• GET gamification-calculate-all: calculates the score for all gamifications for the account and filters
• GET discrepancy: lists import discrepancies visible to the user
• GET discrepancy/{id}: shows import discrepancy with the given id
• DELETE discrepancy/{id}: deletes the import discrepancy with the given id
• GET screens: lists reporting screens visible to the user (unauthenticated=system default screens only)
• GET screens/{id}: shows the reporting screen with the given id (if user has access; unauthenticated=system default screens only)
• GET screens-get-route: returns the correct reporting screen for a given user and route param (unauthenticated=system default screens only)
• GET screens-generate-config: returns template reporting screen config for the given widgets=csv param
• GET check-auth: returns authentication data derived from legacy db for given authToken
• GET testimonials: lists testimonials from the legacy db
• GET testimonials/{id}: shows the testimonial from the legacy db with the given id
• GET testimonials/{id}/widgets: shows the widgets to which the testimonial is attached in the legacy db
• GET widgets: lists widgets from the legacy db
• GET widgets/{id}/testimonial: shows the testimonials attached to the widget in the legacy db
• POST widgets/{id}/testimonial/{testimonial_id}: links the widget with the testimonial in the legacy db
• DELETE widgets/{id}/testimonial/{testimonial_id}: unlinks the widget from the testimonial in the legacy db
• GET external-site-parents: lists ExternalSite parents (site_id, parent_site_name, image)
• GET external-sites: lists ExternalSite models
• GET external-sites/{site_data_id}: shows the ExternalSite with the given site_data_id
• GET external-sites/{site_data_id}/traffic: lists the ExternalSiteTraffic for the given ExternalSite
• GET external-sites-traffic: lists ExternalSiteTraffic models
• GET external-sites-traffic/stats/listings: counts for ExternalSiteTraffic grouped by site_data_id
• GET external-sites-traffic/stats/sources: counts for ExternalSiteTraffic grouped by site_id