Sharepoint Connector

Sharepoint Connector

If connecting to Sharepoint using Single Sign-on (SSO)

You might see this error if not connected appropriately - "[500] Could not execute the specified command: unrecognized response when getting SharePoint online security cookies, please check your credentials."

Add "UseSSO=true" to the Starfish Sharepoint Connector configuration.

SSO configuration options:

Use SSO=true Auth Cookie=”” SSO Domain=”” - SSODomain may be required to be set if the domain configured on the SSO domain is different than the domain of the User.

Check SharePoint user configuration as well too:

User name needs to match the format of username@domain.onmicrosoft.com. After logging in to http://yourdomain.sharepoint.com/TeamSite, the "keep me signed in" setting must be checked in order for the connection to be established


Parameter
Description
Url

Edition


SharePoint Connection Edit Screen


    • Related Articles

    • Hubspot Connector

      Hubspot Connector Note: As of September 8, 2020 the Hubspot API does not allow external applications to write into their Quoting module.  See below. Overview The StarfishETL Hubspot Connector enables you to easily connect to Hubspot for integrations ...
    • Excel Connector

      Additional Documentation This Connector is based on the Excel ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/RXG/ado/ Establishing a Connection Connecting to Excel Data ...
    • Act! Connector

      ACT! Premium Cloud: StarfishETL supports two-way integration. ACT! On-Prem: Starfish does not have a native Act! connector for versions less than Act v18 so we read directly from the database. Configuration Options Connect Act Premium (v18+) using ...
    • CSV Connector

      Additional Documentation This Connector is based on the CSV ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/RVG/ado/ CSV Via Upload (in Cloud Designer) When you upload a ...
    • MySQL Connector

      MySQL Origin Note that the connection string must match the sample connection string shown in Starfish: server=<server_name>;uid={0};pwd={1};database=<db_name>; The string components must be placed in that order. {0} is a variable that refers to the ...