PR musst be linked to the project through the project not pr

Reet00 · Reet00 · commit e8f657bf5853 · 2024-11-21T18:36:33.000+01:00
Adding the project to the pr will not include it to the projet itself
and therfore not provide a node id (required for moving columns)

Signed-off-by: Samreet &lt;samreet.singh@iteratec.com&gt;
diff --git a/.github/workflows/move-dependabot-pr-to-review.yaml b/.github/workflows/move-dependabot-pr-to-review.yaml
@@ -9,38 +9,47 @@ on:
 
 
 jobs:
-  move-dependabot-pr-to-review:
-    env:
-      PR_NUMBER: ${{ github.event.pull_request.number}}
+  move-dependabot-pr-to-review:   
     runs-on: ubuntu-22.04
     steps:
       - uses: actions/checkout@v4
 
       - name: Add dependabot PR to project
         run: |
+          # Get the ID for the field Status 
+          # gh project list --owner secureCodeBox
+          secureCodeBoxV4ProjectID="PVT_kwDOAg-Nic05GQ"
+
           # Add item to project
-          gh pr edit $PR_NUMBER --add-project "secureCodeBox v4"
+          echo prNodeID=$(gh api graphql -f query='
+            mutation {
+              addProjectV2ItemById(input: {projectId: "$secureCodeBoxV4ProjectID" contentId: "$PR_ID"}) {
+                item {
+                  id
+                }
+              }
+            }' | jq '.data.addProjectV2ItemById.item.id') >> $GITHUB_ENV
         env: 
           GH_TOKEN: ${{ secrets.SCB_BOT_USER_TOKEN }} 
+          PR_ID: ${{ github.event.pull_request.node_id }}
 
       - name: Add dependabot PR to column To Review
         run: |
           # Get the ID for the field Status 
           # gh project field-list 6 --owner secureCodeBox
           StatusFieldID="PVTSSF_lADOAg-Nic05Gc4AAZuO"
-          
-          # Get the projectID
-          # gh project list --owner secureCodeBox
+
           secureCodeBoxV4ProjectID="PVT_kwDOAg-Nic05GQ"
 
           # ID for status "To Review"
           ToReviewID="00b0c876"
 
+          prNodeID=${{env.prNodeID}}
           # Move PR to "To Review" status
-          gh project item-edit --id $PR_ID --field-id $StatusFieldID --project-id $seureCodeBoxV4ProjectID --single-select-option-id $ToReviewID
+          gh project item-edit --id ${{ env.prNodeID }} --field-id $StatusFieldID --project-id "$seureCodeBoxV4ProjectID" --single-select-option-id "$ToReviewID"
           
           
-          # This command gets theIDs for the status options
+          # This command gets the IDs for the status options
           #gh api graphql -f query='
           #  query {
           #    organization(login: "secureCodeBox") {
@@ -112,5 +121,4 @@ jobs:
           #  }
           #}
         env:
-          GH_TOKEN: ${{ secrets.SCB_BOT_USER_TOKEN }} 
-          PR_ID: ${{ github.event.pull_request.node_id }}
+          GH_TOKEN: ${{ secrets.SCB_BOT_USER_TOKEN }} 
