Analyse, transform, and selectively extract data from JSON documents (and JavaScript objects). Try to test the json path valid or not at the json path online https://jsonpath.com/

Input example

{
    "jsonPath": "$[?(@.price>15000000)]",
    "transformFunction": "$ => ({ name: $.name, sku: $.sku })",
    "url": "https://api.apify.com/v2/datasets/P88peu2dDFe53hdMK/items?clean=true&format=json"
}

Output example

The output has only items with price is greater than 15 millions and will only two properties (name, sku)

[{
  "name": "Apple iPhone 13",
  "sku": "5447919661404"
},
{
  "name": "Apple iPhone 11",
  "sku": "5679549432792"
}]

On this page

- Input example
- Output example

Share Actor:

AI Document Assistant

devninja/ai-document-assistant

This actor analyzes uploaded documents using AI to extract and process information. It helps businesses quickly get answers from their documents and automate decision-making.

Devinja

5.0

Javascript Library Detail Scraper

cykieffodh/javascript-library-detail-scraper

Javascript Library Detail Scraper

Michael Laflin

Json Compare

petr_cermak/json-compare

Act for comparing 2 JSON arrays of objects. By default the final result set will contain only new and updated records.

Petr Cermak

Haawke_scraper

haawke/haawke-scraper

Scrape anything in javascript

Craig Ellenwood

MongoDB Import

drobnikj/mongodb-import

Act import objects to specific mongodb collection. You can pass list of plain objects or Apify key-value store as input. For info see readme bellow.

Jakub Drobník

JSON to CSV Converter

eloquent_mountain/json-to-csv-converter

JSON to CSV Converter. Effortlessly transform JSON data into CSV with our Apify actor. Handle nested structures, expand lists into rows, and customize separators and delimiters. Input via URL or paste JSON text. Ideal for data analysis and reporting!

Paco

Image To Json Extractor

apitale/image-to-json-extractor

AI-Powered Image to JSON Data Extractor. Utilize cutting-edge AI to transform image content into structured JSON data effortlessly. Perfect for automating data extraction from visual content and streamlining workflows.

Apitale

Array to Excel

hamza.alwan/array-to-excel

Converts any array of objects to Excel

Hamza Alwan

Scribd Scraper

jupri/scribd

💫 Search Scribd.com Documents

cat

XML to JSON Converter

eloquent_mountain/xml-to-json-converter

XML to JSON Converter Convert any XML file to JSON effortlessly with this Apify actor. Handle complex XML structures and transform them into structured JSON data. Supports input via URL or direct text paste, making it easy to integrate into your data processing workflows.

Paco