2

I have this curl output below:

{
    "code": "Ok",
    "routes": [{
        "geometry": "mlbj@qsp}VlEi@hAvHRCiKyr@gBkK`MmBN`AcC^QaA}GbAm@PRx@lDzUu@L?V",
        "legs": [{
            "steps": [],
            "summary": "",
            "weight": 356.9,
            "duration": 356.9,
            "distance": 2567.6
        }],
        "weight_name": "routability",
        "weight": 356.9,
        "duration": 356.9,
        "distance": 2567.6
    }],
    "waypoints": [{
        "hint": "FowshhuMLIYyAAAAfAAAAF0BAAAAAAAAgPWmQVj0TEJA9hBDAAAAADIAAAB8AAAAXQEAAAAAAADvOAAA2WB8B2bEawDqYHwHasRrAAcAfwpAAACy",
        "distance": 1.929525,
        "name": "",
        "location": [125.591769, 7.06263]
    }, {
        "hint": "w1ACh____38VAAAALAAAAAgAAABXAAAAwBUMQdyhGkH5DFdA6ToRQhUAAAAsAAAACAAAAFcAAADvOAAAbXN8B9rFawB6c3wHkcVrAAEAPxBAAACy",
        "distance": 8.199417,
        "name": "",
        "location": [125.596525, 7.063002]
    }]
}

I want to get the values of duration and distance from the legs section of routes. In this example, that would be 356.9 and 2567.6 respectively.

 "code": "Ok",
    "routes": [{
        "geometry": "mlbj@qsp}VlEi@hAvHRCiKyr@gBkK`MmBN`AcC^QaA}GbAm@PRx@lDzUu@L?V",
        "legs": [{
            "steps": [],
            "summary": "",
            "weight": 356.9,
            "duration": 356.9,
            "distance": 2567.6

I just know how to execute curl script, but I don't know how to extract values needed from it, so I ask for your help.

Improve this question
7
  • How can we know which duration value you want? Will it always be the first one found? Will you have the name of the geometry (in this case mlbj@qsp}VlEi@hAvHRCiKyr@gBkKMmBNAcC^QaA}GbAm@PRx@lDzUu@L?V?) Commented Oct 16, 2022 at 13:19
  • 3
    How do you want the results? jq -r '.routes[0].legs[0] | {duration, distance}' will get you a JSON block Commented Oct 16, 2022 at 13:26
  • terdon, yes it will be on geometry section Commented Oct 16, 2022 at 21:45
  • roaima, where do you execute jq - r? I would like to get the value in html or php file. Commented Oct 16, 2022 at 21:47
  • @terdon, the values is always under the ROUTES then LEGS section. Commented Oct 16, 2022 at 21:53

1 Answer 1

Reset to default
3

The following jq command would extract each duration and distance value pair in the legs array as two tab-delimited fields. This would be done for all entries in the routes array.

jq -r '.routes[].legs | map([.duration, .distance]|@tsv)[]'

You would typically pipe the output of curl into this command:

curl -s '...some URL...' | jq -r '...as above...'

Given the data in the question, this would generate

356.9   2567.6

You would obviously then parse the generated list of duration+distance pairs with some other command, like awk, depending on what you need to do with this data.

Improve this answer
1
  • Hello to all. Thank you so much for all your replies. I have tried all your suggestions to practice. Commented Oct 17, 2022 at 21:20

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.