Power BI Connector for Evernote

Build 21.0.7867

Resources

Create and query media files that are embedded or attached to notes from your Evernote account. UPDATE and DELETE queries are not supported.

Table Specific Information

Select

Select all resources from every note:

SELECT * FROM Resources

Retrieve a specific resource:

SELECT * FROM Resources WHERE Guid='498996d4-022f-42f7-b607-aae47b6a4636'

Retrieve all resources from a specific note:

SELECT * FROM Resources WHERE NoteGuid='ab26f704-5edf-4a9f-9e4c-8da893a4acd8'

Insert

To create a resource, you will need to specify at least the NoteGuid and ContentBody column. In the ContentBody column you can place the full path of your file or a BASE64 encoded string.

Insert INTO Resources(NoteGuid,ContentBody,Mime) VALUES ('5f02b9da-093a-4e4e-96a9-401596354b52','C:\\\\photo.jpg','image/jpeg')

Columns

Name Type ReadOnly Description
Guid [KEY] String True

The unique identifier of this resource.

NoteGuid String False

The unique identifier of the Note that holds this Resource.

ContentBodyHash String True

This field carries a one-way hash of the contents of the data body, in binary form. The hash function is MD5.

ContentSize Int True

The length, in bytes, of the data body.

ContentBody String False

This field is set to contain the binary contents of the resource.

Mime String False

The MIME type for the embedded resource.

Width Short False

If set, this contains the display width of this resource, in pixels.

Height Short False

If set, this contains the display height of this resource, in pixels.

RecognitionBodyHash String True

This field carries a one-way hash of the contents of the data body that provides information on search and recognition within this resource, in binary form. The hash function is MD5.

RecognitionSize Int True

The length, in bytes, of the data body that provides information on search and recognition within this resource.

RecognitionBody String True

This field is set to contain the binary contents of search and recognition within this resource.

SourceURL String True

The original location where the resource was hosted.

Timestamp Datetime True

The date and time that is associated with this resource (e.g. the time embedded in an image from a digital camera with a clock)

Latitude Double True

The latitude where the resource was captured.

Longitude Double True

The longitude where the resource was captured.

Altitude Double True

The altitude where the resource was captured.

CameraMake String True

Information about an image's camera, e.g. as embedded in the image's EXIF data.

CameraModel String True

information about an image's camera, e.g. as embedded in the image's EXIF data.

ClientWillIndex Bool True

If true, then the original client that submitted the resource plans to submit the recognition index for this resource at a later time.

FileName String True

If the resource came from a source that provided an explicit file name, the original name will be stored here. Many resources come from unnamed sources, so this will not always be set.

Attachment Bool True

This will be true if the resource should be displayed as an attachment, or false if the resource should be displayed inline (if possible).

UpdateSequenceNum Int True

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

AlternateDataBodyHash String True

This field carries a one-way hash of the contents of the alternate data body, in binary form. The hash function is MD5.

AlternateSize Int True

The length, in bytes, of the alternate data body.

AlternateDataBody String True

This field is set to contain the binary contents of the resource in alternate data format.

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