Sharepoint workflow call http web service



*Sometimes you get unauthorized error from rest query.

just add “Authorization” with no value into request header dictionary.

*ISO formatted value is not saved into workflow date/time variable.-> so have to remove ‘Z’ character from string value and then save into workflow variable. adjust time variance using add time calculator function in SharePoint Designer.

*Check the date is Monday-> check the variable(Short Date) include ‘Monday’ Character


Get document name/page name

Get FileRef value

select FileRef

Order by, Filter by datetime and paging

$orderby=DueDate desc

$filter=DueDate gt DateTime’2014-07-31T00:00:00’


Get current time for SharePoint 2013 workflow.


Sharepoint designer workflow string limit : 255 character (history log as well)

Sharepoint Workflow throttling : 5000 outbound request/24 hour period.


Have to check the url exceed 255 character 

0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26

/items/?$select=*,FileRef,Author/Title,Editor/Title,File/Name&$expand=Author,Editor,File&$orderby=Modified desc&$filter=Modified ge datetime’2017-08-21T16:00:00Z’

/items/?$select=ID,Title,FileRef,Modified,Created,Author/Title,Editor/Title,File/Name&$expand=Author,Editor,File&$filter=Modified ge datetime’2017-08-21T16:00:00Z’






Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: