Jump to content
UBot Underground

[Sell] Json Path Builder


Recommended Posts

JSONpath-BOX2.jpg

 


Generate JSON Expressions with just a few Clicks
jsonpic.png


>> DEMO VIDEO - Click HERE<<
 


Everyone who works with Webservices or APIs a lot should get this!
It will save you so much time!



This is NOT for you if you're a JSON Expert who looks for a tool to build complex and complicated expressions
with filters and additional complex JSON rules.

But for the rest of us who automate lots of websites and work with a lot of webservices, you shouldn't miss this!

And the interesting thing is, a lot of websites offer APIs who return data in JSON format. And very often those APIs are not limited. 
So you might hit a limit on the regular website, but the underlying Webservice API doesn't has that limit.

 

 

If this is for you, please take a look at the Sales Page:
>>Click Here<<



p1.jpg

Link to post
Share on other sites

Really is a great software Dan.

 

Helped me get what I was needing from some json responses in a matter of seconds where as before was taking me a great deal of time trying to follow the trees, and everything trying to figure things out.

 

Very nicely done.  Recommend for anyone working with Json response data.

  • Like 2
Link to post
Share on other sites

Update V1.0.7.0

 

 

Changelog:

Added: Better array support

Added: Improved textbox structure builder
Changed: Seperation between menu's
Changed: Bugfix where the app would crash
Changed: Typo in log message
 


How To Get It:
Login to license Server and click the "Download Latest Version" Button.
Check your email inbox for the update newsletter with the download link.

Questions, Ideas and Support:
support(ad)bot-factory.com
 
Link to post
Share on other sites

This is great, and exactly what I needed to help me figure out  the expression I needed... I had the basics down already, but strugled with the syntax for filtering....  however, I cant seem to get the expression to work with the json path parser, and I dont know why...   I either have an older version of the Jsonpath plugin before the filtering stuff was fixed, (and cant find the newest version) or I just cant get it to work...(Version of the plugin I have has a file date of 04/08/2014) 

 

Also, a small note on your app on the filtering, if the result is a number, it should not have '' around it because it wont return a result. I removed the quotes and it works perfect... in your app, but not getting any results in ubot with the json plugin.... here was the expression I was trying to use with jsonpath parser:

 

order.line_items[?(@.id == 34)].meta[*] 

 

Shown below is the json... any idea why I cant get a result on this back in ubot? Or any other ways to utilize these expressions in ubot besides this plugin?

 

My issue is that sometimes the "Meta" is completely empty on some things under "line_items" and some things have multiple nodes under Meta. When something is empty with jsonpath the result is just empty, so it throws lists out of whack when trying to throw this into ubot lists or tables so I can sort the data into ubot and make it usable for my purposes.

{
   "order":{
      "id":5060,
      "order_number":5060,
      "created_at":"2015-05-07T22:04:00Z",
      "updated_at":"2015-09-29T23:36:47Z",
      "completed_at":"2015-05-31T20:00:07Z",
      "status":"processing",
      "currency":"USD",
      "total":"0.01",
      "subtotal":"19.96",
      "total_line_items_quantity":2,
      "total_tax":"0.00",
      "total_shipping":"0.00",
      "cart_tax":"0.00",
      "shipping_tax":"0.00",
      "total_discount":"0.00",
      "shipping_methods":"Free Shipping",
      "payment_details":{
         "method_id":"paypal",
         "method_title":"PayPal",
         "paid":true
      },
      "billing_address":{
         "first_name":"Joe",
         "last_name":"Blow",
         "company":"",
         "address_1":"123 Whatever",
         "address_2":"",
         "city":"Somecity",
         "state":"CA",
         "postcode":"92595",
         "country":"US",
         "email":"joe@blow.com",
         "phone":"9999999999"
      },
      "shipping_address":{
         "first_name":"Joe",
         "last_name":"Blow",
         "company":"",
         "address_1":"123 Whatever",
         "address_2":"",
         "city":"Somecity",
         "state":"CA",
         "postcode":"92595",
         "country":"US"
      },
      "note":"",
      "customer_id":1,
      "line_items":[
         {
            "id":21,
            "subtotal":"0.01",
            "subtotal_tax":"0.00",
            "total":"0.01",
            "total_tax":"0.00",
            "price":"0.01",
            "quantity":1,
            "tax_class":null,
            "name":"Test Product",
            "product_id":16840,
            "sku":"IHP-testproduct-blue",
            "meta":[

            ]
         },
         {
            "id":34,
            "subtotal":"19.95",
            "subtotal_tax":"0.00",
            "total":"19.95",
            "total_tax":"0.00",
            "price":"19.95",
            "quantity":1,
            "tax_class":null,
            "name":"Test Item",
            "product_id":17057,
            "sku":"TSG-12345",
            "meta":[
               {
                  "key":"pa_style",
                  "label":"Style",
                  "value":"Standard"
               },
               {
                  "key":"pa_size",
                  "label":"Size",
                  "value":"Small"
               },
               {
                  "key":"pa_color",
                  "label":"Color",
                  "value":"Black"
               }
            ]
         }
      ],
      "shipping_lines":[
         {
            "id":8,
            "method_id":"free_shipping",
            "method_title":"Free Shipping",
            "total":"0.00"
         }
      ],
      "tax_lines":[

      ],
      "fee_lines":[

      ],
      "coupon_lines":[
         {
            "id":9,
            "code":"freeship",
            "amount":"0.00"
         }
      ],
      "customer":{
         "woocommerce_api_invalid_customer":[
            "Invalid customer"
         ]
      }
   }
}
Link to post
Share on other sites

Hello.

 

We will look into that number thing asap. Thanks for the heads up. 
I can't help a lot with Aymens Json Plugin. Not sure what engine he's using in the plugin.Might be an idea to post in the Json thread. Aymen should be able to help with that one. 

I have a Json plugin as well. But don't have a Plugin key for it at the moment. But if Aymen is not able to help with that one, I might be able to release that one.

 

Dan

Link to post
Share on other sites
  • 5 months later...
  • 1 month later...
  • 2 months later...

For support please use: support(ad)bot-factory.com


 


Also don't forget:


 


Tutorials and Helpdesk:


https://botfactory.helpdocs.com


 


Youtube Channel:


https://www.youtube....lbSbGEVUqd3SCfQ


 


 


Tutorials and Helpdesk:


https://botfactory.helpdocs.com


 


Youtube Channel:


https://www.youtube....lbSbGEVUqd3SCfQ



For support please use: support(ad)bot-factory.com


 


Also don't forget:


 


Tutorials and Helpdesk:


https://botfactory.helpdocs.com


 


Youtube Channel:


https://www.youtube....lbSbGEVUqd3SCfQ


 


 


Tutorials and Helpdesk:


https://botfactory.helpdocs.com


 


Youtube Channel:


https://www.youtube....lbSbGEVUqd3SCfQ


Link to post
Share on other sites
  • 2 weeks later...
  • 1 month later...
  • 1 month later...
  • 3 weeks later...

Hey Dan, please check my support ticket asap.

 

My JPB license has vanished from my account ?

Please restore it!

Thanks!

 

Hi Macter. 

 

I reply within 48 hours normally. Monday - Friday. 

I try to not work on weekends anymore.

 

Sometimes it can take a bit longer. I'm not doing this fulltime and I travel a lot at the moment :-(

 

Thanks for your understanding.

 

Kindest regards

Dan

Link to post
Share on other sites

I know and i totally understand no worries.

Take you time just don't forget me.

Thanks.

Hi.

 

All tickets are processed. Can you please check that your ticket is available in:

https://danwan.supportsystem.com ?

 

Kindest regards

Dan

Link to post
Share on other sites

I have not received any email notification or ticket number on my requests, and my JsonPath Builder licenses is still missing from my account.

 

edit: i have sent a new ticket but still have not received any email / ticket number

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...