Pulling Yesterday data | XM Community
Skip to main content
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
Have you tried it manually using cur l to see if there is any error message?

Leave a Reply