How to get GitHub projectv2_item fields in key values using GraphQL?

[petrabarus]

Select Topic Area

Question

Body

I want to export my GitHub Projects periodically to spreadsheet using GraphQL. I have multiple projects that have similar fields, e.g. Sprint, Epic, Deadline, Story Point.

I use GitHub Webhooks to send events to my AWS Lambda on Issue & Project update.

I successfully query the GraphQL using the simple query below:

query {
        node(id: "PVTI_abcdefg_abcd") {
            __typename
            ... on ProjectV2Item {
                fieldValues(first: 100) {
                    totalCount
                }
            }
        }
    }

It successfully return this

{
    "data": {
        "node": {
            "__typename": "ProjectV2Item",
            "fieldValues": {
                "totalCount": 3
            }
        }
    }
}

I want to return the fields in that node in String -> String Key Value format.

e.g.

{
   "fieldA": "valueA",
   "fieldB": "valueB",
   "fieldC": "valueC"
}

How should I do it?

[Winner960111]

To get the field values in a key-value format, you can use the following GraphQL query:
query($projectId: ID!) { node(id: $projectId) { __typename ... on ProjectV2Item { fieldValues(first: 100) { nodes { name value } } } } }
This query will return the field values as an array of objects, where each object has a name and a value property.

You can then transform the result into a JSON object with the desired format:
`import json
import os
import boto3
from github import GraphQLClient

def lambda_handler(event, context):
# Retrieve the project ID from the event
project_id = event["project_id"]

# Initialize the GraphQL client
graphql_client = GraphQLClient(os.environ["GITHUB_TOKEN"])

# Execute the GraphQL query
response = graphql_client.execute(
    """
    query($projectId: ID!) {
      node(id: $projectId) {
        __typename
        ... on ProjectV2Item {
          fieldValues(first: 100) {
            nodes {
              name
              value
            }
          }
        }
      }
    }
    """,
    variables={"projectId": project_id},
)

# Transform the result into a dictionary
field_values = {
    item["name"]: item["value"]
    for item in response["data"]["node"]["fieldValues"]["nodes"]
}

# Save the field values to a spreadsheet or send them to another service
print(json.dumps(field_values))

return {
    "statusCode": 200,
    "body": json.dumps(field_values),
}`

This Python script uses the github library to execute the GraphQL query and transform the result into a dictionary. You can then save the field values to a spreadsheet or send them to another service, such as an AWS S3 bucket or an external API.

[petrabarus]

@Winner960111

this is for the Project V2 Item, not Project V2. I assume this is the fields and values that tied to the issues.

I tried this

    const query = `query {
        node(id: "${node_id}") {
            __typename
            ... on ProjectV2Item {
                fieldValues(first: 100) {
                    nodes {
                        __typename
                    }
                }
            }
        }
    }`

but it returns this

{
    "data": {
        "node": {
            "__typename": "ProjectV2Item",
            "fieldValues": {
                "nodes": [
                    {
                        "__typename": "ProjectV2ItemFieldRepositoryValue"
                    },
                    {
                        "__typename": "ProjectV2ItemFieldTextValue"
                    },
                    {
                        "__typename": "ProjectV2ItemFieldSingleSelectValue"
                    }
                ]
            }
        }
    }
}

I just want to get those field names and values in string.