Json To Excel

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    "JSON": `[
11            {
12            "title": "Apify: Full-stack web scraping and data extraction platform",
13            "url": "https://apify.com/",
14            "displayedUrl": "https://apify.com",
15            "description": "Crawls arbitrary websites using the Chrome browser and extracts data from pages using a provided JavaScript code. The actor supports both recursive crawling and ...",
16            "emphasizedKeywords": [],
17            "productInfo": {},
18            "type": "organic",
19            "position": 1
20            },
21            {
22            "title": "Apify (@apify) · X",
23            "url": "https://twitter.com/apify?ref_src=twsrc%5Egoogle%7Ctwcamp%5Eserp%7Ctwgr%5Eauthor",
24            "displayedUrl": "https://twitter.com/apify",
25            "description": "",
26            "emphasizedKeywords": [],
27            "siteLinks": [],
28            "productInfo": {},
29            "type": "organic",
30            "position": 2
31            },
32            {
33            "title": "Apify",
34            "url": "https://github.com/apify",
35            "displayedUrl": "https://github.com › apify",
36            "description": "Generic REST API for scraping websites. Drop-in replacement for ScrapingBee, ScrapingAnt, and ScraperAPI services. And it is open-source!",
37            "emphasizedKeywords": [],
38            "siteLinks": [],
39            "productInfo": {},
40            "type": "organic",
41            "position": 3
42            },
43            {
44            "title": "Apify Pricing, Alternatives & More 2024",
45            "url": "https://www.capterra.com/p/150854/Apify/",
46            "displayedUrl": "https://www.capterra.com › Data Extraction Software",
47            "description": "Apify is used by large enterprises, SMEs, and independent developers. The Apify platform lets you turn any website into an API and reliably extract data at any ...",
48            "emphasizedKeywords": [
49            "Apify"
50            ],
51            "siteLinks": [],
52            "productInfo": {
53            "rating": 4.8,
54            "numberOfReviews": 150
55            },
56            "type": "organic",
57            "position": 4
58            },
59            {
60            "title": "Apify",
61            "url": "https://cz.linkedin.com/company/apifytech",
62            "displayedUrl": "6.6K+ followers",
63            "description": "Apify is a full-stack web scraping and browser automation platform that lets you extract data from websites and automate workflows on the web.",
64            "emphasizedKeywords": [
65            "Apify"
66            ],
67            "siteLinks": [],
68            "productInfo": {},
69            "type": "organic",
70            "position": 5
71            },
72            {
73            "title": "Apify Reviews 2024: Details, Pricing, & Features",
74            "url": "https://www.g2.com/products/apify/reviews",
75            "displayedUrl": "https://www.g2.com › ... › Apify › Apify Reviews",
76            "description": "One of the best features of Apify is their own free scrapers. They provide a variety of ready-made solutions for common web scraping tasks, such as extracting ...",
77            "emphasizedKeywords": [
78            "Apify"
79            ],
80            "siteLinks": [],
81            "productInfo": {
82            "rating": 4.8,
83            "numberOfReviews": 112
84            },
85            "type": "organic",
86            "position": 6
87            },
88            {
89            "title": "Apify Tutorial For Beginners | How To Use Apify",
90            "url": "https://www.youtube.com/watch?v=3rrpfW0bEdc",
91            "displayedUrl": "4.9K+ views  ·  9 months ago",
92            "description": "Apify review: https://speakaboutdigital.com/apify-review/ Apify Tutorial For Beginners | How To Use Apify This is my video tutorial on Apify ...",
93            "emphasizedKeywords": [
94            "Apify"
95            ],
96            "siteLinks": [],
97            "productInfo": {},
98            "type": "organic",
99            "position": 7
100            }]`
101};
102
103(async () => {
104    // Run the Actor and wait for it to finish
105    const run = await client.actor("zuzka/json-to-excel").call(input);
106
107    // Fetch and print Actor results from the run's dataset (if any)
108    console.log('Results from dataset');
109    console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`);
110    const { items } = await client.dataset(run.defaultDatasetId).listItems();
111    items.forEach((item) => {
112        console.dir(item);
113    });
114})();
115
116// 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs