Grab Helpscout Conversations and Store in JSON File

hs_conversations.py

import requests
import json
import io
from requests.auth import HTTPBasicAuth
 
api_key = 'daa5ba542ef9e029ec90316f21647d97d74c20f5'
 
pages=50
page=1

while page < pages + 1:
    raw_result = requests.get('https://api.helpscout.net/v1/mailboxes/%s/conversations.json?tag=%s&page=%s' % (320, 'pp business', page), auth=HTTPBasicAuth(api_key, 'pass'))
    result = json.loads(raw_result.text)
    pages = result['pages']
    page = result['page'] + 1
 
    for item in result['items']:
        conversation_id = item['id']
        raw_result = requests.get('https://api.helpscout.net/v1/conversations/%s.json' % (conversation_id), auth=HTTPBasicAuth(api_key, 'pass'))
        result = json.loads(raw_result.text)
 
        # Find the email that the customer wrote in with originally.
        num_threads = len(result['item']['threads'])
        initial_email = result['item']['threads'][num_threads-1]['body']
 
        # Remove any browser info we added.
        browser_info_index = initial_email.find('<hr/>\n<p>Browser: ')
        if browser_info_index != -1:
            initial_email = initial_email[0:browser_info_index]
 
        # Also, for now, get rid of any HTML-y emails
        if initial_email.find('</') != -1:
        	continue
        print initial_email
 
        with io.open("./hs/%s.json" % 'business', "a", encoding='utf8') as inbox_file:
            raw_output = json.dumps(initial_email,ensure_ascii=False)
            inbox_file.write(unicode('%s\n' % raw_output))