I am trying to execute example mentioned in forum to test "Copy a Document

I am trying to execute example mentioned in forum to test "Copy a Document From Appian to SharePoint" functionality using connector functions-

forum.appian.com/.../Connector_Functions

Code / Example from forum connection and API parameters suitable to the my environment-

=load(
local!documentToSend,
a!dashboardLayout(
firstColumnContents: {
a!pickerFieldDocuments(
label: "Document To Send",
maxSelections: 1,
value: local!documentToSend,
saveInto: local!documentToSend
),
if(
isnull(local!documentToSend),
{},
load(
local!shpCopyDocumentFromAppianWriter: bind(
null,
a!shpCopyDocumentFromAppian(
scsExternalSystemKey: "sharepoint",
usePerUserCredentials: true,
hostname: cons!SHAREPOINT_HOSTNAME,
port: cons!SHAREPOINT_PORT,
...

OriginalPostID-112434

OriginalPostID-112434

  Discussion posts and replies are publicly visible

Parents
  • I am able to upload files from Appian to Sharepoint 2013 using the connecto, I just had to update the example in the documentation to include the extension of the file to avoid uploading a file without extension.

    Please do the following:

    1. Stop JBoss
    2. Delete <JBOSS_HOME>\\log\\*.log
    3. Delete <JBOSS_HOME>\          mp\\*.*
    4. Add these lines to ear|runtime_ear\\suite.ear\\resources\\appian_log4j.properties around line 20 (the location is arbitrary)

    log4j.logger.com.appian.integration=DEBUG
    log4j.logger.com.appiancorp.core.expr.DelayedWriteContext=DEBUG

    5. Start JBoss
    6. Import the attached application
    7. Update these constants so they match your Sharepoint server

    APPIAN_SUPPORT_SHAREPOINT_HOSTNAME
    APPIAN_SUPPORT_SHAREPOINT_PORT

    8. Use the Rules interface to generate the following URL

    =cons!APPIAN_SUPPORT_SHAREPOINT_HOSTNAME & ":"&APPIAN_SUPPORT_SHAREPOINT_PORT & "/Shared%20Documents"

    9. Copy and paste the resulting URL in your browser and confirm this is a valid path
    10. Back to Appian open the interface AppianSupportSharepointUploadFileInterface
    11. In the Documents picker select "uploadme.txt"
    12. Click "Send" and wait for the "Working" message to go away
    13. Access the URL from step 8 again and see if there's now a file called uploadme.txt
    14. If not, then attach <JBOSS_HOME>\\standalone\\log\\server.log
    15.

    SharepointConnector.zip

Reply
  • I am able to upload files from Appian to Sharepoint 2013 using the connecto, I just had to update the example in the documentation to include the extension of the file to avoid uploading a file without extension.

    Please do the following:

    1. Stop JBoss
    2. Delete <JBOSS_HOME>\\log\\*.log
    3. Delete <JBOSS_HOME>\          mp\\*.*
    4. Add these lines to ear|runtime_ear\\suite.ear\\resources\\appian_log4j.properties around line 20 (the location is arbitrary)

    log4j.logger.com.appian.integration=DEBUG
    log4j.logger.com.appiancorp.core.expr.DelayedWriteContext=DEBUG

    5. Start JBoss
    6. Import the attached application
    7. Update these constants so they match your Sharepoint server

    APPIAN_SUPPORT_SHAREPOINT_HOSTNAME
    APPIAN_SUPPORT_SHAREPOINT_PORT

    8. Use the Rules interface to generate the following URL

    =cons!APPIAN_SUPPORT_SHAREPOINT_HOSTNAME & ":"&APPIAN_SUPPORT_SHAREPOINT_PORT & "/Shared%20Documents"

    9. Copy and paste the resulting URL in your browser and confirm this is a valid path
    10. Back to Appian open the interface AppianSupportSharepointUploadFileInterface
    11. In the Documents picker select "uploadme.txt"
    12. Click "Send" and wait for the "Working" message to go away
    13. Access the URL from step 8 again and see if there's now a file called uploadme.txt
    14. If not, then attach <JBOSS_HOME>\\standalone\\log\\server.log
    15.

    SharepointConnector.zip

Children
No Data