Guide

Retrieve exact rows

Run read-only SQL against a known source and table when you need exact rows instead of interpretation.

Workflow

1Provide the source ID and SQL
2Use the returned rows

Complete example

typescript

import { PermuteClient } from '@permute/sdk';

const orgClient = new PermuteClient({
  apiKey: process.env.PERMUTE_API_KEY!,
});
const client = orgClient.withWorkspace(process.env.PERMUTE_WORKSPACE_ID!);

const result = await client.query({
  sourceIds: ['data_quickbooks123'],
  sql: 'SELECT * FROM orders LIMIT 100',
});

console.table(result.rows);