Message Integration Hub 🌐

\n \n

Receive Token 🔑

{receiveToken}

Use this token to send messages to this endpoint:

\n            POST {window.location.origin}/receive\n            Header: Authorization: Bearer {receiveToken}\n            Body: {\"source\": \"app_name\", \"content\": \"message content\"}\n

\n\n

Message Threads 📬

\n {messages.map(msg => (\n

\n {msg.source}: {msg.content.substring(0, 50)}...\n

\n ))}\n

\n\n

Send to AI Agent 🤖

\n setNewMessage({...newMessage, destination: e.target.value})}\n style={{ width: '100%', marginBottom: '10px' }}\n >\n \n {destinations\n .filter(dest => dest.type === 'ai-agent')\n .map(dest => (\n \n ))\n }\n \n \n setNewMessage({...newMessage, content: e.target.value})}\n style={{ width: '100%', minHeight: '100px' }}\n />\n \n \n

\n \n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const { OpenAI } = await import(\"https://esm.town/v/std/openai\");\n \n const KEY = \"messageReceiverApp\";\n const SCHEMA_VERSION = 8;\n\n // Receive Tokens Table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_receive_tokens_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n token TEXT UNIQUE NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n last_used DATETIME\n )\n `);\n\n // Destinations Table (with AI agent type)\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_destinations_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n type TEXT NOT NULL,\n endpoint TEXT,\n config TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Messages Table with enhanced tracking\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_messages_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n source TEXT NOT NULL,\n content TEXT NOT NULL,\n destination_id INTEGER,\n ai_processed BOOLEAN DEFAULT 0,\n ai_response TEXT,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Generate Receive Token Endpoint\n if (request.method === 'GET' && new URL(request.url).pathname === '/generate-receive-token') {\n const newToken = crypto.randomUUID();\n \n await sqlite.execute(`\n INSERT INTO ${KEY}_receive_tokens_${SCHEMA_VERSION} \n (token) VALUES (?)\n `, [newToken]);\n \n return new Response(JSON.stringify({ token: newToken }), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n // Receive Message Endpoint\n if (request.method === 'POST' && new URL(request.url).pathname === '/receive') {\n const authHeader = request.headers.get('Authorization');\n if (!authHeader || !authHeader.startsWith('Bearer ')) {\n return new Response('Unauthorized', { status: 401 });\n }\n\n const providedToken = authHeader.split(' ')[1];\n \n // Validate receive token\n const tokenValidation = await sqlite.execute(`\n SELECT id FROM ${KEY}_receive_tokens_${SCHEMA_VERSION} \n WHERE token = ?\n `, [providedToken]);\n\n if (tokenValidation.rows.length === 0) {\n return new Response('Invalid Token', { status: 403 });\n }\n\n // Parse incoming message\n const { source, content } = await request.json();\n \n // Store received message\n const insertResult = await sqlite.execute(`\n INSERT INTO ${KEY}_messages_${SCHEMA_VERSION} \n (source, content) VALUES (?, ?)\n `, [source, content]);\n\n // Find AI destinations\n const aiDestinations = await sqlite.execute(`\n SELECT * FROM ${KEY}_destinations_${SCHEMA_VERSION} \n WHERE type = 'ai-agent'\n `);\n\n // Process with AI if destinations exist\n if (aiDestinations.rows.length > 0) {\n const openai = new OpenAI();\n \n for (const destination of aiDestinations.rows) {\n try {\n const aiResponse = await openai.chat.completions.create({\n messages: [{ \n role: \"user\", \n content: `Process this message from ${source}: ${content}` \n }],\n model: \"gpt-4o-mini\"\n });\n\n // Update message with AI processing\n await sqlite.execute(`\n UPDATE ${KEY}_messages_${SCHEMA_VERSION} \n SET ai_processed = 1, \n ai_response = ? \n WHERE id = ?\n `, [\n aiResponse.choices[0].message.content, \n insertResult.lastInsertRowid\n ]);\n } catch (error) {\n console.error('AI Processing Error:', error);\n }\n }\n }\n\n // Update token's last used timestamp\n await sqlite.execute(`\n UPDATE ${KEY}_receive_tokens_${SCHEMA_VERSION} \n SET last_used = CURRENT_TIMESTAMP \n WHERE token = ?\n `, [providedToken]);\n\n return new Response(JSON.stringify({ \n success: true,\n messageId: insertResult.lastInsertRowid \n }), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n // Destinations Endpoint\n if (request.method === 'GET' && new URL(request.url).pathname === '/destinations') {\n const destinations = await sqlite.execute(`\n SELECT * FROM ${KEY}_destinations_${SCHEMA_VERSION}\n `);\n return new Response(JSON.stringify(destinations.rows), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n // Add Destination Endpoint\n if (request.method === 'POST' && new URL(request.url).pathname === '/destinations') {\n const { name, type, endpoint, config } = await request.json();\n await sqlite.execute(`\n INSERT INTO ${KEY}_destinations_${SCHEMA_VERSION} \n (name, type, endpoint, config) VALUES (?, ?, ?, ?)\n `, [name, type, endpoint, JSON.stringify(config || {})]);\n return new Response(JSON.stringify({ success: true }), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n // Messages Retrieval Endpoint\n if (request.method === 'GET' && new URL(request.url).pathname === '/messages') {\n const messages = await sqlite.execute(`\n SELECT * FROM ${KEY}_messages_${SCHEMA_VERSION} \n ORDER BY timestamp DESC\n `);\n\n return new Response(JSON.stringify(messages.rows), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n return new Response(`\n \n \n Message Integration Hub\n \n \n \n

\n \n \n \n \n `, {\n headers: { 'Content-Type': 'text/html' }\n });\n}\n\nconst css = `\nbody { \n font-family: system-ui; \n margin: 0;\n padding: 0;\n line-height: 1.6;\n}\npre, code {\n background-color: #f4f4f4;\n padding: 10px;\n border-radius: 5px;\n display: block;\n white-space: pre-wrap;\n word-wrap: break-word;\n}\n`;","deleted","subdomain",[102],"permalink","https://www.val.town/x/bgtgtgfgvbtgvgb/messageReceiverApp/code/main.tsx","extension","routes/embed","actionData","errors"]