I want to build a SharePoint 2013 Site workflow for SharePoint Online using SharePoint Designer. The idea is my workflow checks every day to see if a reissue date is equal to 4 months from the current date.
Add 4 months & -23 hours to Current Date and store in dateReissue .
In my Workflow history I see
*The hardcoded (testing) or calculated ReissueDate is 2017-01-15T00:00:00Z*
In SPD the Call HTTP request
[%Workflow_Context:Current Site URL%]_api/web/lists/getbytitle('My List')/items$filter=(IssueDate eq '[%variable: dateReissue%]')
I do set the current date correctly in ISO format and the above request returns an Http OK however the response is empty.
Bizarrely, if I fire up Postman and run this query
https//tenant.sharepoint.com/site/_api/web/lists/getbytitle('My List')/items?$filter=(IssueDate eq '2017-01-15T00:00:00Z')
I get nicely populated json response ;-).
I have tried hard coding the date in SPD but I simply can't replicate the desired response, I am seeing in Postman .