Pixtaha

// Send message with inline keyboard via Telegram Bot API
const response = await fetch(
  `https://api.telegram.org/bot${botToken}/sendMessage`,
  {
    method: "POST",
    headers: { "Content-Type": "application/json" },
    body: JSON.stringify({
      chat_id: chatId,
      text: "Choose an option:",
      reply_markup: {
        inline_keyboard: [
          [{ text: "Option 1", callback_data: "opt1" }],
          [{ text: "Option 2", callback_data: "opt2" }],
        ],
      },
    }),
  }
);

-- Upsert: Insert or update on conflict
INSERT INTO users (telegram_id, username, last_seen)
VALUES ($1, $2, NOW())
ON CONFLICT (telegram_id)
DO UPDATE SET
  username = EXCLUDED.username,
  last_seen = NOW()
RETURNING *;

// N8n Code Node: Fetch all pages from API
let allItems = [];
let page = 1;
let hasMore = true;

while (hasMore) {
  const response = await this.helpers
    .httpRequest({
      url: `https://api.example.com/data?page=${page}`,
      method: "GET",
    });
  allItems.push(...response.data);
  hasMore = response.hasNextPage;
  page++;
}

return allItems.map(item => ({ json: item }));