Jump to content



Photo

[FREE plugin] JsonPath Parser Plugin


  • Please log in to reply
34 replies to this topic

#1 Aymen

Aymen

    Advanced Member

  • Fellow UBotter
  • PipPipPip
  • 1361 posts
  • OS:Windows 8
  • Total Memory:4Gb
  • Framework:v3.5 & v4.0
  • License:Developer Edition

Posted 20 March 2014 - 06:10 AM

Easily Parse Json Outputs and Get The Data You Need Fast

Plugin Name :

JsonPath plugin

 

Plugin Desc :

a jsonpath integration – Json Output parser that is the equivalent to Xpath but for Json Outputs

 

A tutorial On how to build JsonPath Expressions

Click Here

 

Download For Free

(subscribe to my list to get new plugins)

 

if you want to download without subscribing and you wish not to receive the latest juicy free ubot plugins

when i release them , then use the link below to download the plugin

click here


★★★List Of Killer Ubot Plugins★★★

 

Need Support ? Submit a support ticket here

 

Refund Policy is Clear : No Refunds on all Ubot Plugins


#2 Steve

Steve

    Advanced Member

  • Fellow UBotter
  • PipPipPip
  • 259 posts
  • OS:Windows 8
  • Total Memory:More Than 9Gb
  • Framework:v4.0
  • License:Developer Edition

Posted 20 March 2014 - 06:15 AM

Amazing Aymen! Not sure how you have enough time in the day to do everything -- but as always, thanks for the contributions!!  :)



#3 Aymen

Aymen

    Advanced Member

  • Fellow UBotter
  • PipPipPip
  • 1361 posts
  • OS:Windows 8
  • Total Memory:4Gb
  • Framework:v3.5 & v4.0
  • License:Developer Edition

Posted 20 March 2014 - 06:17 AM

Amazing Aymen! Not sure how you have enough time in the day to do everything -- but as always, thanks for the contributions!!   :)

no biggie i put this together in 30 min , had to use it in a ubot prototype!


★★★List Of Killer Ubot Plugins★★★

 

Need Support ? Submit a support ticket here

 

Refund Policy is Clear : No Refunds on all Ubot Plugins


#4 giganut

giganut

    Advanced Member

  • Fellow UBotter
  • PipPipPip
  • 521 posts
  • LocationLost In Space!
  • OS:Windows 8
  • Total Memory:8Gb
  • Framework:v4.0
  • License:Developer Edition

Posted 20 March 2014 - 06:28 AM

Thanks again Aymen :)



#5 don

don

    Member

  • Members
  • PipPip
  • 26 posts
  • OS:Windows 8
  • Total Memory:8Gb
  • Framework:v3.5 & v4.0
  • License:Developer Edition

Posted 20 March 2014 - 06:53 AM

Awesome Aymen, thanks buddy... i hope i can now do the work i left with this :)



#6 HelloInsomnia

HelloInsomnia

    Advanced Member

  • Moderators
  • 2556 posts
  • OS:Windows 10
  • Total Memory:More Than 9Gb
  • Framework:v4.5+, unsure
  • License:Developer Edition

Posted 20 March 2014 - 07:07 AM

This is bada** JSON is use a lot on the web so this will be very handy!


j7v5d0A.png


#7 Code Docta (Nick C.)

Code Docta (Nick C.)

    Member for Hire

  • Fellow UBotter
  • PipPipPip
  • 1369 posts
  • LocationIn a Python or UBot IDE or ubotdocta.com
  • OS:Windows 10
  • Total Memory:More Than 9Gb
  • Framework:v4.5+, unsure
  • License:Developer Edition

Posted 20 March 2014 - 10:41 AM

Yes, yes, very handy indeed. Thank you sir :)


UBot Expert Tutorials

 

ubot-docta-header-ubot-expert-store.png

 

UBot expert tutorials and documentation at ubotdocta.com


#8 Praney Behl

Praney Behl

    Master Blaster

  • Fellow UBotter
  • PipPipPip
  • 2408 posts
  • LocationSydney, Australia
  • OS:Windows 8
  • Total Memory:More Than 9Gb
  • Framework:v3.5 & v4.0
  • License:Developer Edition

Posted 20 March 2014 - 02:58 PM

Nice one mate :)


The number of possibilities to do something with a tool you master, are only limited to your imagination. Try to think outside of the box.


#9 Bot-Factory (Dan)

Bot-Factory (Dan)

    Advanced Member

  • Fellow UBotter
  • PipPipPip
  • 2974 posts
  • LocationEurope/Germany
  • OS:Windows 8
  • Total Memory:8Gb
  • Framework:v4.0
  • License:Developer Edition

Posted 31 March 2014 - 09:24 AM

Hello Aymen,

 

I'm playing around with the plugin at the moment.

But I'm not able to use all the examples from the site:

http://goessner.net/articles/JsonPath/

 

I'm getting errors with:

$.store.*
Cannot convert Array to String
 
 
$.store..price
Cannot convert Float to String
 
 
$..book[?(@.isbn)]
Just an empty response
 
 
 
Do I have to use a different expression format with the plugin? Or what am I doing wrong here?
 
 
Example Code:
set(#test"\{ \"store\": \{
    \"book\": [ 
      \{ \"category\": \"reference\",
        \"author\": \"Nigel Rees\",
        \"title\": \"Sayings of the Century\",
        \"price\": 8.95
      \},
      \{ \"category\": \"fiction\",
        \"author\": \"Evelyn Waugh\",
        \"title\": \"Sword of Honour\",
        \"price\": 12.99
      \},
      \{ \"category\": \"fiction\",
        \"author\": \"Herman Melville\",
        \"title\": \"Moby Dick\",
        \"isbn\": \"0-553-21311-3\",
        \"price\": 8.99
      \},
      \{ \"category\": \"fiction\",
        \"author\": \"J. R. R. Tolkien\",
        \"title\": \"The Lord of the Rings\",
        \"isbn\": \"0-395-19395-8\",
        \"price\": 22.99
      \}
    ],
    \"bicycle\": \{
      \"color\": \"red\",
      \"price\": 19.95
    \}
  \}
\}""Global")
set(#test2$plugin function("JSONpath.dll""$JSONpath parser"#test"$..book[?(@.isbn)]"), "Global")
alert(#test2)
set(#test3$plugin function("JSONpath.dll""$JSONpath parser"#test"$.store..price"), "Global")
alert(#test3)
set(#test4$plugin function("JSONpath.dll""$JSONpath parser"#test"$.store.*"), "Global")
alert(#test4)

Signature-JPG.jpg


#10 Bot-Factory (Dan)

Bot-Factory (Dan)

    Advanced Member

  • Fellow UBotter
  • PipPipPip
  • 2974 posts
  • LocationEurope/Germany
  • OS:Windows 8
  • Total Memory:8Gb
  • Framework:v4.0
  • License:Developer Edition

Posted 02 April 2014 - 11:53 AM

 

Hello Aymen,

 

I'm playing around with the plugin at the moment.

But I'm not able to use all the examples from the site:

http://goessner.net/articles/JsonPath/

 

I'm getting errors with:

$.store.*
Cannot convert Array to String
 
 
$.store..price
Cannot convert Float to String
 
 
$..book[?(@.isbn)]
Just an empty response
 
 
 
Do I have to use a different expression format with the plugin? Or what am I doing wrong here?
 
 
Example Code:
set(#test"\{ \"store\": \{
    \"book\": [ 
      \{ \"category\": \"reference\",
        \"author\": \"Nigel Rees\",
        \"title\": \"Sayings of the Century\",
        \"price\": 8.95
      \},
      \{ \"category\": \"fiction\",
        \"author\": \"Evelyn Waugh\",
        \"title\": \"Sword of Honour\",
        \"price\": 12.99
      \},
      \{ \"category\": \"fiction\",
        \"author\": \"Herman Melville\",
        \"title\": \"Moby Dick\",
        \"isbn\": \"0-553-21311-3\",
        \"price\": 8.99
      \},
      \{ \"category\": \"fiction\",
        \"author\": \"J. R. R. Tolkien\",
        \"title\": \"The Lord of the Rings\",
        \"isbn\": \"0-395-19395-8\",
        \"price\": 22.99
      \}
    ],
    \"bicycle\": \{
      \"color\": \"red\",
      \"price\": 19.95
    \}
  \}
\}""Global")
set(#test2$plugin function("JSONpath.dll""$JSONpath parser"#test"$..book[?(@.isbn)]"), "Global")
alert(#test2)
set(#test3$plugin function("JSONpath.dll""$JSONpath parser"#test"$.store..price"), "Global")
alert(#test3)
set(#test4$plugin function("JSONpath.dll""$JSONpath parser"#test"$.store.*"), "Global")
alert(#test4)

 

Would be great if someone could test that as well?

Might be that I'm doing something wrong?

 

Dan


Signature-JPG.jpg


#11 Aymen

Aymen

    Advanced Member

  • Fellow UBotter
  • PipPipPip
  • 1361 posts
  • OS:Windows 8
  • Total Memory:4Gb
  • Framework:v3.5 & v4.0
  • License:Developer Edition

Posted 02 April 2014 - 12:08 PM

Would be great if someone could test that as well?

Might be that I'm doing something wrong?

 

Dan

i didn't have a chance to test everything yet ,when i get some time I'll run different scenarios and see if it has problems!


★★★List Of Killer Ubot Plugins★★★

 

Need Support ? Submit a support ticket here

 

Refund Policy is Clear : No Refunds on all Ubot Plugins


#12 HelloInsomnia

HelloInsomnia

    Advanced Member

  • Moderators
  • 2556 posts
  • OS:Windows 10
  • Total Memory:More Than 9Gb
  • Framework:v4.5+, unsure
  • License:Developer Edition

Posted 06 April 2014 - 09:38 AM

Hi Aymen,

 

I had the same errors Dan had when I tested this in the wild.


j7v5d0A.png


#13 Bot-Factory (Dan)

Bot-Factory (Dan)

    Advanced Member

  • Fellow UBotter
  • PipPipPip
  • 2974 posts
  • LocationEurope/Germany
  • OS:Windows 8
  • Total Memory:8Gb
  • Framework:v4.0
  • License:Developer Edition

Posted 11 April 2014 - 12:56 PM

Hi Aymen,

 

I had the same errors Dan had when I tested this in the wild.

Thanks for testing it! I thought I'm doing something wrong.

 

Dan


Signature-JPG.jpg


#14 Aymen

Aymen

    Advanced Member

  • Fellow UBotter
  • PipPipPip
  • 1361 posts
  • OS:Windows 8
  • Total Memory:4Gb
  • Framework:v3.5 & v4.0
  • License:Developer Edition

Posted 11 April 2014 - 01:31 PM

hey

there was a bug with digits not being converted properly to string , that was fixed rather than that the only thing that didn't work for me (after i fixed the bug) is filtering !

Which was a general issue with the class library written by those who made JsonPath!

I'll try to fix it myself when i get some time off!


★★★List Of Killer Ubot Plugins★★★

 

Need Support ? Submit a support ticket here

 

Refund Policy is Clear : No Refunds on all Ubot Plugins


#15 Aymen

Aymen

    Advanced Member

  • Fellow UBotter
  • PipPipPip
  • 1361 posts
  • OS:Windows 8
  • Total Memory:4Gb
  • Framework:v3.5 & v4.0
  • License:Developer Edition

Posted 02 June 2014 - 06:23 AM

Update :

-Cannot convert Array to String bug fixed

-Cannot convert Float to String bug fixed

 

Use the same download link in the thread!


★★★List Of Killer Ubot Plugins★★★

 

Need Support ? Submit a support ticket here

 

Refund Policy is Clear : No Refunds on all Ubot Plugins


#16 earthlingj

earthlingj

    Advanced Member

  • Fellow UBotter
  • PipPipPip
  • 208 posts
  • OS:Windows 8
  • Total Memory:< 1Gb
  • Framework:v3.5
  • License:Standard Edition

Posted 16 January 2015 - 11:59 PM

I am trying to do an expression like the above examples of dan's

 

"$..book[?(@.isbn)]" and getting nothing.

 

that expression is extremely useful and would be great if this could be fixed/added ASAP!

 

Thanks



#17 RiTu

RiTu

    Member

  • Fellow UBotter
  • PipPip
  • 12 posts
  • OS:Windows Server 2012
  • Total Memory:More Than 9Gb
  • Framework:v3.5 & v4.0
  • License:Developer Edition

Posted 08 March 2015 - 10:43 PM

I am trying to do an expression like the above examples of dan's

 

"$..book[?(@.isbn)]" and getting nothing.

 

that expression is extremely useful and would be great if this could be fixed/added ASAP!

 

Thanks

 

Great plugin, but the expressions aren't working. Maybe Aymen could add it.



#18 orbital

orbital

    Advanced Member

  • Fellow UBotter
  • PipPipPip
  • 211 posts
  • OS:Windows 8
  • Total Memory:4Gb
  • Framework:v4.0
  • License:Developer Edition

Posted 08 May 2015 - 12:31 PM

Has the filtering been fixed yet Aymen? 



#19 Aymen

Aymen

    Advanced Member

  • Fellow UBotter
  • PipPipPip
  • 1361 posts
  • OS:Windows 8
  • Total Memory:4Gb
  • Framework:v3.5 & v4.0
  • License:Developer Edition

Posted 11 May 2015 - 02:48 AM

Has the filtering been fixed yet Aymen? 

 

Read this post

http://www.ubotstudi...gin/#entry94964


★★★List Of Killer Ubot Plugins★★★

 

Need Support ? Submit a support ticket here

 

Refund Policy is Clear : No Refunds on all Ubot Plugins


#20 gavind

gavind

    Advanced Member

  • Members
  • PipPipPip
  • 176 posts
  • OS:Windows 8
  • Total Memory:4Gb
  • Framework:v3.5
  • License:Community Edition

Posted 26 May 2015 - 11:56 PM

+1 on filtering please once you have time. Great job so far! smile3.png






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users