Aymen 385 Posted March 20, 2014 Report Share Posted March 20, 2014 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 8 Quote Link to post Share on other sites
Steve 30 Posted March 20, 2014 Report Share Posted March 20, 2014 Amazing Aymen! Not sure how you have enough time in the day to do everything -- but as always, thanks for the contributions!! Quote Link to post Share on other sites
Aymen 385 Posted March 20, 2014 Author Report Share Posted March 20, 2014 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! Quote Link to post Share on other sites
giganut 109 Posted March 20, 2014 Report Share Posted March 20, 2014 Thanks again Aymen Quote Link to post Share on other sites
don 1 Posted March 20, 2014 Report Share Posted March 20, 2014 Awesome Aymen, thanks buddy... i hope i can now do the work i left with this Quote Link to post Share on other sites
HelloInsomnia 1103 Posted March 20, 2014 Report Share Posted March 20, 2014 This is bada** JSON is use a lot on the web so this will be very handy! Quote Link to post Share on other sites
Code Docta (Nick C.) 638 Posted March 20, 2014 Report Share Posted March 20, 2014 Yes, yes, very handy indeed. Thank you sir Quote Link to post Share on other sites
Praney Behl 314 Posted March 20, 2014 Report Share Posted March 20, 2014 Nice one mate Quote Link to post Share on other sites
Bot-Factory 602 Posted March 31, 2014 Report Share Posted March 31, 2014 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..priceCannot 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) Quote Link to post Share on other sites
Bot-Factory 602 Posted April 2, 2014 Report Share Posted April 2, 2014 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..priceCannot 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 Quote Link to post Share on other sites
Aymen 385 Posted April 2, 2014 Author Report Share Posted April 2, 2014 Would be great if someone could test that as well?Might be that I'm doing something wrong? Dani 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! Quote Link to post Share on other sites
HelloInsomnia 1103 Posted April 6, 2014 Report Share Posted April 6, 2014 Hi Aymen, I had the same errors Dan had when I tested this in the wild. 1 Quote Link to post Share on other sites
Bot-Factory 602 Posted April 11, 2014 Report Share Posted April 11, 2014 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 Quote Link to post Share on other sites
Aymen 385 Posted April 11, 2014 Author Report Share Posted April 11, 2014 heythere 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! Quote Link to post Share on other sites
Aymen 385 Posted June 2, 2014 Author Report Share Posted June 2, 2014 Update :-Cannot convert Array to String bug fixed-Cannot convert Float to String bug fixed Use the same download link in the thread! Quote Link to post Share on other sites
earthlingj 13 Posted January 17, 2015 Report Share Posted January 17, 2015 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 1 Quote Link to post Share on other sites
RiTu 5 Posted March 9, 2015 Report Share Posted March 9, 2015 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. Quote Link to post Share on other sites
orbital 15 Posted May 8, 2015 Report Share Posted May 8, 2015 Has the filtering been fixed yet Aymen? Quote Link to post Share on other sites
Aymen 385 Posted May 11, 2015 Author Report Share Posted May 11, 2015 Has the filtering been fixed yet Aymen? Read this posthttp://www.ubotstudio.com/forum/index.php?/topic/16166-free-plugin-jsonpath-parser-plugin/&do=findComment&comment=94964 Quote Link to post Share on other sites
gavind 6 Posted May 27, 2015 Report Share Posted May 27, 2015 +1 on filtering please once you have time. Great job so far! Quote Link to post Share on other sites
acamso 55 Posted May 28, 2015 Report Share Posted May 28, 2015 Hey are the expressions working for anyone? Were the fixed? And is there another alternative? Thanks! Quote Link to post Share on other sites
dankass 52 Posted September 30, 2015 Report Share Posted September 30, 2015 Update :-Cannot convert Array to String bug fixed-Cannot convert Float to String bug fixed Use the same download link in the thread! The date on this post is Jun 02, 2014, but the date on the plugin in the download link is Apr 08, 2014... so the dl link has not been updated I dont think... I was trying to get filtering working and I cant, so trying to see if I had the newest version where you said that had been fixed, and I cant figure out if I have the fixed one or the broken one. Any help? Thanks Quote Link to post Share on other sites
Aymen 385 Posted October 5, 2015 Author Report Share Posted October 5, 2015 the link in there is the latest version!Did you check the plugin ? the bugs are still in there ? Quote Link to post Share on other sites
Aymen 385 Posted April 5, 2016 Author Report Share Posted April 5, 2016 Download link updated Quote Link to post Share on other sites
UBOTEM 18 Posted April 13, 2016 Report Share Posted April 13, 2016 Plugin v1.0.0.1 not working for me.... get an object error set(#json, "\{ \"firstName\": \"John\", \"lastName\" : \"Smith\", \"age\" : 25, \"address\" : \{ \"streetAddress\": \"21 2nd Street\", \"city\" : \"New York\", \"state\" : \"NY\", \"postalCode\" : \"10021\" \}, \"phoneNumber\": [ \{ \"type\" : \"home\", \"number\": \"212 555-1234\" \}, \{ \"type\" : \"fax\", \"number\": \"646 555-4567\" \} ] \}", "Global") alert($plugin function("JSONpath.dll", "$JSONpath parser", #json, "$..type")) Will open a fresh file and try again tomorrow! Will be cool if this works, and would save a big headache dealing with JSON. i notice no 'path exists' function, like in your xpath plugin... Maybe am doing something wrong? Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.