Request Report API



I am trying to do a API call to get Shipments data for previous day. This is how, I am requesting but its not getting correct data.

EXEC RequestReport @ReportType = ’ GET_AMAZON_FULFILLED_SHIPMENTS_DATA’, @StartDate=’{StartDate}’, @EndDate=’{EndDate}’

StartDate and EndDate are my parameters which I pass. See below, I pass using SQL query to get those dates and pass.

Select Convert(varchar,Convert(date,DATEADD(DD,-1,GetDate())))+ ‘T00:00:00-07:00’ as StartDate,Convert(varchar,Convert(date,DATEADD(DD,-1,GetDate()))) + ‘T23:59:59-07:00’ as Enddate

Can you please help me in passing correct Date time format. We are UTC time based. I am stuck on this, any help will be good.



Can you be more specific in what you mean by “correct data”?