Sharepoint workflow call http web service

Reference:

http://www.c-sharpcorner.com/UploadFile/58e23e/call-http-web-service-using-sharepoint-designer-2013-spd/

https://code.msdn.microsoft.com/officeapps/sharepoint-2013-accessing-a90295d2

https://dev.office.com/sharepoint/docs/general-development/working-with-web-services-in-sharepoint-workflows-using-sharepoint-designer

 

*Sometimes you get unauthorized error from rest query.

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

https://sharepoint.stackexchange.com/questions/118876/call-http-web-service-unauthorized

*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

https://social.msdn.microsoft.com/Forums/Lync/en-US/a9db1de8-a182-455a-88fa-af918c6e22c1/get-document-name-from-2013-workflow?forum=sharepointcustomization

https://weblogs.asp.net/ricardoperes/looping-through-list-items-in-sharepoint-2013

Get FileRef value

select FileRef

Order by, Filter by datetime and paging

$orderby=DueDate desc

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

$top=20

Get current time for SharePoint 2013 workflow.

http://myknowlex.blogspot.com.au/2016/01/sharepoint-2013-online-workflow-get.html

 

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

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

https://support.microsoft.com/en-us/help/3076399/sharepoint-2013-workflow-throttling-and-performance-in-sharepoint-onli

 

 

https://weblogs.asp.net/ricardoperes/getting-the-weather-forecast-using-sharepoint-workflows

 

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
12345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890

/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’

 

 

 

 

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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: