Salesforce Docs Portal

Query Unstructured Data Using Query API

Use Query API to retrieve  a URL to view unstructured data files. Queries return a presigned URL that you can open in your browser.

Required Editions

Available in: All Editions supported by Data 360. See Data 360 edition availability.

Query API supports this special query operator: GET_PRESIGNED_URL: Returns a presigned URL.

Note
Note Presigned URLs are only available for Amazon S3 and Cloud Storage.
Example
Example

Use this syntax to retrieve an object from an external blob store.

SELECT get_presigned_url('<Your Directory_Table UDMO>', udmo.ResolvedFilePath__c, <TTL>) from <Your Directory_Table DMO> as udmo;

Where:

  • <Your Directory_Table UDMO> is a string that represents the name of the Directory Table.
  • <TTL> an integer that specifies the amount of time in seconds the requested object is available. The maximum TTL is 1,800 seconds (30 minutes).