Can't use vault inside trigger locally

Object { code: "22000", details: null, hint: null, message: "pgsodium_crypto_aead_det_decrypt_by_id: invalid ciphertext" }

CREATE OR REPLACE FUNCTION public.get_api_url()
 RETURNS text
 LANGUAGE plpgsql
 SECURITY DEFINER
 SET search_path TO 'public', 'vault', 'pg_temp'
AS $function$
DECLARE
    api_url TEXT;
BEGIN
    SELECT decrypted_secret
    INTO api_url
    FROM vault.decrypted_secrets
    WHERE name = 'api_url'
    LIMIT 1;

    RETURN api_url;
END;
$function$
;