SQL Query avatar
SQL Query
Try for free

No credit card required

View all Actors
SQL Query

SQL Query

useful-tools/sql-query
Try for free

No credit card required

Run SQL queries over Apify Platform (currently supports only Datasets).

The code examples below show how to run the Actor and get its results. To run the code, you need to have an Apify account. Replace <YOUR_API_TOKEN> in the code with your API token, which you can find under Settings > Integrations in Apify Console. Learn more

1import { ApifyClient } from 'apify-client';
2
3// Initialize the ApifyClient with your Apify API token
4const client = new ApifyClient({
5    token: '<YOUR_API_TOKEN>',
6});
7
8// Prepare Actor input
9const input = {
10    "query": "SELECT 'test data' as `test column`"
11};
12
13(async () => {
14    // Run the Actor and wait for it to finish
15    const run = await client.actor("useful-tools/sql-query").call(input);
16
17    // Fetch and print Actor results from the run's dataset (if any)
18    console.log('Results from dataset');
19    console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`);
20    const { items } = await client.dataset(run.defaultDatasetId).listItems();
21    items.forEach((item) => {
22        console.dir(item);
23    });
24})();
25
26// 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs
Developer
Maintained by Community
Actor metrics
  • 1 monthly user
  • 3 stars
  • 100.0% runs succeeded
  • Created in Nov 2023
  • Modified 8 months ago
Categories