mikaelvesavuori · January 14, 2025 07:25 · Nov 22, 2022 · Nov 22, 2022 · Nov 22, 2022 · Nov 22, 2022
diff --git a/ic-metrics-gh-graphql-api.md b/ic-metrics-gh-graphql-api.md
@@ -8,10 +8,10 @@ These are some handy snippets to get common metrics for checking how active a so
 
 ## Setup
 
-Don't forget to [create a Personal Access Token ("classic")](https://docs.github.com/en/authentication/keeping-your-account-and-data-secure/creating-a-personal-access-token) and set the correct headers before calling the API.
-
 **The API endpoint is [https://api.github.com/graphql](https://api.github.com/graphql)**.
 
+Don't forget to [create a Personal Access Token ("classic")](https://docs.github.com/en/authentication/keeping-your-account-and-data-secure/creating-a-personal-access-token) and set the correct headers before calling the API.
+
 | Header           | Value                            |
 | ---------------- | -------------------------------- |
 | `Content-Type`   | `application/json`               |

diff --git a/ic-metrics-gh-graphql-api.md b/ic-metrics-gh-graphql-api.md
@@ -10,6 +10,8 @@ These are some handy snippets to get common metrics for checking how active a so
 
 Don't forget to [create a Personal Access Token ("classic")](https://docs.github.com/en/authentication/keeping-your-account-and-data-secure/creating-a-personal-access-token) and set the correct headers before calling the API.
 
+**The API endpoint is [https://api.github.com/graphql](https://api.github.com/graphql)**.
+
 | Header           | Value                            |
 | ---------------- | -------------------------------- |
 | `Content-Type`   | `application/json`               |

diff --git a/ic-metrics-gh-graphql-api.md b/ic-metrics-gh-graphql-api.md
@@ -1,6 +1,25 @@
 # Get Individual Contributor metrics from GitHub's GraphQL API
 
-Description.
+These are some handy snippets to get common metrics for checking how active a software engineer is.
+
+- How many pushes are made by the IC?
+- How many reviews are made by the IC?
+- How many comments are made by the IC?
+
+## Setup
+
+Don't forget to [create a Personal Access Token ("classic")](https://docs.github.com/en/authentication/keeping-your-account-and-data-secure/creating-a-personal-access-token) and set the correct headers before calling the API.
+
+| Header           | Value                            |
+| ---------------- | -------------------------------- |
+| `Content-Type`   | `application/json`               |
+| `Accept`         | `application/vnd.github.v3+json` |
+| `Authorization`  | `Bearer {PAT}`                   |
+
+## References
+
+- [GitHub GraphQL API](https://docs.github.com/en/graphql)
+- [Searching issues and pull requests](https://docs.github.com/en/search-github/searching-on-github/searching-issues-and-pull-requests)
 
 ## How many pushes are made by the IC?
 
@@ -25,7 +44,7 @@ query ($user: String!, $start: DateTime!, $end: DateTime!) {
 }
 ```
 
-Query variables:
+### Query variables
 
 ```json
 {
@@ -35,6 +54,10 @@ Query variables:
 }
 ```
 
+### JSONPath Plus
+
+Use `$.data..totalCount` to get the count for each repository.
+
 ## How many reviews are made by the IC?
 
 ```gql
@@ -60,14 +83,18 @@ query ($query: String!) {
 }
 ```
 
-Query variables:
+### Query variables
 
 ```json
 {
   "query": "created:2022-01-01..2022-12-31 reviewed-by:YOUR_USER"
 }
 ```
 
+### JSONPath Plus
+
+Use `$.data.search.nodes.length` to get the count.
+
 ## How many comments are made by the IC?
 
 ```gql
@@ -90,10 +117,14 @@ query ($query: String!) {
 }
 ```
 
-Query variables:
+### Query variables
 
 ```json
 {
   "query": "created:2022-01-01..2022-12-31 commenter:YOUR_USER"
 }
 ```
+
+### JSONPath Plus
+
+Use `$.data.search.nodes.length` to get the count.
diff --git a/ic-metrics-gh-graphql-api.md b/ic-metrics-gh-graphql-api.md
@@ -6,94 +6,94 @@ Description.
 
 ```gql
 query ($user: String!, $start: DateTime!, $end: DateTime!) {
-	user(login: $user) {
-		contributionsCollection(from: $start, to: $end) {
-			commitContributionsByRepository(maxRepositories: 100) {
-				repository {
-					nameWithOwner
-				}
-				contributions {
-					totalCount
-				}
-			}
-		}
-	}
-	rateLimit {
-		cost
-		remaining
-	}
+  user(login: $user) {
+    contributionsCollection(from: $start, to: $end) {
+      commitContributionsByRepository(maxRepositories: 100) {
+        repository {
+          nameWithOwner
+        }
+        contributions {
+          totalCount
+        }
+      }
+    }
+  }
+  rateLimit {
+    cost
+    remaining
+  }
 }
 ```
 
 Query variables:
 
 ```json
 {
-	"user": "YOUR_USER",
-	"start": "2022-01-01T00:00:00Z",
-	"end": "2022-12-31T00:00:00Z"
+  "user": "YOUR_USER",
+  "start": "2022-01-01T00:00:00Z",
+  "end": "2022-12-31T00:00:00Z"
 }
 ```
 
 ## How many reviews are made by the IC?
 
 ```gql
 query ($query: String!) {
-	search(last: 100, query: $query, type: ISSUE) {
-		nodes {
-			... on PullRequest {
-				number
-				title
-				createdAt
-				mergedAt
-			}
-		}
-		pageInfo {
-			hasNextPage
-			endCursor
-		}
-	}
-	rateLimit {
-		cost
-		remaining
-	}
+  search(last: 100, query: $query, type: ISSUE) {
+    nodes {
+      ... on PullRequest {
+        number
+        title
+        createdAt
+        mergedAt
+      }
+    }
+    pageInfo {
+      hasNextPage
+      endCursor
+    }
+  }
+  rateLimit {
+    cost
+    remaining
+  }
 }
 ```
 
 Query variables:
 
 ```json
 {
-	"query": "created:2022-01-01..2022-12-31 reviewed-by:YOUR_USER"
+  "query": "created:2022-01-01..2022-12-31 reviewed-by:YOUR_USER"
 }
 ```
 
 ## How many comments are made by the IC?
 
 ```gql
 query ($query: String!) {
-	search(last: 100, query: $query, type: ISSUE) {
-		nodes {
-			... on Comment {
-				createdAt
-			}
-		}
-		pageInfo {
-			hasNextPage
-			endCursor
-		}
-	}
-	rateLimit {
-		cost
-		remaining
-	}
+  search(last: 100, query: $query, type: ISSUE) {
+    nodes {
+      ... on Comment {
+        createdAt
+      }
+    }
+    pageInfo {
+      hasNextPage
+      endCursor
+    }
+  }
+  rateLimit {
+    cost
+    remaining
+  }
 }
 ```
 
 Query variables:
 
 ```json
 {
-	"query": "created:2022-01-01..2022-12-31 commenter:YOUR_USER"
+  "query": "created:2022-01-01..2022-12-31 commenter:YOUR_USER"
 }
-```
+```
diff --git a/gistfile1.txt → ic-metrics-gh-graphql-api.md b/gistfile1.txt → ic-metrics-gh-graphql-api.md
diff --git a/gistfile1.txt b/gistfile1.txt
@@ -0,0 +1,99 @@
+# Get Individual Contributor metrics from GitHub's GraphQL API
+
+Description.
+
+## How many pushes are made by the IC?
+
+```gql
+query ($user: String!, $start: DateTime!, $end: DateTime!) {
+	user(login: $user) {
+		contributionsCollection(from: $start, to: $end) {
+			commitContributionsByRepository(maxRepositories: 100) {
+				repository {
+					nameWithOwner
+				}
+				contributions {
+					totalCount
+				}
+			}
+		}
+	}
+	rateLimit {
+		cost
+		remaining
+	}
+}
+```
+
+Query variables:
+
+```json
+{
+	"user": "YOUR_USER",
+	"start": "2022-01-01T00:00:00Z",
+	"end": "2022-12-31T00:00:00Z"
+}
+```
+
+## How many reviews are made by the IC?
+
+```gql
+query ($query: String!) {
+	search(last: 100, query: $query, type: ISSUE) {
+		nodes {
+			... on PullRequest {
+				number
+				title
+				createdAt
+				mergedAt
+			}
+		}
+		pageInfo {
+			hasNextPage
+			endCursor
+		}
+	}
+	rateLimit {
+		cost
+		remaining
+	}
+}
+```
+
+Query variables:
+
+```json
+{
+	"query": "created:2022-01-01..2022-12-31 reviewed-by:YOUR_USER"
+}
+```
+
+## How many comments are made by the IC?
+
+```gql
+query ($query: String!) {
+	search(last: 100, query: $query, type: ISSUE) {
+		nodes {
+			... on Comment {
+				createdAt
+			}
+		}
+		pageInfo {
+			hasNextPage
+			endCursor
+		}
+	}
+	rateLimit {
+		cost
+		remaining
+	}
+}
+```
+
+Query variables:
+
+```json
+{
+	"query": "created:2022-01-01..2022-12-31 commenter:YOUR_USER"
+}
+```
No results found