Power BI Connector for Evernote

Build 21.0.7867

Searches

Create, update, delete and query searches from your Evernote account.

Table Specific Information

Select

Select all searches:

SELECT * FROM Searches

Retrieve a specific search:

SELECT * FROM Searches WHERE Guid='c916ef68-60a0-4fa4-8ab1-265debe133dc'

Insert

To create a search, you will need to specify at least the Name and Query column.

INSERT INTO Searches(Name,Query,IncludeAccount) VALUES ('JAVA','object-oriented language',true)

Update

Searches may be modified by providing the GUID of the search and issuing an UPDATE statement.

UPDATE Searches SET Name='C++', Query='Procedural programming language', IncludePersonalLinkedNotebooks=true WHERE Guid='d7b2be4d-a2ca-448b-82a7-ce8723db95a0'

Delete

Searches may be deleted by providing the GUID of the search and issuing a DELETE statement.

DELETE FROM Searches WHERE Guid='d7b2be4d-a2ca-448b-82a7-ce8723db95a0'

Columns

Name Type ReadOnly Description
Guid [KEY] String True

The unique identifier of this search. Will be set by the service, so may be omitted by the client when creating.

Name String False

The name of the saved search to display in the GUI. The account may only contain one search with a given name (case-insensitive compare). Can't begin or end with a space.

Query String False

A string expressing the search to be performed.

Format String True

The format of the query string, to determine how to parse and process it.

UpdateSequenceNum Int True

A number identifying the last transaction to modify the state of this object.

IncludeAccount Bool False

The search should include notes from the account that contains the SavedSearch.

IncludePersonalLinkedNotebooks Bool False

The search should include notes within those shared notebooks that the user has joined that are NOT business notebooks.

IncludeBusinessLinkedNotebooks Bool False

The search should include notes within those shared notebooks that the user has joined that are business notebooks in the business that the user is currently a member of.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7867