How to extract data from Spotter V2 API - Python

In this text I will teach you how to extract data from Exact Spotter by API , using python. 

Spotter is a sales engagement software developed by Exact Sales that helps you convert more leads into sales . And he does this by collecting data that will enrich the qualification of leads into opportunities. Therefore, extracting this information and combining it with other sources will greatly improve your analysis.  

The first thing you need to know is that Spotter's API is RESTful and uses the OData protocol. Another important detail is that it is paginated, and returns a maximum of 500 records per request.

A REST API allows you to make GET requests to get the data that is stored in the software database.

The OData protocol allows you to apply SQL-like queries as a request parameter. If you only want data from a certain date, or only want 2 columns from the table, this is very useful.

A paged API returns a limited number of records per request. To get all the contents of the table, we need to make a request for each page.

To get data from Leads registered in Spotter, the code looks like this:

You can access the raw here ;)

Python's requests library makes requests to the url, and receives a response in json format. This json has three fields. The information we want is in the value field. In the @odata.nextLink field is the link to the next page.

In this code I used the pandas library to concatenate all pages into a single dataframe. Then you can save it as a spreadsheet, a csv, load it into a database and cross this data with information that you have extracted from other systems.

You can access data from many software features using the API. In the scheduling table, you have the history of meetings held. In the call history table, you can see the results of your team's calls, with date and time.

Take advantage of this tip to carry out analyzes that will generate a lot of impact on your operation. And any questions, just call.

Hugs!