ICON
Help Center / Spotzi Webservice /

Spotzi Webservice

The Spotzi Webservice allows users to automate key aspects of their workflow by connecting datasets stored in their Spotzi account to other services. Spotzi's demographics data, consumer insights, and other datasets can then collaborate with the tools and services most relevant to your brand or business. Similarly, Spotzi's Webservice can be used to streamline updates to your own datasets within the Spotzi platform.

Introduction

There are four types of requests that can be fulfilled by Spotzi's Webservice.

A walkthroughs of each request can be found in the corresponding Help Center articles. Spotzi's Webservice is available to all Analytics Plan users via the Spotzi Webservice App; keep reading to learn more about this webservice and its uses.

Base URL

A typical webservice request is as follows:

https://webservice.spotzi.com/visualization/wo/sql?parameters

Parameters


The parameters appended to the Base URL of Spotzi's Webservice consist of the parameter name followed by the parameter value. These parameters are split by the & sign. A typical parameter generally follows the form below:

parameter_name=parameter_value&

Please see this table for an overview of the required parameters:

q = The request query that has to be executed

EXAMPLE: SELECT * FROM tablename LIMIT 1


userName = A valid username

EXAMPLE: demouser


userKey = A valid apikey

EXAMPLE: 1973b5f4b6d0eda968092eecb8362d589ac9a496


format = The desired response format (see Response formats)

EXAMPLE: application/json

Response formats


The following response formats are available within the Spotzi Webservice.

Name Type HTTP content type
CSV File/text text/csv
JSON Text application/json
XML Text text/xml

 

 

 

Examples


A typical webservice request — with all of its parameters — can be seen below:

https://webservice.spotzi.com/visualization/wo/sql?q=SELECT description, name FROM dataset_name&userName=demouser&userKey=xxx&format=application/json

You can find examples of each possible request type in the corresponding articles:

Please note that users require a Analytics Plan in order to use the Spotzi Webservice.

Related blog posts

Gain Instant Access to a World of Maps

Spotzi Explorer is an integrated data catalog that lets you quickly and easily add data to your dashboards. Access a rich collection of maps and dashboards—explore postal codes, discover global income insights, or get inspired by maps created by our community. It’s the ideal tool for marketers, researchers, students, and anyone looking to enhance their market research, plan an OOH campaign, or work with location data.

Postal Codes Map
Create your free account Browse Datasets

Ready to turn your data into insights?

Spotzi's platform streamlines the process of geomarketing research & analysis by providing you with a one-stop-shop for all of your mapping and location data needs.

Are you ready to take your campaigns to the next level? Contact us to learn more about our plans.

Contact us

Contact

Spotzi North America
  • 125-720 King Street West
  • Toronto ON M5V 3S5
  • Canada
Spotzi Europe
  • Joulehof 9
  • 4622 RG Bergen op Zoom
  • The Netherlands