Pulling Yesterday data | XM Community
Question

Pulling Yesterday data

  • 21 March 2019
  • 1 reply
  • 13 views

Greetings,

I am trying to pull responses via API using Python. My attempts have gone pretty well, except I only want previous days data. For some reason is pulling all data. I know I can manually put in yesterday date, however, I need this to be automated. I am using the below code...Thank you in advance.

# Python 3



import requests
import zipfile
import json
import io
import urllib3
import urllib
import shutil

from datetime import datetime, timedelta, date

current_full_date = date.today()
d = current_full_date - timedelta(1)
d = str(d)
d = datetime.strptime(d, '%Y-%m-%d').strftime('%Y-%m-%dT00:00:00-05:00')
e = current_full_date - timedelta(1)
e = str(e)
e = datetime.strptime(e, '%Y-%m-%d').strftime('%Y-%m-%dT23:59:59-05:00')
dt = date.today() - timedelta(1)
dt = str(dt)
dt = datetime.strptime(dt, '%Y-%m-%d').strftime('%m-%d-%Y')

oldname = ""
newname = ""
oldname2 = ""

Setting user Parameters


apiToken = ""
surveyId = ""
fileFormat = "csv"
startDate = d
endDate = e

1 reply

Userlevel 3
Badge +11
Have you tried it manually using cur l to see if there is any error message?

Leave a Reply