Sharepoint 2013 integration issue -

I am trying to execute example mentioned in forum to test "a!shpInvoke() - to Get metadata of files in SharePoint 2013 to Appian 16.3 (Cloud)" functionality using connector functions-

forum.appian.com/.../Connector_Functions.html

Code / Example from forum connection :-

=load(
local!pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: 10,
sort: a!sortInfo(
field: "Name",
ascending: true
)
),
with(
local!sharepointQueryResult: a!shpInvoke(
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: "/_api/Web/getfolderbyserverrelativeurl('Shared%20Documents')/Files?$select=Name,ServerRelativeUrl,Time...

OriginalPostID-265590


jboss1-stdOut.log

  Discussion posts and replies are publicly visible

  • ...Created",
    httpMethod: "GET"
    ).result.d.results,
    local!sharepointFilesDataSubset: todatasubset(local!sharepointQueryResult, local!pagingInfo),
    a!dashboardLayout(
    firstColumnContents: {
    a!gridField(
    label: "Files in Sharepoint",
    totalCount: local!sharepointFilesDataSubset.totalCount,
    columns: {
    a!gridTextColumn(
    label: "Name",
    field: "Name",
    data: local!sharepointFilesDataSubset.data.Name
    ),
    a!gridTextColumn(
    label: "Time Created",
    field: "TimeCreated",
    data: local!sharepointFilesDataSubset.data.TimeCreated
    )
    },
    value: local!pagingInfo,
    saveInto: local!pagingInfo
    )
    }
    )
    )
    )


    When I run this I see the following error -
    09:27:01,710 INFO [stdout] (ajp-/0.0.0.0:8009-19) 2017-02-20 09:27:01,704 [ajp-/0.0.0.0:8009-19] ERROR com.appi...
  • ...an.integration.sharepoint.function.SharePointInvoke - ConnectorRuntimeException [title=Error calling shpInvoke, com.appian.integration.core.exception.ConnectorRuntimeException: The external server for this system [key=sharepoint] generated an exception when calling a function [shpInvoke]. Details from external system: java.lang.IllegalArgumentException: org.codehaus.jackson.JsonParseException: Unexpected character ('?' (code 65279 / 0xfeff)): expected a valid value (number, String, array, object, 'true', 'false' or 'null')
    09:27:01,710 INFO [stdout] (ajp-/0.0.0.0:8009-19) at [Source: java.io.StringReader@3cf10c61; line: 1, column: 2]]
    09:27:01,710 INFO [stdout] (ajp-/0.0.0.0:8009-19) ConnectorRuntimeException [title=Error calling shpInvoke, com.appian.integration.core.exception.ConnectorRuntimeException: The external server for this system [key=sharepoint] generated an exception when calling a function [shpInvoke]. Details from external system: java.lang.IllegalA...
  • ... rgumentException: org.codehaus.jackson.JsonParseException: Unexpected character ('?' (code 65279 / 0xfeff)): expected a valid value (number, String, array, object, 'true', 'false' or 'null')
    09:27:01,710 INFO [stdout] (ajp-/0.0.0.0:8009-19) at [Source: java.io.StringReader@3cf10c61; line: 1, column: 2]]
    09:27:01,710 INFO [stdout] (ajp-/0.0.0.0:8009-19)           at com.appian.integration.sharepoint.function.SharePointInvoke.sharepointinvoke_appian_internal(SharePointInvoke.java:69)
    09:27:01,710 INFO [stdout] (ajp-/0.0.0.0:8009-19)           at sun.reflect.GeneratedMethodAccessor14755.invoke(Unknown Source)
    Please find enclosed error details.

    Can you please help me understand the cause of this issue ?

  • path: "/_api/Web/getfolderbyserverrelativeurl('Shared%20Documents')/Files?$select=Name,ServerRelativeUrl,TimeCreated",
    httpMethod: "GET"
    ).result.d.results,
    local!sharepointFilesDataSubset: todatasubset(local!sharepointQueryResult, local!pagingInfo),
    a!dashboardLayout(
    firstColumnContents: {
    a!gridField(
    label: "Files in Sharepoint",
    totalCount: local!sharepointFilesDataSubset.totalCount,
    columns: {
    a!gridTextColumn(
    label: "Name",
    field: "Name",
    data: local!sharepointFilesDataSubset.data.Name
    ),
    a!gridTextColumn(
    label: "Time Created",
    field: "TimeCreated",
    data: local!sharepointFilesDataSubset.data.TimeCreated
    )
    },
    value: local!pagingInfo,
    saveInto: local!pagingInfo
    )
    }
    )
    )
    )
  • Rupak,
    Did you get a solution for this issue?
    I am facing the same issue while trying to integrate with Sharepoint
  • 0
    A Score Level 1
    in reply to rupakj
    Yes, we were facing. Citrix receiver connection issue. We raised Appian support case and the issue got resolved.