Loading
About Salesforce Data 360
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Query Unstructured Data Using Query API

            You are here:

            1. Salesforce Help
            2. Docs
            3. Data 360

            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).
             
            Loading
            Salesforce Help | Article