OneDrive - Search

In this article

Overview

You can use the OneDrive - Search Snap to search for driveItems by keywords. You can specify the information (fields) you want to view for the search results. You can perform the search operation within your OneDrive as well as your Shared Libraries (document libraries).

Prerequisites

  • A valid application in Azure Portal with appropriate permissions.
  • A valid Microsoft OneDrive license.
  • Read access to the folder/file mentioned in the Source Relative Path/ID.

Support for Ultra Pipelines

Works in Ultra Pipelines.

Limitations

None.

Known Issues

Snaps in the Microsoft OneDrive Snap Pack have an in-built retry mechanism for failing connections and requests; but, a high volume of requests from a client might reach the throttling threshold. In such scenarios, the Microsoft Graph limits further requests from that client for a period of time and returns an HTTP status code 429 (Too many requests), thereby causing the requests to fail. Hence, we recommend you to keep a check on the number of requests emanating from your client instance.

Snap Input and Output

Input/OutputType of ViewNumber of ViewsExamples of Upstream and Downstream SnapsDescription
Input 

Document

  • Min: 0
  • Max: 1
  • Mapper
  • Copy
  • Get Share Permissions
  • Move Item
A document containing the location and keywords to perform the search operation.
Output

Document

  • Min: 1
  • Max: 1
  • Mapper
  • Sort
  • Unique
  • Get Children
  • Share Item

A document containing the search results (with selected fields data) matching the keywords provided.

Snap Settings

Parameter NameData TypeDescriptionDefault ValueExample 
LabelString
Specify a name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your pipeline.
SearchDocFiles_Search
Drive TypeDrop-down list

Required. Select a drive type from the following list of permitted drive types in this drop-down list (to search for driveItems) and specify the corresponding details needed:

  • OneDrive. To search in a OneDrive location. Requires UserDrive, and Source Relative Path/ID.
  • documentLibraryTo search in a shared library (document library) location. Requires Shared LibraryDrive, and Source Relative Path/ID.
  • DriveTo search in a drive (in user's OneDrive or shared library) using the Drive ID. Requires Drive (ID) and Source Relative Path/ID.
  • All. To search in a drive from the list of all drives and shared libraries (including SharePoint sites) that you can access. Requires User, Drive, and Source Relative Path/ID.
OneDrivedocumentLibrary
UserString/Expression/Suggestion

Required for Drive Type options - OneDrive and All. Not needed for Drive and documentLibrary.

Select a user from the suggested list of users to search within that user's OneDrive location.

The list of users displayed varies based on your access to their OneDrive locations. This option is meant for administrator users who are authorized to manage other users' drives, as well.

N/ASnap Team:snap@snaplogic.net
Shared LibraryString/Expression/Suggestion

Required for Drive Type option - documentLibrary. Not needed for OneDrive, Drive, and All.

Select a Shared Library from the suggested list of libraries to search within that library location.

The list of shared libraries displayed varies based on your access to them. This option is meant for users who have write access on both the source and target shared libraries.

N/ANewSharedLibrary
DriveString/Expression/Suggestion

Required for all Drive Type options.

Specify the name of the drive to search in. The suggestions for this field are based on the Snap account and the User or Shared Library selected.

For the Drive Type Drive, specify/pass the ID of the drive to search in, typically from the upstream Snap.

For the drive type All, select a drive from the OneDrive or a Shared Library drive.

Specify the Source Relative Path/ID of the driveItem, next.

N/AOneDrive
Source Relative Path/IDString/Expression

Required for all Drive Type options.

Specify the relative path for the driveItem, beginning with root:/, to perform the search. Alternatively, pass the item ID in this field.

Relative Path and ID

  • Any URL in this field that starts with root:/ is treated as relative path. All other entries (without root:/ at the beginning) are treated as driveItem IDs.
  • When the driveItem ID passed is invalid (not a 34-character alphanumeric code such as 014ZXBQNNHW2DJ3CDKQZBJHRYWFWVRRQA2), the Snap returns the error - The resource is not found.
root://Pictures/Tour1/
SearchString/Expression

RequiredEnter the keywords to use in the search operation.

This Snap does not search in private drive items (of individual users) when you use an Application account. To view private drive items from different users' drives in the search results, use a User account instead.

N/ADoc_Files
Include Shared ItemsCheck box

Select this check box to include all items shared with you, into the scope of the search operation. If not selected, the scope of the search is limited to the items you have in your OneDrive.

Not selectedSelected
Select FieldsString/Expression

Specify the field names that you want to retrieve in each search result for this search operation.

The Snap returns all the available information on each search result, if this field is left blank.

N/Aid, roles
Snap ExecutionDrop-down list

Select one of the three modes in which the Snap executes:

  • Validate & Execute. Performs limited execution of the Snap, generates, and then performs a data preview during Pipeline validation, then performs full execution of the Snap (unlimited records) during Pipeline runtime.
  • Execute only. Performs full execution of the Snap during Pipeline execution without generating preview data.
  • Disabled. Disables the Snap and all the Snaps that are downstream from it.

Validate & ExecuteExecute only


Examples

Using Search Snap to find driveItems in OneDrive

This example Pipeline demonstrates how you can upload a file into OneDrive and then find files with similar name based on keywords using the Search Snap
Prerequisites: Configure your Azure application and the Snap accounts.
 

The Pipeline uses the following parameters. 

We begin with reading a file using the File Reader Snap and uploading it to a particular location in your OneDrive account. Then, we capture the name of the uploaded file using a Mapper Snap and feed it into the Search Snap as the search query/keyword. The Search Snap finds for the keyword in the OneDrive/Shared Library location provided and retrieves item names that contain the search keyword.

File Reader Snap
Output

We upload the document in File Reader Snap output to a OneDrive folder using the Upload File Snap.

Upload File Snap

Output

Upon successful upload, the Snap displays the file's name in the output. We now connect a Mapper Snap to pass the value in this name field to the Search Snap.

In the Search Snap, you can choose to include/exclude items that contain share permissions using the Include Shared Items check box. You can also select the fields to include in the output for each item retrieved in the search results. 

Search Snap

Output

Download this Pipeline

Downloads

Important Steps to Successfully Reuse Pipelines

  1. Download and import the Pipeline into SnapLogic.
  2. Configure Snap accounts as applicable.
  3. Provide Pipeline parameters as applicable.

  File Modified

File Example_OneDrive_Upload_File_Search.slp

Mar 02, 2022 by Subhajit Sengupta


Snap Pack History

 Click here to expand...

Release

Snap Pack Version 

Date

Type

Updates

August 2024438patches28439 Latest

Updated the Kotlin library for Microsoft OneDrive Snap Pack with the okhttp library Platform version to avoid Kotlin library dependency conflict.

August 2024

main27765

 

Stable

Updated and certified against the current SnapLogic Platform release.

May 2024

main26341

 

Stable

Updated and certified against the current SnapLogic Platform release.

February 2024436patches25789 Latest

Fixed a performance issue in the Copy Item Snap, which previously resulted in a nameAlreadyExists error when the Snap retried because of a connection reset.

February 2024

main25112

 

Stable

Updated and certified against the current SnapLogic Platform release.

November 2023main23721 StableUpdated and certified against the current SnapLogic Platform release.
August 2023434patches22736 Latest
  • Fixed an issue with the Mircosoft OneDrive Snap Pack where the Snaps displayed Duplicate key OneDrive error. The Snaps now hide the drive details stored in the PreservationHoldLibrary folder when displaying suggestions. You can use the Drive ID to access the PreservationHoldLibrary folder.

  • Fixed an issue with the Mircosoft OneDrive Snaps that displayed a JsonNull error when the shared library list was empty. Now, it displays the message No Suggestions available.

August 2023main22460 StableUpdated and certified against the current SnapLogic Platform release.

May 2023

main21015 

Stable

Upgraded with the latest SnapLogic Platform release.

February 2023432patches20510 Latest

Fixed the following issues with OneDrive Snaps:

  • The Snaps erroneously displayed the permission error when the actual cause was an empty display name in the API.

  • The Snaps failed with a 403 error when selecting a user (in the User field) from the Suggestions list without the User.Read.All permission. Now you can enter the value manually in the User field and proceed with the specific operation you want to perform in OneDrive, even if the Suggestions list is not available.

February 2023main19844 StableUpgraded with the latest SnapLogic Platform release.
November 2022main18944 StableUpgraded with the latest SnapLogic Platform release.
August 2022main17386 StableUpgraded with the latest SnapLogic Platform release.
4.29main15993 StableUpgraded with the latest SnapLogic Platform release.
4.28main14627 StableUpgraded with the latest SnapLogic Platform release.
4.27main12833 StableUpgraded with the latest SnapLogic Platform release.
4.26main11181 

Stable

Upgraded with the latest SnapLogic Platform release.
4.25 Patch425patches10571
Latest

Updated the error output view of the OneDrive - Upload File Snap from a Binary view to a Document view.

4.25main9554 StableEnhanced the Update Share Permissions Snap with the Share Type and Expires fields that enable you to update the share permissions on your OneDrive items shared using the Invite or Link option. If the Share type is link, you can specify the expiry date and time for the URL that is used to share permissions.
4.24main8556 
StableNo updates made.

4.23

main73

 

Stable

Initial release of the Snap Pack with the following Snaps and Accounts:


See Also