Issue Connecting to the SharePoint List Input

Hello. Trying to connect to our company's SP site through the SharePoint List Input tool. We can't seem to figure out what the proper Domain\Username combination is.

First Criteria is URL: Should this inlcude the %20 in place of spaces, or the spaces themselves?

Second Criteria is Username: Says should be Domain\Username. I've seen elsewhere the Domain may be included in the URL? I can't seem to get any combination of what the Domain might be to work. I'm pretty new with these kind of connections, though, so I'm sure I'm way off on something.

Third Criteria is Password: This can only be one thing, so I know this is good.

My company does use a "Single Signon". I'm not sure if something like that would interfere. I have other SP sites mapped to network drives with no problem. I log into those each day through a Novell Login.

Not sure what info you guys will need to help solve this, and I don't want to share too much private information here, so please let me know what you need, and a private conversation with generic answers posted here may be the way to go.

Thank you,

Input

Sharepoint

Accepted answers

HannahSinclair

Hi,

To go by the criteria:

1. It does not actually matter if the spaces are acutal spaces or %20. If you leave them as actual spaces, we simply encode them to %20 when the actual call to SharePoint is made.

2. The Username must actually include the domain, so needs to be in the Domain\Username format.

The Single Sign-On should not be causing an issue, especially if you specify the domain with the username. Could you send the general error you are receiving?

You also may want to check that the URL you are pointing to is for a SharePoint site and not, for example, a Document Repository within a site. Depending on what version of SharePoint you are using it may move, but there should be a link to somehwere on the page to show "Site Contents" which is a good place to see which site you are in. Or if you even have access to Site Settings, that should display that actual site URL.

Let me know if this helps or if you have further questions and would like to start a private thread.

Hannah Keller

Software Engineer

Alteryx, Inc.

All comments

HannahSinclair

Hi,

To go by the criteria:

1. It does not actually matter if the spaces are acutal spaces or %20. If you leave them as actual spaces, we simply encode them to %20 when the actual call to SharePoint is made.

2. The Username must actually include the domain, so needs to be in the Domain\Username format.

The Single Sign-On should not be causing an issue, especially if you specify the domain with the username. Could you send the general error you are receiving?

Let me know if this helps or if you have further questions and would like to start a private thread.

Hannah Keller

Software Engineer

Alteryx, Inc.

FFFool

Hi Hanna. Thanks for the post.

Interesting note about the URL not being a Document Repository, hadn't thought about that, but given the amount of different links I tried, I'm sure one of them was only the site.

The error I'm getting just says to "Please enter a valid connection".

I'm 90% sure it is because i don't have the correct Domain/Username combination, but I don't know how to find out what the correct Domain/Username combination is. There are only 2 options for my Username, so that isn't really a problem, but I have no idea about the Domain.

Thanks again!

FFFool

Hannah,

Just figured it out. It was the URL. The Domain/Username I had worked and loaded the list, so now I'm on my way, hopefully.

Thanks!

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335