Guide

Retrieve exact rows

Inspect the source, then run read-only SQL against its exact table names when you need rows instead of interpretation.

Workflow

1Inspect the source for table names and provider
2Use the matching SQL dialect
3Use 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);