Json To Excel avatar

Json To Excel

Try for free

No credit card required

View all Actors
Json To Excel

Json To Excel

zuzka/json-to-excel
Try for free

No credit card required

Convert your json into a tabular form, such as CSV, Excel or HTML table fast and easy.

You can access the Json To Excel programmatically from your own applications by using the Apify API. You can choose the language preference from below. To use the Apify API, you’ll need an Apify account and your API token, found in Integrations settings in Apify Console.

1# Set API token
2API_TOKEN=<YOUR_API_TOKEN>
3
4# Prepare Actor input
5cat > input.json << 'EOF'
6{
7  "JSON": "[\n    {\n    \"title\": \"Apify: Full-stack web scraping and data extraction platform\",\n    \"url\": \"https://apify.com/\",\n    \"displayedUrl\": \"https://apify.com\",\n    \"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 ...\",\n    \"emphasizedKeywords\": [],\n    \"productInfo\": {},\n    \"type\": \"organic\",\n    \"position\": 1\n    },\n    {\n    \"title\": \"Apify (@apify) · X\",\n    \"url\": \"https://twitter.com/apify?ref_src=twsrc%5Egoogle%7Ctwcamp%5Eserp%7Ctwgr%5Eauthor\",\n    \"displayedUrl\": \"https://twitter.com/apify\",\n    \"description\": \"\",\n    \"emphasizedKeywords\": [],\n    \"siteLinks\": [],\n    \"productInfo\": {},\n    \"type\": \"organic\",\n    \"position\": 2\n    },\n    {\n    \"title\": \"Apify\",\n    \"url\": \"https://github.com/apify\",\n    \"displayedUrl\": \"https://github.com › apify\",\n    \"description\": \"Generic REST API for scraping websites. Drop-in replacement for ScrapingBee, ScrapingAnt, and ScraperAPI services. And it is open-source!\",\n    \"emphasizedKeywords\": [],\n    \"siteLinks\": [],\n    \"productInfo\": {},\n    \"type\": \"organic\",\n    \"position\": 3\n    },\n    {\n    \"title\": \"Apify Pricing, Alternatives & More 2024\",\n    \"url\": \"https://www.capterra.com/p/150854/Apify/\",\n    \"displayedUrl\": \"https://www.capterra.com › Data Extraction Software\",\n    \"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 ...\",\n    \"emphasizedKeywords\": [\n    \"Apify\"\n    ],\n    \"siteLinks\": [],\n    \"productInfo\": {\n    \"rating\": 4.8,\n    \"numberOfReviews\": 150\n    },\n    \"type\": \"organic\",\n    \"position\": 4\n    },\n    {\n    \"title\": \"Apify\",\n    \"url\": \"https://cz.linkedin.com/company/apifytech\",\n    \"displayedUrl\": \"6.6K+ followers\",\n    \"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.\",\n    \"emphasizedKeywords\": [\n    \"Apify\"\n    ],\n    \"siteLinks\": [],\n    \"productInfo\": {},\n    \"type\": \"organic\",\n    \"position\": 5\n    },\n    {\n    \"title\": \"Apify Reviews 2024: Details, Pricing, & Features\",\n    \"url\": \"https://www.g2.com/products/apify/reviews\",\n    \"displayedUrl\": \"https://www.g2.com › ... › Apify › Apify Reviews\",\n    \"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 ...\",\n    \"emphasizedKeywords\": [\n    \"Apify\"\n    ],\n    \"siteLinks\": [],\n    \"productInfo\": {\n    \"rating\": 4.8,\n    \"numberOfReviews\": 112\n    },\n    \"type\": \"organic\",\n    \"position\": 6\n    },\n    {\n    \"title\": \"Apify Tutorial For Beginners | How To Use Apify\",\n    \"url\": \"https://www.youtube.com/watch?v=3rrpfW0bEdc\",\n    \"displayedUrl\": \"4.9K+ views  ·  9 months ago\",\n    \"description\": \"Apify review: https://speakaboutdigital.com/apify-review/ Apify Tutorial For Beginners | How To Use Apify This is my video tutorial on Apify ...\",\n    \"emphasizedKeywords\": [\n    \"Apify\"\n    ],\n    \"siteLinks\": [],\n    \"productInfo\": {},\n    \"type\": \"organic\",\n    \"position\": 7\n    }]"
8}
9EOF
10
11# Run the Actor using an HTTP API
12# See the full API reference at https://docs.apify.com/api/v2
13curl "https://api.apify.com/v2/acts/zuzka~json-to-excel/runs?token=$API_TOKEN" \
14  -X POST \
15  -d @input.json \
16  -H 'Content-Type: application/json'

Json To Excel API

Below, you can find a list of relevant HTTP API endpoints for calling the Json To Excel Actor. For this, you’ll need an Apify account. Replace <YOUR_API_TOKEN> in the URLs with your Apify API token, which you can find under Integrations in Apify Console. For details, see the API reference .

Run Actor

POST
https://api.apify.com/v2/acts/zuzka~json-to-excel/runs?token=<YOUR_API_TOKEN>

Note: By adding the method=POST query parameter, this API endpoint can be called using a GET request and thus used in third-party webhooks. Please refer to our Run Actor API documentation .

Run Actor synchronously and get dataset items

POST
https://api.apify.com/v2/acts/zuzka~json-to-excel/run-sync-get-dataset-items?token=<YOUR_API_TOKEN>

Note: This endpoint supports both POST and GET request methods. However, only the POST method allows you to pass input data. For more information, please refer to our Run Actor synchronously and get dataset items API documentation .

Get Actor

GET
https://api.apify.com/v2/acts/zuzka~json-to-excel?token=<YOUR_API_TOKEN>

For more information, please refer to our Get Actor API documentation .

Actors can be used to scrape web pages, extract data, or automate browser tasks. Use the Json To Excel API programmatically via the Apify API.

You can choose from:

You can start Json To Excel with the Apify API by sending an HTTP POST request to the Run Actor endpoint. An Actor’s input and its content type can be passed as a payload of the POST request, and additional options can be specified using URL query parameters. The Json To Excel is identified within the API by its ID, which is the creator’s username and the name of the Actor.

When the Json To Excel run finishes you can list the data from its default dataset (storage) via the API or you can preview the data directly on Apify Console .

Developer
Maintained by Community
Actor metrics
  • 3 monthly users
  • 2 stars
  • 100.0% runs succeeded
  • Created in Oct 2021
  • Modified 4 months ago
Categories