SQL Server

Multimodal Input: File URL

See more AI Examples

Demonstrates sending a request that includes both text and a PDF file URL for the AI to analyze.

Note: At the time of writing this example, xAI, Perplexity, and DeepSeek do not have the ability to accept non-image multimodal data or URLs.

SQL Server

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    -- Important: Do not use nvarchar(max).  See the warning about using nvarchar(max).
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

    -- This example assumes the Chilkat API to have been previously unlocked.
    -- See Global Unlock Sample for sample code.

    DECLARE @ai int
    EXEC @hr = sp_OACreate 'Chilkat.Ai', @ai OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    -- The provider can be "openai", "google", or "claude".
    -- At the time of writing this example, "deepseek", "xai", and "perplexity" do not have the ability to process non-image multimodal inputs.
    -- Support for additional providers will be added in future versions of Chilkat.
    EXEC sp_OASetProperty @ai, 'Provider', 'openai'

    -- Use your provider's API key.
    EXEC sp_OASetProperty @ai, 'ApiKey', 'MY_API_KEY'

    -- Choose a model.
    EXEC sp_OASetProperty @ai, 'Model', 'gpt-4o'

    -- Add both text input, and PDF file URL.
    -- If the AI provider does not natively support file URLs, Chilkat will download the file data to memory and send the file data to the AI provider (within the "Ask" method call).
    EXEC sp_OAMethod @ai, 'InputAddText', @success OUT, 'What is in this file?'
    EXEC sp_OAMethod @ai, 'InputAddFileUrl', @success OUT, 'https://www.chilkatsoft.com/exampledata/shakespeare.pdf', ''

    -- Ask the AI for text output.
    EXEC sp_OAMethod @ai, 'Ask', @success OUT, 'text'
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @ai, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @ai
        RETURN
      END

    -- Get the text response.
    DECLARE @sbResponse int
    EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbResponse OUT

    EXEC sp_OAMethod @ai, 'GetOutputTextSb', @success OUT, @sbResponse
    EXEC sp_OAMethod @sbResponse, 'GetAsString', @sTmp0 OUT
    PRINT @sTmp0

    -- -------------------------------------------------------------
    -- The response is in markdown format.
    -- Also see Markdown to HTML Conversion Examples.
    -- -------------------------------------------------------------

    -- Sample output:

    -- The file contains a quote from William Shakespeare's "Romeo and Juliet" and an image of Shakespeare. The quote is from Act 2, Scene 6:
    -- 
    -- “These violent delights have violent ends
    -- And in their triumph die, like fire and powder,
    -- Which as they kiss consume. The sweetest honey
    -- Is loathsome in his own deliciousness
    -- And in the taste confounds the appetite.
    -- Therefore love moderately; long love doth so;
    -- Too swift arrives as tardy as too slow.”

    EXEC @hr = sp_OADestroy @ai
    EXEC @hr = sp_OADestroy @sbResponse


END
GO