Is there a way to simplify my query for a more concise data return with key:value pairs?

monday Apps & Developers
1

I am currently sending a query and getting the data returned from my board:

const query = `{
            boards(ids: ${state.mondayBoardId}) {
                groups(){
                    title
                    items(limit: 50){
                        column_values{
                            text
                        }
                    }
                }
            }
        }`

The query returns an array of objects (rows). Each object or row has an array of items (column values).

 [{…}, {…}, {…}, {…}, {…}, {…}, {…}, {…}, {…}, {…}]
  1. column_values: Array(9)
             1. 0: {text: "ARI"}
             2. 1: {text: "Fitzgerald"}
             3. 2: {text: "Larry"}
             4. 3: {text: "WR"}
             5. 4: {text: "11"}
             6. 5: {text: "Arizona Cardinals"}
             7. 6: {text: "Cardinals"}
             8. 7: {text: ""}
             9. 8: {text: ""}
             10. length: 9
  2. 1: {column_values: Array(9)}
  3. 2: {column_values: Array(9)}
  4. 3: {column_values: Array(9)}
  5. 4: {column_values: Array(9)}
  6. 5: {column_values: Array(9)}

If I’m referencing a column value I can’t call it out as a key:value pair but instead have to get the value by index. If I for some reason change the order of my columns in a board it will throw off the index value.

Is there a way to flatten the return to get an array of objects each having key:value pairs for each column? Something more like this?

1. Array(34)
      1. 0:
             1. jerseyNumber: "jerseyNumber"
             2. nameFirst: "nameFirst"
             3. nameLast: "nameLast"
             4. position: "position"
             5. teamFullName: "teamFullName"
             6. teamMascot: "teamMascot"
             7. teamTri: "teamTri"
             8. __proto__: Object

      2. 1: {teamTri: "ARI", nameLast: "Fitzgerald", nameFirst: "Larry", position: "WR", jerseyNumber: "11", …}
      3. 2: {teamTri: "ATL", nameLast: "Jones", nameFirst: "Julio", position: "WR", jerseyNumber: "11", …}
      4. 3: {teamTri: "BAL", nameLast: "Harbaugh", nameFirst: "John", position: "COACH", jerseyNumber: "11", …}
      5. 4: {teamTri: "BUF", nameLast: "Kromer", nameFirst: "Aaron", position: "COACH", jerseyNumber: "11", …}
      6. 5: {teamTri: "CAR", nameLast: "Newton", nameFirst: "Cam", position: "QB", jerseyNumber: "11", …}
      7. 6: {teamTri: "CHI", nameLast: "Cutler", nameFirst: "Jay", position: "QB", jerseyNumber: "11", …}
      8. 7: {teamTri: "CIN", nameLast: "Green", nameFirst: "A.J.", position: "WR", jerseyNumber: "11", …}
      9. 8: {teamTri: "CLE", nameLast: "Greco", nameFirst: "John", position: "DE", jerseyNumber: "11", …}
2

Hi @sbaden,

Which language are you using?

You may need to create a new array using the data in the format you need.

3

Hey @sbaden,

You could do something like a for loop to parse through the JSON response and assign the values to a dictionary in Python. For example, if you’re trying to get a list of teams:

board_list = []
    for t in parsed_json ['data']['boards']['groups']['title']['items']['column_values']:
         board_list.append(int(t['text']))

The API can accept back dictionary values if you declare the variable accordingly with something like [Int!] as your variable declaration.

Hope this helps!

4

It seems to require multiple passes to get a flat usable set of current column values by column name using GraphQL API.

A secondary issue is you may want the “key” to be the column title - the query syntax appears to only allow access by column ID (internal value).

I was able to do something similar in 3 parts (in Zapier)

  1. Get the columns for the board
{
  boards(ids: {{94553960__event__boardId}}) {
    owner {
      id
    }
    columns {
      title
      type
      id
    }
  }
}
  1. In JavaScript make a key:value pair of column title and name
output = {};
inputData.columnTitles.split(',').forEach((key, i) => output[key] = inputData.columnIds.split(',')[i]);
  1. Use the output of that to get a specific column value by its ID from the previous step
{ items(ids: [{{94553960__event__pulseId}}]) { column_values(ids:["{{94574036__Bug Ref}}"]) { text } } }

You could maybe loop through something similar to step 3 for all columns in a keyvalue pair (maybe using a similar syntax to the JavaScript above.

I’m interested to see if you are able to make this work so please provide an update if you have advanced this. Thanks!