Introduction

Basic python script that uses the search API of pivotal tracker and zendesk help center to pull data and store them to excel.

How to use it

• Install Python 3.5
• Install all the requirements using pip install -r requirements.txt
• To pull data from tracker use the command like below

python data_scroller.py tracker -p <project-id> -q <search-string> -t <tracker token>

• To pull data from zendesk use the command like below

python data_scroller.py zendesk -u <zd username> -p <zd password> -q <query string> -e <zd-endpoint>

Example

Tracker

• To pull all data with label 2.0

python data_scroller.py tracker -p <project-id> -q label:2.0 -t <tracker token>

• To pull data for all stories created since 11/16/2017

python data_scroller.py tracker -p <project-id> -q created_since:11/16/2017 -t <tracker token>

Zendesk

• To pull all data with keyword 2.0

python data_scroller.py zendesk -u <zd username> -p <zd password> -q 2.0 -e <zd-endpoint>

• To pull all data with keyword 2.0 which is updated after 2014-01-01 and before 2014-02-01

python data_scroller.py zendesk -u <zd username> -p <zd password> -q "2.0&updated_after=2014-01-01&updated_before=2014-02-01" -e <zd-endpoint>

More information

• For more information on Zendesk search keywords, refer to the link
• For more information on Tracker search keywords, refer to the link