Json To Excel

1from apify_client import ApifyClient
2
3# Initialize the ApifyClient with your Apify API token
4# Replace '<YOUR_API_TOKEN>' with your token.
5client = ApifyClient("<YOUR_API_TOKEN>")
6
7# Prepare the Actor input
8run_input = { "JSON": """[
9    {
10    \"title\": \"Apify: Full-stack web scraping and data extraction platform\",
11    \"url\": \"https://apify.com/\",
12    \"displayedUrl\": \"https://apify.com\",
13    \"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 ...\",
14    \"emphasizedKeywords\": [],
15    \"productInfo\": {},
16    \"type\": \"organic\",
17    \"position\": 1
18    },
19    {
20    \"title\": \"Apify (@apify) · X\",
21    \"url\": \"https://twitter.com/apify?ref_src=twsrc%5Egoogle%7Ctwcamp%5Eserp%7Ctwgr%5Eauthor\",
22    \"displayedUrl\": \"https://twitter.com/apify\",
23    \"description\": \"\",
24    \"emphasizedKeywords\": [],
25    \"siteLinks\": [],
26    \"productInfo\": {},
27    \"type\": \"organic\",
28    \"position\": 2
29    },
30    {
31    \"title\": \"Apify\",
32    \"url\": \"https://github.com/apify\",
33    \"displayedUrl\": \"https://github.com › apify\",
34    \"description\": \"Generic REST API for scraping websites. Drop-in replacement for ScrapingBee, ScrapingAnt, and ScraperAPI services. And it is open-source!\",
35    \"emphasizedKeywords\": [],
36    \"siteLinks\": [],
37    \"productInfo\": {},
38    \"type\": \"organic\",
39    \"position\": 3
40    },
41    {
42    \"title\": \"Apify Pricing, Alternatives & More 2024\",
43    \"url\": \"https://www.capterra.com/p/150854/Apify/\",
44    \"displayedUrl\": \"https://www.capterra.com › Data Extraction Software\",
45    \"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 ...\",
46    \"emphasizedKeywords\": [
47    \"Apify\"
48    ],
49    \"siteLinks\": [],
50    \"productInfo\": {
51    \"rating\": 4.8,
52    \"numberOfReviews\": 150
53    },
54    \"type\": \"organic\",
55    \"position\": 4
56    },
57    {
58    \"title\": \"Apify\",
59    \"url\": \"https://cz.linkedin.com/company/apifytech\",
60    \"displayedUrl\": \"6.6K+ followers\",
61    \"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.\",
62    \"emphasizedKeywords\": [
63    \"Apify\"
64    ],
65    \"siteLinks\": [],
66    \"productInfo\": {},
67    \"type\": \"organic\",
68    \"position\": 5
69    },
70    {
71    \"title\": \"Apify Reviews 2024: Details, Pricing, & Features\",
72    \"url\": \"https://www.g2.com/products/apify/reviews\",
73    \"displayedUrl\": \"https://www.g2.com › ... › Apify › Apify Reviews\",
74    \"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 ...\",
75    \"emphasizedKeywords\": [
76    \"Apify\"
77    ],
78    \"siteLinks\": [],
79    \"productInfo\": {
80    \"rating\": 4.8,
81    \"numberOfReviews\": 112
82    },
83    \"type\": \"organic\",
84    \"position\": 6
85    },
86    {
87    \"title\": \"Apify Tutorial For Beginners | How To Use Apify\",
88    \"url\": \"https://www.youtube.com/watch?v=3rrpfW0bEdc\",
89    \"displayedUrl\": \"4.9K+ views  ·  9 months ago\",
90    \"description\": \"Apify review: https://speakaboutdigital.com/apify-review/ Apify Tutorial For Beginners | How To Use Apify This is my video tutorial on Apify ...\",
91    \"emphasizedKeywords\": [
92    \"Apify\"
93    ],
94    \"siteLinks\": [],
95    \"productInfo\": {},
96    \"type\": \"organic\",
97    \"position\": 7
98    }]""" }
99
100# Run the Actor and wait for it to finish
101run = client.actor("zuzka/json-to-excel").call(run_input=run_input)
102
103# Fetch and print Actor results from the run's dataset (if there are any)
104print("💾 Check your data here: https://console.apify.com/storage/datasets/" + run["defaultDatasetId"])
105for item in client.dataset(run["defaultDatasetId"]).iterate_items():
106    print(item)
107
108# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start