[FREE] JSON Path Extractor- extension for extracting data form JSON formatted data

Extensions
#1

Short description

The extension that I was looking for, for a long time. This extension will help you extract data from JSON formatted data. I found it very useful for extracting data received via API call and displaying it on UI. JSON Path, for me, is the easiest way of extracting data from JSON formatted data.

Only block

component_method

Usage instructions

component_method

This is a block that requires 2 arguments:

  • JSON - JSON formatted data that includes the data we want to extract
  • JSON Path - the JSON Path expression

As return we receive we receive a string with wanted data.

JSON Path learning materials:

Example blocks:

blocks (3)
blocks (3)991Ă—667 40.9 KB

Download links:

10 Likes
Youtube data call help
#2

Congrats for your extension…

Is it different than the existing other JSON extractor extensions?

Did you check your apk?

I get such error while opening the app

Screenshot_2021-09-12-23-51-16-85
Screenshot_2021-09-12-23-51-16-85720Ă—1520 83.5 KB

I am using andro version less than 10

1 Like
#3

Thanks for the feedback.
No I did not check the APK because it worked using the companion. Sorry about that.
I updated all 3 files with the latest version that worked on my Huawei P20 Lite, Android 9
(I checked this time :slight_smile: )

1 Like
#4

Yes, now It works in no time. Nice… Good work…

1 Like
#5

Great Extension, But IDK What is the use of it?

1 Like
#6

You just need to find, u will see hundreds :wink:

Nice Extension @markocurlinoski_uie :partying_face: Awesome Job

1 Like
#7

For me personally, the best way to parse JSON is JSON Path so I created this extension and uploaded to the community if anybody else need it :slight_smile:

3 Likes
#8

Hi, thanks for this wonderful Extension - working perfectly. Could you make an Update with Possibility to edit Values via JSON path?

#9

@markocurlinoski_uie or anyone give me solution -
How to find the length of array? i read docs but my problen not solve.

#10

What is the problem? as for data extraction, you can also successfully use standard tools. The WEB+Dictionary work are sufficient for this. in reality, it’s not difficult there. there are just a few more blocks :)) and then the “head-on solution” is character parsing :slight_smile:

#11

this is my json template, how to find lenth of the departments, courses etc

[
  {
    "universityName": "Global University",
    "universityLocation": {
      "city": "Springfield",
      "state": "California",
      "country": "USA"
    },
    "colleges": [
      {
        "collegeId": "C001",
        "collegeName": "School of Engineering",
        "departments": [
          {
            "departmentId": "D001",
            "departmentName": "Computer Science",
            "courses": [
              {
                "courseId": "CS101",
                "courseName": "Introduction to Programming",
                "credits": 4
              },
              {
                "courseId": "CS102",
                "courseName": "Data Structures",
                "credits": 3
              }
            ]
          },
          {
            "departmentId": "D002",
            "departmentName": "Electrical Engineering",
            "courses": [
              {
                "courseId": "EE101",
                "courseName": "Circuit Analysis",
                "credits": 4
              },
              {
                "courseId": "EE102",
                "courseName": "Electronics",
                "credits": 3
              }
            ]
          }
        ]
      },
      {
        "collegeId": "C002",
        "collegeName": "School of Business",
        "departments": [
          {
            "departmentId": "D003",
            "departmentName": "Business Administration",
            "courses": [
              {
                "courseId": "BA101",
                "courseName": "Principles of Management",
                "credits": 3
              },
              {
                "courseId": "BA102",
                "courseName": "Marketing 101",
                "credits": 3
              }
            ]
          }
        ]
      }
    ]
  },
  {
    "universityName": "International University",
    "universityLocation": {
      "city": "Metropolis",
      "state": "New York",
      "country": "USA"
    },
    "colleges": [
      {
        "collegeId": "C003",
        "collegeName": "School of Arts",
        "departments": [
          {
            "departmentId": "D004",
            "departmentName": "Fine Arts",
            "courses": [
              {
                "courseId": "FA101",
                "courseName": "Introduction to Painting",
                "credits": 3
              },
              {
                "courseId": "FA102",
                "courseName": "Sculpture 101",
                "credits": 3
              }
            ]
          }
        ]
      }
    ]
  }
]
#12

Solution:

Docs:
JSON Path syntax: JSONPath Syntax | AlertSite Documentation
Jayway JsonPath: GitHub - json-path/JsonPath: Java JsonPath implementation

at the “Jayway JsonPath” docs, i find solution for the find length of the Array
use: length() or $.length() as well as following docs :blush: