Property Group - Search
Search for a Dropbox Property Group using SQL Server
- See SQLHTTP easy setup for Dropbox
- See API Call documentation for parameter values and other information
- Create the stored procedure documented below
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 |
CREATE PROCEDURE usp_DropBox_v2_Property_Group_Search( @Profile nvarchar(100), @Body varchar(MAX), @Cursor nvarchar(MAX) = NULL, @Response nvarchar(MAX) OUTPUT, @StatusCode int OUTPUT, @StatusDescription nvarchar(MAX) OUTPUT) AS DECLARE @URL nvarchar(MAX) DECLARE @HTTPSessionID uniqueidentifier SET @URL = 'https://api.dropbox.com/2' IF @Cursor IS NULL BEGIN EXEC SQLHTTP.net.UrlBuilder @URL OUTPUT, @Profile, 'file_properties', 'properties', 'search' END ELSE BEGIN EXEC SQLHTTP.net.UrlBuilder @URL OUTPUT, @Profile, 'file_properties', 'properties', 'search', 'continue' SET @Body = '{ "cursor": "' + @Cursor + '" }' END EXEC SQLHTTP.net.HTTPSession @HTTPSessionID OUTPUT EXEC usp_Dropbox_v2_Auth_Header @Profile, @HTTPSessionID EXEC SQLHTTP.net.HTTPRequest @HttpSessionID, @URL = @URL, @Method = 'POST', @Body = @Body, @ContentType = 'application/json', @StatusCode = @StatusCode OUTPUT, @StatusDescription = @StatusDescription OUTPUT, @Response = @Response OUTPUT GO |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 |
DECLARE @Response nvarchar(MAX) DECLARE @StatusCode int DECLARE @StatusDescription nvarchar(MAX) DECLARE @Body varchar(MAX) SET @Body = '{ "queries": [ { "query": "Confidential", "mode": { ".tag": "field_name", "field_name": "Security Policy" }, "logical_operator": "or_operator" } ], "template_filter": "filter_none" }' EXEC usp_DropBox_v2_Property_Group_Search @Profile = 'My Dropbox', @Body = @Body, @Cursor = NULL, @Response= @Response OUTPUT, @StatusCode = @StatusCode OUTPUT, @StatusDescription = @StatusDescription OUTPUT IF @StatusCode >= 400 EXEC SQLHTTP.net.RaiseHttpError @StatusCode, @StatusDescription, @Response ELSE BEGIN DECLARE @X xml SET @X = SQLHTTP.net.Json_To_Xml(@Response, '0') --The XPath syntax below was easily generated by executing the following commands: --EXEC SQLHTTP.net.XQueryHelper @X --and then executing: --EXEC SQLHTTP.net.XQueryHelper @X, 'JsonObject/matches[1]/JsonObject' --EXEC SQLHTTP.net.XQueryHelper @X, 'JsonObject' -- cursor SELECT T.C.value(N'@id', N'nvarchar(MAX)') AS [id] ,T.C.value(N'@path', N'nvarchar(MAX)') AS [path] ,T.C.value(N'property_groups[1]/JsonObject[1]/@template_id', N'nvarchar(MAX)') AS [template_id] FROM @X.nodes(N'/JsonObject/matches[1]/JsonObject') T(C) --Set @Cursor parameter to the below value of @cursor --and continue calling the above stored procedure to load additional search results DECLARE @cursor nvarchar(MAX) SELECT @cursor = T.C.value(N'@cursor', N'nvarchar(MAX)') FROM @X.nodes(N'/JsonObject') T(C) END |
|
1 2 3 4 5 |
id path template_id --------------------------- ---------------- ------------------------------- id:CAI9Uyyv3xAAAAAAAAAADA /SampleFile.doc ptid:X-uB6WBkIxAAAAAAAAAAIw |
- Copy Reference – Fetch
- Copy Reference – Save
- File – Unshare
- File / Folder – Copy
- File / Folder – Delete
- File / Folder – Move
- File / Folder – Restore
- File / Folder – Search
- File / Folder Metadata – Fetch
- File Member – Add
- File Member – Delete
- File Members – Fetch
- File Members Batch – Fetch
- File Membership – Relinquish
- File Request – Create
- File Request – Fetch
- File Request – Update
- File Revisions – Fetch
- File URL – Save
- Files – Fetch
- Files / Folders – Batch Copy Status
- Files / Folders – Batch Delete
- Files / Folders – Batch Delete Status
- Files / Folders – Batch Copy
- Files / Folders – Batch Move
- Files / Folders – Batch Move Status
- Folder – Create
- Folder – Share
- Folder – Transfer
- Folder – Unshare
- Folder Member – Add
- Folder Member – Delete
- Folder Members – Fetch
- Job Status – Check
- Mountable Folders – Fetch
- Property Group – Create
- Property Group – Delete
- Property Group – Overwrite
- Property Group – Search
- Property Group – Update
- Received Files – Fetch
- Remove Member Job Status – Check
- Save URL – Check Job Status
- Shared File Metadata – Fetch
- Shared Files Metadata – Fetch
- Shared Folder – Mount
- Shared Folder – Unmount
- Shared Folder Metadata – Fetch
- Shared Folders – Fetch
- Shared Link – Create
- Shared Link – Revoke
- Shared Link – Update
- Shared Link Metadata – Fetch
- Shared Links – Fetch
- Template – Create
- Template – Fetch
- Template – Update
- Template – Delete
- Temporary Link – Fetch
IMPORTANT DISCLAIMER
CODE/SQL ON THESE PAGES ARE PROVIDED AS-IS AND ARE AVAILABLE FOR ILLUSTRATIVE PURPOSES ONLY.
USERS ARE REQUIRED TO ABIDE BY THE TERMS AND CONDITIONS FOR USING REFERENCED THIRD PARTY WEBSITES AND/OR APIs FROM THEIR RESPECTIVE WEBSITES. WE DO NOT CONDONE ANY VIOLATION OF THIRD PARTY WEBSITES AND/OR APIs TERMS AND CONDITIONS USING OUR SOFTWARE.
USERS SHALL BE SOLELY RESPONSIBLE AND BE SOLELY LIABLE FOR VIOLATION OF ANY RULES SPECIFIED BY THIRD PARTIES FOR USING THEIR WEBSITES AND/OR APIs, OR INFRINGEMENT OF RIGHTS OF SUCH THIRD PARTIES.