We have had workflows with connections to a SharePoint List running for year's on our Prod Server because we have used SharePoint 2010 and we can utilize our Batch ID and password to gain access to the list.
We are moving to SharePoint Online and the SharePoint Input Tool's configuration asks for an email address... My BatchID doesnt have an email address, so I am at a loss for what to do.
Anyone know how to gain access to a list like this with a BatchID in use?
12. In next dialog, Click on trust it as shown in the screenshot.
13. Now with generated Client Id and Client secret , one can connect to SharePoint Online through app only authentication.
These are what you have to use to be able to pull from a Sharepoint365 list. Make sure that you are pulling the correct View - there are often several ones that have been created by users of the site !!
I did the process listed above to obtain my SharePoint credentials, but when I tried to use them with a SharePoint List Input tool, I got the following error: "Error encountered: Token request failed." The error popped up after I pasted the URL, Client ID, and Secret Key. I wasn't able to enter List or View after the error appeared. Both drop downs were empty. Can anyone help me with this?
You have been granted SCA (Site Collection Admin) rights by the tenant IT admin team? That, and you are also utilizing "App Only Authentication (Online/Office 365, 2016)" for the tool? You know that the Oauth creds you are attempting to submit are not valid if no List/Views populate after entering those datapoints.
I'd suggest searching your Outlook contacts for "O365" or other such PDL's if you're in a corp environment and you're not aware of the IT teams that are responsible for your SharePoint online tenant ("yourcorpsname.sharepoint.com/sites/your_tenant_site_where_your_lists_are/one_of_your_list_names"). Most corps are setup so that SCA rights would be granted to what your particular sub-tenant address is (yourcorpsname.sharepoint.com/sites/your_tenant_site_where_your_lists_are/) this would be what they'd grant for since it would be very unusual/unwise to grant a user access to the whole tenant -- you'd be able to obtain data from any other part of the company if that was the case. There is also quite a bit that can be gleaned from using powershell office 365 commandlets, and there's quite a bit on MS and other sites that can serve as demo's for how to install the needed cmdlets and drivers to obtain info in that regard. Something like this can be a primer, but there is a ton of info out there to do this --https://www.virtualgyanis.com/post/office365-how-to-connect-office365-tenant-via-powershell You have to remember that the backend Azure where SP365 data is stored is just a database, these functions are the equivalent to obtaining dbase access:
1) Owner on a sub-tenant (NOT Admin, you have to be elevated to an Owner status) = Being placed into an identity mananger "group"
2) SCA rights = being granted the permissions to obtain OAuth credentials from the Azure db
3) your sub-tenant = the particular schema of the db holding data pertinent to your Lists/View you're trying to access
4) OAuth creds = they act just like your active directory creds if you were given access to a SQL db that used AD for authentication
Once you find the IT teams that are your admins, they'll likely know, or know how to find out from the MS team supporting your O365 instance.