Bash-jq-examples - Revision history

Chubbard: /* Another way to filter down to what you are searching for */

2024-10-16T18:53:07Z

Another way to filter down to what you are searching for

@@ Line 59: / Line 59: @@
      }' < "$JSON_FILE"
 </pre>
 [[Category:bash]]

Chubbard at 21:55, 25 April 2024

2024-04-25T21:55:59Z

← Older revision		Revision as of 14:55, 25 April 2024
Line 1:		Line 1:
			<metadesc>Examples of using jq to parse output for use in a bash script.</metadesc>
	== Some examples of using jq to do filtering.. ==		== Some examples of using jq to do filtering.. ==

Chubbard: /* Another way to filter down to what you are searching for */

2024-04-19T18:28:51Z

Another way to filter down to what you are searching for

← Older revision		Revision as of 11:28, 19 April 2024
Line 46:		Line 46:
	</pre>		</pre>
	== Another way to filter down to what you are searching for ==		== Another way to filter down to what you are searching for ==
			* TBH, this one feels like simply abusing jq until it pukes up what you asked for

	<pre>		<pre>
	JSON_FILE=$1		JSON_FILE=$1

Chubbard at 18:28, 19 April 2024

2024-04-19T18:28:10Z

← Older revision		Revision as of 11:28, 19 April 2024
Line 49:		Line 49:
	JSON_FILE=$1		JSON_FILE=$1

	jq ' .system_env_json.~~VCAP_SERVICES~~ \| paths(select(. != null and type == "object" and has("credential-type"))) as $p \|		jq ' .system_env_json.someService \| paths(select(. != null and type == "object" and has("credential-type"))) as $p \|
	{		{
	name: getpath($p[:-1] + ["name"]),		name: getpath($p[:-1] + ["name"]),

Chubbard at 18:27, 19 April 2024

2024-04-19T18:27:32Z

@@ Line 45: / Line 45: @@
+}
 </pre>
 [[Category:bash]]

Chubbard at 17:37, 19 April 2024

2024-04-19T17:37:34Z

@@ Line 1: / Line 1: @@
-Some examples of using jq to do filtering..
+== Some examples of using jq to do filtering.. ==
 <pre>
@@ Line 23: / Line 23: @@
 <pre> contains ("LIVE"|"DEAD") </pre>
 [https://stackoverflow.com/questions/26701538/how-to-filter-an-array-of-objects-based-on-values-in-an-inner-array-with-jq| Stackoverflow details]
 [[Category:bash]]

Chubbard: Created page with "Some examples of using jq to do filtering..

 raw jason: {   "1": [     {       "id": "123456789",       "accountId": "a1-supplies-01234",       "accountName": "a1-suppli..."

2021-12-03T22:19:52Z

Created page with "Some examples of using jq to do filtering.. <pre> raw jason: { "1": [ { "id": "123456789", "accountId": "a1-supplies-01234", "accountName": "a1-suppli..."

New page

Some examples of using jq to do filtering..

<pre>
raw jason:
{
"1": [
{
"id": "123456789",
"accountId": "a1-supplies-01234",
"accountName": "a1-supplies",
"status": "LIVE",
"customerId": "A1 Supplies",
"customerType": "display"
}
]
}
Map will iterate through the array(s) looking for key status, and value LIVE
<json here> | jq -c 'map(select(.[].status | contains ("LIVE")))' | jq
</pre>
* Running the output through jq again puts the line breaks back in place

* contains in a search DOES honor pipes
<pre> contains ("LIVE"|"DEAD") </pre>
[https://stackoverflow.com/questions/26701538/how-to-filter-an-array-of-objects-based-on-values-in-an-inner-array-with-jq| Stackoverflow details]
[[Category:bash]]