Revisions to JSON with jq into bash array / loop through

deleted 368 characters in body

Source Link

edited Jan 3, 2022 at 19:35

85
1
2
8

{"storageDaily":[{"atRestTotal":25533931665021 
.895,"intervalStart":"2022-01-01T00:00:00Z"},{"atRestTotal":29709512719925.227,"intervalStart":"2022-01-02T00:00:00Z"},{"atRestTotal":13380949356390.035,"intervalStart":"2022-01-03T00:00:00Z"}],"bandwidthDaily":[{"egress":{"repair":493916416,"audit":43008,"usage":11927222272},"ingress":{"repair":7032896256,"usage":4831426304},"delete":0,"intervalStart":"2022-01-01T00:00:00Z"},{"egress":{"repair":473738496,"audit":55296,"usage":9067689472},"ingress":{"repair":7451795968,"usage":5665944832},"delete":0,"intervalStart":"2022-01-02T00:00:00Z"},{"egress":{"repair":274565376,"audit":36608,"usage":6555262464},"ingress":{"repair":4392258048,"usage":6164209664},"delete":0,"intervalStart":"2022-01-03T00:00:00Z"}],
   "storageSummary":68624393741337 6.16,"bandwidthSummary":64331060480,"egressSummary":28792529408,"ingressSummary":355385310728624392E13,"earliestJoinedAt":"2021-05-11T20:11:13 
.633935Z",..
   "audits": [
      {
         "auditScore": 1,
         "suspensionScore": 1,
         "onlineScore": 0.997435897435897499743587,
         "satelliteName": "us2.storj.io:7777"
      },
      {
         "auditScore": 1,
         "suspensionScore": 1,
         "onlineScore": 0.99929169746242919992917,
         "satelliteName": "saltlake.tardigrade.io:7777"},{"auditScore":1,"suspensionScore":1,"onlineScore":0.9993055555555554,"satelliteName":"ap1.storj.io:7777"
      },{"auditScore":1,"suspensionScore":1,"onlineScore":0 
.9983458920196197,"satelliteName":"us1.storj.io:7777"},
      {
         "auditScore": 1,
         "suspensionScore": 1,
         "onlineScore": 0.998428362573099399930555,
         "satelliteName":"eu1 "ap1.storj.io:7777"},{"auditScore":1,"suspensionScore":1,"onlineScore":0.9966666666666666,"satelliteName":"europe-north-1.tardigrade.io:7777"
      }
   ] 
}

{"storageDaily":[{"atRestTotal":25533931665021.895,"intervalStart":"2022-01-01T00:00:00Z"},{"atRestTotal":29709512719925.227,"intervalStart":"2022-01-02T00:00:00Z"},{"atRestTotal":13380949356390.035,"intervalStart":"2022-01-03T00:00:00Z"}],"bandwidthDaily":[{"egress":{"repair":493916416,"audit":43008,"usage":11927222272},"ingress":{"repair":7032896256,"usage":4831426304},"delete":0,"intervalStart":"2022-01-01T00:00:00Z"},{"egress":{"repair":473738496,"audit":55296,"usage":9067689472},"ingress":{"repair":7451795968,"usage":5665944832},"delete":0,"intervalStart":"2022-01-02T00:00:00Z"},{"egress":{"repair":274565376,"audit":36608,"usage":6555262464},"ingress":{"repair":4392258048,"usage":6164209664},"delete":0,"intervalStart":"2022-01-03T00:00:00Z"}],"storageSummary":68624393741337.16,"bandwidthSummary":64331060480,"egressSummary":28792529408,"ingressSummary":35538531072,"earliestJoinedAt":"2021-05-11T20:11:13.633935Z","audits":[{"auditScore":1,"suspensionScore":1,"onlineScore":0.9974358974358974,"satelliteName":"us2.storj.io:7777"},{"auditScore":1,"suspensionScore":1,"onlineScore":0.9992916974624291,"satelliteName":"saltlake.tardigrade.io:7777"},{"auditScore":1,"suspensionScore":1,"onlineScore":0.9993055555555554,"satelliteName":"ap1.storj.io:7777"},{"auditScore":1,"suspensionScore":1,"onlineScore":0.9983458920196197,"satelliteName":"us1.storj.io:7777"},{"auditScore":1,"suspensionScore":1,"onlineScore":0.9984283625730993,"satelliteName":"eu1.storj.io:7777"},{"auditScore":1,"suspensionScore":1,"onlineScore":0.9966666666666666,"satelliteName":"europe-north-1.tardigrade.io:7777"}]}

{ 
...
   "storageSummary": 6.8624392E13, 
...
   "audits": [
      {
         "auditScore": 1,
         "suspensionScore": 1,
         "onlineScore": 0.99743587,
         "satelliteName": "us2.storj.io:7777"
      },
      {
         "auditScore": 1,
         "suspensionScore": 1,
         "onlineScore": 0.9992917,
         "satelliteName": "saltlake.tardigrade.io:7777"
      }, 
...
      {
         "auditScore": 1,
         "suspensionScore": 1,
         "onlineScore": 0.99930555,
         "satelliteName": "ap1.storj.io:7777"
      }
   ] 
}

added an overall satellites url call, I was not aware of before

Source Link

edited Jan 3, 2022 at 19:23

bjoern

85
1
2
8

UPDATE: #1

UPDATE #2

There is a result for http://localhost:14002/api/sno/satellites, I was not aware of before. The result is:

{"storageDaily":[{"atRestTotal":25533931665021.895,"intervalStart":"2022-01-01T00:00:00Z"},{"atRestTotal":29709512719925.227,"intervalStart":"2022-01-02T00:00:00Z"},{"atRestTotal":13380949356390.035,"intervalStart":"2022-01-03T00:00:00Z"}],"bandwidthDaily":[{"egress":{"repair":493916416,"audit":43008,"usage":11927222272},"ingress":{"repair":7032896256,"usage":4831426304},"delete":0,"intervalStart":"2022-01-01T00:00:00Z"},{"egress":{"repair":473738496,"audit":55296,"usage":9067689472},"ingress":{"repair":7451795968,"usage":5665944832},"delete":0,"intervalStart":"2022-01-02T00:00:00Z"},{"egress":{"repair":274565376,"audit":36608,"usage":6555262464},"ingress":{"repair":4392258048,"usage":6164209664},"delete":0,"intervalStart":"2022-01-03T00:00:00Z"}],"storageSummary":68624393741337.16,"bandwidthSummary":64331060480,"egressSummary":28792529408,"ingressSummary":35538531072,"earliestJoinedAt":"2021-05-11T20:11:13.633935Z","audits":[{"auditScore":1,"suspensionScore":1,"onlineScore":0.9974358974358974,"satelliteName":"us2.storj.io:7777"},{"auditScore":1,"suspensionScore":1,"onlineScore":0.9992916974624291,"satelliteName":"saltlake.tardigrade.io:7777"},{"auditScore":1,"suspensionScore":1,"onlineScore":0.9993055555555554,"satelliteName":"ap1.storj.io:7777"},{"auditScore":1,"suspensionScore":1,"onlineScore":0.9983458920196197,"satelliteName":"us1.storj.io:7777"},{"auditScore":1,"suspensionScore":1,"onlineScore":0.9984283625730993,"satelliteName":"eu1.storj.io:7777"},{"auditScore":1,"suspensionScore":1,"onlineScore":0.9966666666666666,"satelliteName":"europe-north-1.tardigrade.io:7777"}]}

UPDATE:

UPDATE #1

UPDATE #2

There is a result for http://localhost:14002/api/sno/satellites, I was not aware of before. The result is:

{"storageDaily":[{"atRestTotal":25533931665021.895,"intervalStart":"2022-01-01T00:00:00Z"},{"atRestTotal":29709512719925.227,"intervalStart":"2022-01-02T00:00:00Z"},{"atRestTotal":13380949356390.035,"intervalStart":"2022-01-03T00:00:00Z"}],"bandwidthDaily":[{"egress":{"repair":493916416,"audit":43008,"usage":11927222272},"ingress":{"repair":7032896256,"usage":4831426304},"delete":0,"intervalStart":"2022-01-01T00:00:00Z"},{"egress":{"repair":473738496,"audit":55296,"usage":9067689472},"ingress":{"repair":7451795968,"usage":5665944832},"delete":0,"intervalStart":"2022-01-02T00:00:00Z"},{"egress":{"repair":274565376,"audit":36608,"usage":6555262464},"ingress":{"repair":4392258048,"usage":6164209664},"delete":0,"intervalStart":"2022-01-03T00:00:00Z"}],"storageSummary":68624393741337.16,"bandwidthSummary":64331060480,"egressSummary":28792529408,"ingressSummary":35538531072,"earliestJoinedAt":"2021-05-11T20:11:13.633935Z","audits":[{"auditScore":1,"suspensionScore":1,"onlineScore":0.9974358974358974,"satelliteName":"us2.storj.io:7777"},{"auditScore":1,"suspensionScore":1,"onlineScore":0.9992916974624291,"satelliteName":"saltlake.tardigrade.io:7777"},{"auditScore":1,"suspensionScore":1,"onlineScore":0.9993055555555554,"satelliteName":"ap1.storj.io:7777"},{"auditScore":1,"suspensionScore":1,"onlineScore":0.9983458920196197,"satelliteName":"us1.storj.io:7777"},{"auditScore":1,"suspensionScore":1,"onlineScore":0.9984283625730993,"satelliteName":"eu1.storj.io:7777"},{"auditScore":1,"suspensionScore":1,"onlineScore":0.9966666666666666,"satelliteName":"europe-north-1.tardigrade.io:7777"}]}

added 6906 characters in body

Source Link

edited Jan 2, 2022 at 8:02

bjoern

85
1
2
8

I guess I can start with the following (from JSON array to bash variables using jq), but I do not know, how to loop through the results and how to name and validate the fields:

{"nodeID":"1veqEG5xuBNkt""1veqEG5xuBNkt...","wallet":"0x942bb01a75E""12345","walletFeatures":["zksync"],"satellites":[{"id":"12tRQrMTWUWwzwGh18i7Fqs67kmdhH9t6aToeiwbo5mfS2rUmo","url":"us2.storj.io:7777","disqualified":null,"suspended":null,"currentStorageUsed":4592556672},{"id":"1wFTAgs9DP5RSnCqKV1eLf6N9wtk4EAtmN5DpSxcs8EjT69tGE","url":"saltlake.tardigrade.io:7777","disqualified":null,"suspended":null,"currentStorageUsed":513269323264},{"id":"121RTSDpyNZVcEU84Ticf2L1ntiuUimbWgfATz21tuvgk3vzoA6","url":"ap1.storj.io:7777","disqualified":null,"suspended":null,"currentStorageUsed":70956116864},{"id":"12EayRS2V1kEsWESU9QMRseFhdxYxKicsiFmxrsLZHeLUtdps3S","url":"us1.storj.io:7777","disqualified":null,"suspended":null,"currentStorageUsed":322340591104},{"id":"12L9ZFwhzVpuEKMUNUqkaTLGzwY9G24tbiigLiXpmZWKwmcNDDs","url":"eu1.storj.io:7777","disqualified":null,"suspended":null,"currentStorageUsed":148740125312},{"id":"12rfG3sh9NCWiX3ivPjq2HtdLmbqCrvHVEzJubnzFzosMuawymB","url":"europe-north-1.tardigrade.io:7777","disqualified":null,"suspended":null,"currentStorageUsed":100681406976}],"diskSpace":{"used":1162257094528,"available":9500000000000,"trash":43196690332,"overused":0},"bandwidth":{"used":31670206976,"available":0},"lastPinged":"2022-01-02T07:55:51.886776586Z","version":"1.45.3","allowedVersion":"1.24.0","upToDate":true,"startedAt":"2021-12-31T00:00:32.209840775Z"}

I guess I can start with the following, but I do not know, how to loop through the results and how to name and validate the fields:

{"nodeID":"1veqEG5xuBNkt","wallet":"0x942bb01a75E","walletFeatures":["zksync"],"satellites":[{"id":"12tRQrMTWUWwzwGh18i7Fqs67kmdhH9t6aToeiwbo5mfS2rUmo","url":"us2.storj.io:7777","disqualified":null,"suspended":null,"currentStorageUsed":4592556672},{"id":"1wFTAgs9DP5RSnCqKV1eLf6N9wtk4EAtmN5DpSxcs8EjT69tGE","url":"saltlake.tardigrade.io:7777","disqualified":null,"suspended":null,"currentStorageUsed":513269323264},{"id":"121RTSDpyNZVcEU84Ticf2L1ntiuUimbWgfATz21tuvgk3vzoA6","url":"ap1.storj.io:7777","disqualified":null,"suspended":null,"currentStorageUsed":70956116864},{"id":"12EayRS2V1kEsWESU9QMRseFhdxYxKicsiFmxrsLZHeLUtdps3S","url":"us1.storj.io:7777","disqualified":null,"suspended":null,"currentStorageUsed":322340591104},{"id":"12L9ZFwhzVpuEKMUNUqkaTLGzwY9G24tbiigLiXpmZWKwmcNDDs","url":"eu1.storj.io:7777","disqualified":null,"suspended":null,"currentStorageUsed":148740125312},{"id":"12rfG3sh9NCWiX3ivPjq2HtdLmbqCrvHVEzJubnzFzosMuawymB","url":"europe-north-1.tardigrade.io:7777","disqualified":null,"suspended":null,"currentStorageUsed":100681406976}],"diskSpace":{"used":1162257094528,"available":9500000000000,"trash":43196690332,"overused":0},"bandwidth":{"used":31670206976,"available":0},"lastPinged":"2022-01-02T07:55:51.886776586Z","version":"1.45.3","allowedVersion":"1.24.0","upToDate":true,"startedAt":"2021-12-31T00:00:32.209840775Z"}

I guess I can start with the following (from JSON array to bash variables using jq), but I do not know, how to loop through the results and how to name and validate the fields:

{"nodeID":"1veqEG5xuBNkt...","wallet":"12345","walletFeatures":["zksync"],"satellites":[{"id":"12tRQrMTWUWwzwGh18i7Fqs67kmdhH9t6aToeiwbo5mfS2rUmo","url":"us2.storj.io:7777","disqualified":null,"suspended":null,"currentStorageUsed":4592556672},{"id":"1wFTAgs9DP5RSnCqKV1eLf6N9wtk4EAtmN5DpSxcs8EjT69tGE","url":"saltlake.tardigrade.io:7777","disqualified":null,"suspended":null,"currentStorageUsed":513269323264},{"id":"121RTSDpyNZVcEU84Ticf2L1ntiuUimbWgfATz21tuvgk3vzoA6","url":"ap1.storj.io:7777","disqualified":null,"suspended":null,"currentStorageUsed":70956116864},{"id":"12EayRS2V1kEsWESU9QMRseFhdxYxKicsiFmxrsLZHeLUtdps3S","url":"us1.storj.io:7777","disqualified":null,"suspended":null,"currentStorageUsed":322340591104},{"id":"12L9ZFwhzVpuEKMUNUqkaTLGzwY9G24tbiigLiXpmZWKwmcNDDs","url":"eu1.storj.io:7777","disqualified":null,"suspended":null,"currentStorageUsed":148740125312},{"id":"12rfG3sh9NCWiX3ivPjq2HtdLmbqCrvHVEzJubnzFzosMuawymB","url":"europe-north-1.tardigrade.io:7777","disqualified":null,"suspended":null,"currentStorageUsed":100681406976}],"diskSpace":{"used":1162257094528,"available":9500000000000,"trash":43196690332,"overused":0},"bandwidth":{"used":31670206976,"available":0},"lastPinged":"2022-01-02T07:55:51.886776586Z","version":"1.45.3","allowedVersion":"1.24.0","upToDate":true,"startedAt":"2021-12-31T00:00:32.209840775Z"}

added 6906 characters in body

Source Link

edited Jan 2, 2022 at 7:55

bjoern

85
1
2
8

Loading

Source Link

asked Jan 1, 2022 at 22:08

bjoern

85
1
2
8

Loading

Stack Exchange Network

Return to Question