SQL Query
Try for free
No credit card required
View all Actors
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/docsDeveloper
Useful toolsMaintained by Community
Actor metrics
- 1 monthly user
- 3 stars
- 100.0% runs succeeded
- Created in Nov 2023
- Modified 9 months ago
Categories
