DX Application Performance Management

Expand all | Collapse all

JSON Processing

Jump to Best Answer
  • 1.  JSON Processing

    Posted 05-09-2014 01:40 PM

    I am confused how to specify the JSONPath expression and how to troubleshoot it.  Does anyone have any suggestions?

    My data:

    [[ {"label": "/OSS/Spectrum/Central_Users#ActiveUsers 600 raw#vsum_hole", "data": [ [1399642800,25.0]] } ] ]

    Under the "data" part, the first number is a Unix timestamp, the second number is the value.

    I have gone out to jsonpath.curiousconcpet.com and tested out the JSONPath Expressions and was able to get:

    $..data[1] - to pull off just the data piece (25)

    $..data.[0][0] - to pull off the timestamp.

     

    When I put this into the parameters for "Metric Value and Metric Timestamp respectively, then hit test I get "Testing Error. index: 1, Size: 1.

    Any ideas, suggestions?  What does the Testing Error. index: 1, Size 1 mean?



  • 2.  RE: JSON Processing
    Best Answer

    Posted 05-09-2014 02:37 PM

    I found my problem.  The tests in JSONPATH.curiousconcept.com are a little more forgiving.

    If I change the first one to $..data[0][1] then I get the data that I need.