(SQL Server) Egypt ITIDA Generate eReceipt UUID

See more Egypt ITIDA Examples

Demonstrates how to generate the eReceipt UUID for Egypt ITIDA.

Note: This example requires Chilkat v9.5.0.92 or greater.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    -- This example assumes the Chilkat API to have been previously unlocked.
    -- See Global Unlock Sample for sample code.

    -- Note: This example requires Chilkat v9.5.0.92 or greater.
    -- (In v9.5.0.92, the "itida" encoding was added to StringBuilder's Encode method.)
    DECLARE @sb int
    -- Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sb OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    -- Load the eReceipt JSON into a StringBuilder object.
    DECLARE @success int
    EXEC sp_OAMethod @sb, 'LoadFile', @success OUT, 'qa_data/itida/EReceipt_ex.json', 'utf-8'
    IF @success = 0
      BEGIN

        PRINT 'Failed to load input file.'
        EXEC @hr = sp_OADestroy @sb
        RETURN
      END

    -- Convert the contents of sb to the ITIDA canonical form.
    -- Always pass utf-8 for the 2nd arg.
    EXEC sp_OAMethod @sb, 'Encode', @success OUT, 'itida', 'utf-8'

    -- Get the lowercase hex encoded SHA256 hash of the canonicalized JSON
    -- (always use utf-8)
    DECLARE @uuid nvarchar(4000)
    EXEC sp_OAMethod @sb, 'GetHash', @uuid OUT, 'sha256', 'hex_lower', 'utf-8'

    PRINT 'eInvoicing UUID = ' + @uuid

    EXEC @hr = sp_OADestroy @sb


END
GO