Securing SharePoint Integrations with OAuth and the Principle of Least Privilege
Are you granting your SharePoint integrations access to every single site in your tenant? This common practice can create unnecessary security risks. Discover the modern, secure way to connect to SharePoint by granting permissions to specific sites only. Our step-by-step guide shows you how to leverage Microsoft's Resource-Specific Consent (RSC) to lock down your data pipelines and configure your KingswaySoft connection for maximum security and compliance.
Working with SharePoint Taxonomy Fields Effectively Using KingswaySoft
Tagging and organizing content in SharePoint is essential for easy search and retrieval. SharePoint’s Taxonomy fields (also known as Managed Metadata fields) make this possible using a centralized Term Store with predefined hierarchical terms. In this post, we’ll explore how to work with Taxonomy fields and how KingswaySoft simplifies reading and writing to them in your data integration workflows.
Switching to SharePoint OAuth Using KingswaySoft
With the recent news of SOAP basic authentication deprecation, it becomes imperative to start using the OAuth authentication for your SharePoint integration process. In response to this deprecation, we have recently added support for OAuth in the latest (v22.1) of our SharePoint toolkit, which offers a paralleled feature set as the SOAP service endpoint. It also includes some enhanced capabilities that were not possible using the SOAP service endpoint. This blog post will demonstrate the process involved in order to start using the OAuth authentication type in your integration.
Download Document Version History from SharePoint in SSIS
SharePoint Document Library supports version histories, so you can store and track different versions of each document file within the library as changes are made to the file. Such version control infrastructure provides many unique benefits. For instance, if something went wrong with one of the files because of a recent accidental/unintended change, you can easily restore it to a prior version as needed. Also, in your ETL development, you might often run into the requirements that you need to extract all previous versions of a file. In this blog post, we will show how to achieve this using our SharePoint Source component to download document library file versions and using the Premium File System Destination component (offered in SSIS Productivity Pack) to save them to a local file system in SSIS.
Working with SharePoint Online through OData v4 Endpoint
This post will give examples of how to query the SharePoint REST API data with filters and expanded properties, invoke functions using Premium OData Source component.
Manage Dynamics 365 Documents in SharePoint via Server-Based SharePoint Integration
With Dynamics 365 CE, you can leverage server-based SharePoint integration for document management. In this blog post we demonstrate how to work with server-based SharePoint integration to accomplish your document integration job.