Code Snippet:

SHAREPOINT_EXTERNAL_SYSTEM_KEY 	= nbtysharepoint2013
SHAREPOINT_HOSTNAME 		= nbtyglobal.sharepoint.com
SHAREPOINT_PORT 		= 80
SHAREPOINT_TIMEOUT 		= 10000
SHAREPOINT_NUM_RETRIES 		= 0


Copy a document from SharePoint to Appian

=a!shpCopyDocumentToAppian(
  scsExternalSystemKey: cons!SHAREPOINT_EXTERNAL_SYSTEM_KEY,
  usePerUserCredentials: true(),
  hostname: cons!SHAREPOINT_HOSTNAME,
  port: cons!SHAREPOINT_PORT,
  timeout: cons!SHAREPOINT_TIMEOUT,
  retries: cons!SHAREPOINT_NUM_RETRIES,
  path: "/teams/myteam/_api/web/GetFileByServerRelativeUrl('/Shared%20Documents/" & ri!filename &"')/$value",
  appianFolder: tointeger(cons!SHAREPOINT_APPIAN_FOLDER),
  appianDocumentName: ri!filename
)

The value of filename comes from UI. Value used for testing – “TestFile.txt”

TEST RESULT:
Exception: 
com.appian.integration.sharepoint.function.SharepointIntegrationDownloadFile - ConnectorRuntimeException [title=Error calling shpCopyDocumentToAppian, com.appian.integration.exception.ConnectorRuntimeException: The external server for this system [key=nbtysharepoint2013] generated an exception when calling a function [shpCopyDocumentToAppian]

Root Cause(from sever logs):
Details from external system: org.apache.http.client.ClientProtocolException
Caused by: java.net.URISyntaxException: Illegal character in path at index 91: https://nbtyglobal.sharepoint.com/teams/myteam/_api/web/GetFileByServerRelativeUrl('/Shared Documents/TestFile.txt')/$value
	at java.net.URI$Parser.fail(URI.java:2829)
	at java.net.URI$Parser.checkChars(URI.java:3002)
	at java.net.URI$Parser.parseHierarchical(URI.java:3086)
	at java.net.URI$Parser.parse(URI.java:3034)
	at java.net.URI.<init>(URI.java:595)
	at org.apache.http.impl.client.DefaultRedirectStrategy.createLocationURI(DefaultRedirectStrategy.java:186)

*******************************************
This character at index 91 is the “empty space” in “Shared Documents”.

*********************************